Sr Data Warehouse Developer
Core
Architecting, designing, developing, and supporting enterprise data warehouse components and data integration processes.
Role type
Senior Data Warehouse Developer
Builds
Enterprise data warehouse and associated data sources
Domain
Healthcare data analytics (OMOP model), Data Warehousing, Business Intelligence
Required skills
Data warehouse modeling, ETL development, SQL/PLSQL, UNIX scripting, Dimensional modeling, Data integration architecture, Informatica, SQL Server, Oracle, Boomi, Denodo
Preferred skills
OMOP data model, BI metadata tools, Service-oriented architecture, Informatica IDMC/MDM, MS SQL Server Tools
Technologies
Informatica, Denodo, SQL Server, SSIS, Oracle Data Integrator, Boomi AtomSphere, OMOP
Responsibilities
Architect data integration and transformation processes across on-premises and cloud data sources; Develop data models and database designs leveraging data warehouse best practices; Collaborate with reporting teams to convert business requirements into technical specifications; Provide on-call support for business continuity and operations; Mentor staff and demonstrate best practices.
Seniority
Senior, hands-on IC