ALOIS Solutions

Data Warehouse Analyst

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Analyst with a contract length of "unknown" and a pay rate of "$XX/hr". The ideal candidate must have 5+ years of IT experience, strong Power BI and SQL skills, and hands-on Snowflake expertise.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
Unknown
-
πŸ—“οΈ - Date
August 11, 2026
πŸ•’ - Duration
Unknown
-
🏝️ - Location
Unknown
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Tallahassee, FL
-
🧠 - Skills detailed
#Scala #Data Management #Data Lineage #Metadata #Clustering #Snowflake #Documentation #DAX #BI (Business Intelligence) #Version Control #Microsoft Power BI #Semantic Models #Data Warehouse #Data Modeling #Data Governance #SQL (Structured Query Language) #Data Engineering #Computer Science #Dataflow #SQL Queries
Role description
For one of my direct client we are looking for an experienced Data Warehouse Analyst / Power BI Report Builder to develop and optimize enterprise-level Power BI reports, dashboards, and semantic models integrated with Snowflake. The ideal candidate will have strong hands-on experience with Power BI, advanced DAX, SQL, Snowflake, and dimensional data modeling, along with the ability to work closely with data engineering teams and business stakeholders. Key Responsibilities β€’ Design and develop Power BI dataflows, semantic models, dashboards, and analytical reports. β€’ Build advanced DAX measures and analytical calculations. β€’ Develop user-friendly, scalable, and high-performance Power BI reports and dashboards. β€’ Create and optimize complex SQL queries, including CTEs, window functions, and analytical queries. β€’ Integrate Power BI with Snowflake using appropriate connection modes. β€’ Work with data engineering teams to ensure fact and dimension tables are structured and optimized for Power BI consumption. β€’ Apply dimensional modeling and star schema principles to semantic model development. β€’ Troubleshoot performance issues across Power BI, DAX, SQL, and Snowflake. β€’ Support Snowflake performance tuning, compute optimization, clustering, and cost control. β€’ Maintain metadata, data lineage, report specifications, and documentation. β€’ Collaborate with business stakeholders and SMEs to translate business requirements into actionable reporting solutions. β€’ Support Power BI workspace management and performance optimization. β€’ Develop and maintain paginated reports using Power BI Report Builder. β€’ Work independently in a dynamic environment with minimal supervision. Required Qualifications & Experience β€’ Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience. β€’ 5+ years of IT experience working with business intelligence tools and systems. β€’ 3–5+ years of hands-on Power BI experience developing enterprise-level reports, dashboards, and data models. β€’ Strong experience with advanced DAX and Power BI semantic models. β€’ Advanced SQL skills, including CTEs, window functions, analytical queries, and query optimization. β€’ Strong understanding of star schema, dimensional modeling, and fact/dimension design. β€’ Hands-on experience with Snowflake, including performance tuning, compute optimization, clustering keys, and cost management. β€’ Understanding of Snowflake RBAC, roles, warehouse sizing, and data governance. β€’ Experience integrating Power BI with Snowflake. β€’ Experience with Power BI Report Builder and paginated reports. β€’ Strong understanding of Power Query and Power BI performance optimization. β€’ Experience with metadata management, data lineage, and technical documentation. β€’ Ability to translate business requirements into structured semantic models and effective reporting solutions. β€’ Strong communication, analytical, problem-solving, and stakeholder collaboration skills. Preferred / Plus β€’ Experience embedding Power BI reports into web or internal applications. β€’ Knowledge of CI/CD for Power BI. β€’ Experience with version control for Power BI solutions. Ideal Candidate We are looking for someone who can work across the complete analytics lifecycle: Snowflake β†’ SQL β†’ Data Modeling β†’ Power BI Semantic Models β†’ DAX β†’ Reports & Dashboards If you are a strong Power BI Developer / BI Developer / Data Warehouse Analyst with hands-on Snowflake experience and enjoy building enterprise reporting solutions, we would like to hear from you.