Data Warehouse Analyst

Data Warehouse Analyst / Power BI DeveloperLocation: Tallahassee, FL (Onsite)Job Type: ContractExperience Level: Intermediate/SeniorJob SummaryWe are seeking an experienced Data Warehouse Analyst / Power BI Developer to develop and optimize enterprise analytics solutions using Microsoft Power BI and Snowflake. This role involves building semantic models, dashboards, and analytical reports; developing advanced DAX and SQL; optimizing data warehouse performance; and collaborating with data engineers and business stakeholders to deliver reliable, scalable, and actionable business intelligence solutions.ResponsibilitiesDesign and develop Power BI semantic models and dataflows using dimensional modeling and star schema principles.Build advanced DAX measures and analytical logic for enterprise reporting.Create intuitive, high-performance Power BI dashboards and reports based on business requirements.Develop paginated reports using Power BI Report Builder.Write and optimize complex SQL queries, including CTEs, window functions, and analytical queries.Prepare and optimize Snowflake datasets for Power BI consumption.Collaborate with data engineering teams to ensure fact and dimension tables are properly structured and optimized.Integrate Power BI with Snowflake using appropriate connection modes while maintaining performance and data reliability.Monitor and troubleshoot performance issues across Power BI, DAX, SQL, and Snowflake environments.Support Snowflake performance tuning, compute optimization, clustering, and cost management.Apply Snowflake security concepts, including roles and role-based access control (RBAC).Document metadata, data lineage, report specifications, and analytical assets.Translate business requirements into structured data models and actionable reports.Support Power BI workspace management and report optimization.Collaborate with business stakeholders, subject matter experts, and technical teams to deliver enterprise reporting solutions.Support continuous improvement of analytics, reporting, and data warehouse processes.Required QualificationsBachelor''s degree in Computer Science, Information Systems, or a related field (or equivalent professional experience).Minimum 5 years of IT experience working with business intelligence tools and systems.3–5 years of hands-on experience developing enterprise-level Power BI reports, dashboards, and data models.Advanced Power BI experience, including DAX, data modeling, Power Query, and report design.Strong SQL skills, including CTEs, window functions, analytical queries, and query optimization.Strong understanding of dimensional modeling, star schemas, and fact/dimension design.Hands-on experience with Snowflake performance tuning and optimization.Experience developing Power BI semantic models using dimensional design principles.Experience integrating Power BI with Snowflake.Experience with Power BI Report Builder and workspace management.Experience with metadata management, data lineage, and technical documentation.Strong analytical, problem-solving, and communication skills.Preferred QualificationsExperience with Power BI embedded analytics.Experience embedding Power BI reports into web or internal applications.Experience with Snowflake RBAC, warehouse sizing, clustering keys, and cost optimization.Knowledge of CI/CD practices for Power BI.Experience with version control for analytics solutions.Experience supporting enterprise data warehouse environments.Ability to work independently with minimal supervision while collaborating effectively with data engineers, SMEs, and business stakeholders.Work EnvironmentFull-time contract100% onsite in Tallahassee, FloridaPrimarily standard business hours, with flexibility to support business needs when required.Direct applicants only. No third-party vendor or staffing firm submissions will be considered.