Description

You will design and maintain data models, semantic models, and curated datasets for enterprise reporting while supporting ETL processes and production issue resolution.

This role is remote.

Responsibilities

• Design and maintain data models, semantic models, dataflows, and curated datasets for enterprise reporting.
• Write, troubleshoot, and optimize complex SQL queries, stored procedures, views, and transformation logic.
• Support ETL processes, pipeline monitoring, and production issue resolution.
• Guide BI developers and analysts on data structures, joins, business logic, and reporting best practices.
• Support UAT, documentation, end-user support, and post-deployment enhancements.

Required Skills

• 10+ years of experience with strong SQL Server expertise, including complex query development and performance optimization.
• Proven experience with ETL processes, dataflows, data marts, cubes, or data warehouse environments.
• Strong background in enterprise reporting dataset and semantic model design.
• Hands-on experience with Microsoft Fabric, Power BI, or Azure analytics platforms.
• Proficiency in Salesforce, CRM Analytics, or CRM/ERP integration experience.
• Experience with MDM platforms such as Syniti or similar tools for validation, mapping, and governance.
• Ability to work independently and manage multiple priorities with strong analytical and troubleshooting skills.

Preferred Skills

• Experience with Informatica, Azure Data Factory, SSIS, or similar ETL technologies.
• Knowledge of SQL Server tuning, Control-M, or production reporting support.
• Experience mentoring BI developers and leading cross-functional teams.

Key Skills

Education

Bachelor's degree