Data Warehouse Analyst

job summary:
Scope of Services

The Data Warehouse Analyst / Report Builder will develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creating advanced DAX calculations, writing and tuning complex SQL queries, and ensuring Snowflake datasets are modeled and structured for reliable Power BI consumption. The resource will work with data engineers to support dimensional modeling, maintain metadata and data lineage documentation, and ensure accurate, high-performance reporting. The Analyst will collaborate with stakeholders to translate business needs into actionable reports, troubleshoot performance issues across Power BI and Snowflake, and operate effectively in a dynamic environment with minimal oversight.

Education

Bachelor's degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.

Experience

1. Required minimum of 5 years of IT work experience in business intelligence tools and systems.

2. A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated

reports, performance tuning, and DAX.

3. Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.

4. Strong understanding of star schema design and fact/dimension modeling.

5. Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.

6. Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.

7. Proficient in building Power BI semantic models with strong DAX and clean dimensional design.

8. Experience in integrating Power BI with Snowflake and connection modes.

9. Proficiency in Power BI Report Builder, workspace management, and performance optimization.

10. Experience with metadata management, data lineage, and documentation.

11. Experience embedding Power BI reports into web or internal applications.

12. Knowledge of CI/CD for Power BI and version control is a plus.

Primary Job Duties/ Tasks

The activities the candidates will be tasked with include, but are not limited to, the following:

1. Design and develop Power BI dataflows and semantic models using dimensional modeling practices.

2. Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.

3. Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.

4. Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.

5. Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.

6. Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.

7. Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.

Job Specific Knowledge, Skills, and Abilities (KSAs)

The submitted candidates must be able to apply specific knowledge, skills, and abilities in the following areas:

1. Knowledge of dimensional modeling and star schema design for semantic model development.

2. Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query.

3. Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts.

4. Skill in building optimized, scalable Power BI semantic models using strong dimensional design.

5. Skill in writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption.

6. Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design.

7. Ability to translate business requirements into structured semantic models and actionable reports.

8. Ability to troubleshoot performance issues across DAX, SQL, and Snowflake compute layers.

9. Ability to collaborate effectively with data engineers, SMEs, and stakeholders to deliver enterprise-ready reporting solutions.

 
location: Tallahassee, Florida
job type: Contract
salary: $50 - 55 per hour
work hours: 8am to 5pm
education: No Degree Required

responsibilities:

Scope of Services

The Data Warehouse Analyst / Report Builder will develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creating advanced DAX calculations, writing and tuning complex SQL queries, and ensuring Snowflake datasets are modeled and structured for reliable Power BI consumption. The resource will work with data engineers to support dimensional modeling, maintain metadata and data lineage documentation, and ensure accurate, high-performance reporting. The Analyst will collaborate with stakeholders to translate business needs into actionable reports, troubleshoot performance issues across Power BI and Snowflake, and operate effectively in a dynamic environment with minimal oversight.

Primary Job Duties/ Tasks

The activities the candidates will be tasked with include, but are not limited to, the following:

1. Design and develop Power BI dataflows and semantic models using dimensional modeling practices.

2. Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.

3. Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.

4. Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.

5. Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.

6. Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.

7. Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.

qualifications:
Education

Bachelor's degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.

Experience

1. Required minimum of 5 years of IT work experience in business intelligence tools and systems.

2. A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated

reports, performance tuning, and DAX.

3. Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.

4. Strong understanding of star schema design and fact/dimension modeling.

5. Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.

6. Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.

7. Proficient in building Power BI semantic models with strong DAX and clean dimensional design.

8. Experience in integrating Power BI with Snowflake and connection modes.

9. Proficiency in Power BI Report Builder, workspace management, and performance optimization.

10. Experience with metadata management, data lineage, and documentation.

11. Experience embedding Power BI reports into web or internal applications.

12. Knowledge of CI/CD for Power BI and version control is a plus.

Job Specific Knowledge, Skills, and Abilities (KSAs)

The submitted candidates must be able to apply specific knowledge, skills, and abilities in the following areas:

1. Knowledge of dimensional modeling and star schema design for semantic model development.

2. Knowledge of advanced Power BI capabilities including DAX, data modeling, and Power Query.

3. Knowledge of Snowflake performance tuning, compute optimization, and RBAC security concepts.

4. Skill in building optimized, scalable Power BI semantic models using strong dimensional design.

5. Skill in writing advanced SQL queries and tuning Snowflake datasets for Power BI consumption.

6. Skill in creating high-performance Power BI reports with clean DAX logic and intuitive visual design.

7. Ability to translate business requirements into structured semantic models and actionable reports.

8. Ability to troubleshoot performance issues across DAX, SQL, and Snowflake compute layers.

9. Ability to collaborate effectively with data engineers, SMEs, and stakeholders to deliver enterprise-ready reporting solutions.

skills:
advanced report,CI/CD,data governance,data lineage,Data Warehouse,dimensional modeling,Document data,embedding,complex SQL queries,advanced SQL queries,data engineering,Information Systems,computer science,metadata management,metadata,performance tuning,performance optimization,Power BI,Microsoft Power BI,Power BI reports,Power Query,RBAC,SQL,Snowflake,version control,star schema,integrating,Create user,analytical,friendly,high-performance,business intelligence tools,business needs,business requirements,calculations,dashboards,semantic models,data models,data modeling,security concepts,governance,visual design,cost control,modeling,warehouse,documentation

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on randstadusa.com.


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.