Vacancy expired!
- Design and implement a flexible platform for operational data stores, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams for strategic data management
- Develop extracts, transforms, and loads with SSIS required. Python a big plus
- Drive Azure cloud data platform architectural decisions and development standards
- Implement and govern a source control strategy through DevOps
- Actively contribute towards data migration tasks from on-premises to cloud
- Multi-task across several ongoing projects and daily duties of varying priorities as required
- Ability to make good judgments, decisions, negotiate and problem solve
- Create detailed technical specifications and release documentation for assigned ETL and reporting projects
- Experience with Data Warehousing methodologies and concepts (Kimball)
- Extensive experience with BI/DW lifecycle including source data analysis, ETL, data marts, reporting, dashboards, and analytics
- 8+ years of experience working with MS SQL Server database. Mastery of SQL, specifically MS SQL Server 2012 and higher.
- 8+ years of experience developing ETL processes with large scale data warehouses required
- 8+ years of experience with Microsoft BI stack (SSIS, SSRS and SSAS). Python a big plus.
- 2+ years working in DevOps, automating, and deploying packages between different environments
- 2+ years of experience with Azure SQL Database, Azure Data Factory, Azure SQL Data Warehouse, Azure Synapse Analytics, and related Azure services is strongly preferred
- Experience with NoSQL data (JSON, etc.) a big plus
- Experience with Healthcare data not required, but highly desirable
- High proficiency in dimensional modeling techniques and their applications including star schemas
- Familiarity with Data Governance and Master Data Management principles
- Strong verbal and written communication skills for collaboration with business stakeholders and technical peers
Vacancy expired!