Data Warehouse Analyst - 3430

Our Fortune 500 client is looking for a Data Warehouse Analyst on their project based in Tallahassee, FL

Job Title: Data Warehouse Analyst

Location: Tallahassee, FL-Onsite

Duration: Long-term

Job Description:

Duties:

• Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
• Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
• Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
• Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
• Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
• Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
• Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.

 Experience

• Required minimum of 5 years of IT work experience in business intelligence tools and systems.
• 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.
• Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
• Strong understanding of star schema design and fact/dimension modeling.
• Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
• Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
• Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
• Experience in integrating Power BI with Snowflake and connection modes.
• Proficiency in Power BI Report Builder, workspace management, and performance optimization.
• Experience with metadata management, data lineage, and documentation.
• Experience embedding Power BI reports into web or internal applications.
• Knowledge of CI/CD for Power BI and version control is a plus.

 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.

Please send your updated Word-format resume along with your best contact details to  or call me at .                               

Stellar IT Solutions is a Global IT Solution provider headquartered in Rockville, MD, with operations in the US and India. Stellar IT Solutions has over 15 years of IT and consulting experience to give cost-effective solutions to many Fortune 500 companies.