Data Migration Specialist
CoreSphere, LLC
ETL
Data Architect – AVS Digital Transformation
GE HealthCare
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $117,600 - $176,400 per year
Job Level
Mid-LevelSenior
Tech Stack
Amazon RedshiftAzureCloudETLSQLSSIS
About the role
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data warehouse designETLELTDAXPower Querydimensional modelingSQLdata integrationsemantic modelingdata performance optimization
