$100K - 140K a year
Design and develop enterprise data warehouse and Power BI semantic models, build ETL pipelines, implement data quality and governance frameworks, and support AI integration.
Bachelor's degree with 6+ years in data warehouse design, 4+ years advanced Power BI development, expert DAX and data modeling skills, strong SQL and ETL experience, and knowledge of AI data requirements.
Description: • Design enterprise data warehouse solutions using dimensional modeling and modern architecture patterns • Develop ETL/ELT pipelines using enterprise data integration platforms (e.g. Azure Data Factory, SSIS, etc.) to integrate data from multiple sources including Redshift • Assess, integrate, and extend existing enterprise data assets • Implement data quality frameworks and automated monitoring systems • Establish data lineage tracking and metadata management processes for governance • Architect Power BI semantic models optimized for performance, scalability, and business usability • Integrate certified enterprise semantic models with custom data models to create comprehensive business intelligence solutions • Create sophisticated Power BI dashboards and reports with advanced DAX calculations and complex business logic • Build automated reporting solutions and self-service analytics capabilities • Design Power BI workspace structure, deployment pipelines, and version control processes • Design data architectures and semantic models with AI-readiness in mind for Copilot and generative AI integration • Create well-structured data models with proper metadata and context to support AI initiatives • Establish data quality and governance frameworks that will support AI model training and validation • Build semantic layers optimized for natural language processing and conversational analytics capabilities Requirements: • Bachelors degree with 6+ years of experience in data warehouse design and implementation • 4+ years of advanced Power BI development experience including complex semantic modeling • Expert-level DAX and Power Query (M language) skills for enterprise-scale data models • Expert knowledge of dimensional modeling, star schema design and modern data architecture patterns • Strong proficiency with cloud data services and analytics platforms • Advanced SQL skills and database performance optimization experience • Demonstrated expertise with ETL/ ELT tools and data integration platforms • Experience with advanced Power BI features including calculated tables, measures and complex relationships • Knowledge of Power BI performance optimization, caching strategies and user experience design • Experience with Power BI Dataflows, Microsoft Fabric, and Power Platform integration • Experience evaluating and extending existing enterprise semantic models and certified dataflows • API development and integration patterns for data connectivity • Version control systems and collaborative development practices • Enterprise data consolidation from multiple source systems • Understanding of data requirements for machine learning and AI Model integration • Knowledge of data preparation best practices that support AI initiatives • Experience with semantic layer design principles for natural language processing Benefits: • medical, dental, vision • paid time off • 401(k) plan with employee and company contribution opportunities • life, disability, and accident insurance • tuition reimbursement
This job posting was last updated on 10/7/2025