Responsible for the foundation’s overall enterprise data warehouse development effort by translating vision into action and partnering with project delivery teams to develop and strengthen the overall development and operational maturity of our Enterprise Data Warehouse. Collaborate with a community of data architect and BI developers to develop a new Data Warehouse and supporting ETL frameworks. Lead core software development activities as they pertain to development of an EDW. Regularly participate on projects to design, develop, troubleshoot and debug. Introduce repeatable patterns and approaches to our development and deployment standards across the EDW ecosystem. Provide guidance, mentorship, and technical expertise to the core developers on projects.
- Translate strategic project requirements into usable artifacts guiding to the development of reasonable and physical data models, source to target mapping, business rule encapsulation for transformation, and data validation routine.
- Provides and/or facilitates the planning, analysis, design, development, implementation, and maintenance of software, scripts and utilities that support timely and accurate data population of Enterprise Data Warehouse (EDW).
- Utilize existing standards to translate design and architecture artifacts to actual development units across various phases of the EDW development.
- Review completed code, documentation and other deliverables to ensure that they meet specifications and requirements based on defined expectations.
- Develop and maintain standards, including organization, structure and nomenclature, for the design of EDW elements (data architectures, models, tools, and databases)
- Participate in design review sessions leading up to code migration into production, ensures timely bug fixes, and provides guidance to business and technology management on process and technical issues.
- Work together with other ETL and EDW developers and architects to develop a cohesive performance tuning and management approach for the EDW ecosystem.
- Collaborate across multiple teams to research, architect, engineer and configure complex data warehouse solutions to specified requirements in support of global, business critical systems
- Document data warehouse designs, solutions, configurations, and teach/mentor other support tiers, team members and vendors including onboarding and knowledge transfer.
- Coordinate and oversee the assignments, delivery, and quality of other data warehouse developers
- Continuously improve system and data warehouse performance, automation, operations and processes.
- Minimum 10 Years of hands-on development and architecture design of Enterprise Data Warehouse environment with focus on Data Integration (ETL), Data Validation, and Orchestration through repeatable processes and frameworks.
- 10+ Years of attentive experience in developing Data Warehouse and ETL in SQL Server and Talend ETL environment.
- Demonstrated expertise in full data warehouse implementation and knowledge of both Kimball, Inmon, or hybrid approaches such as data vault.
- Hands on experience with data modeling, development of staging, EDW, and presentation layer (Star/Snow-Flake/Views).
- Full lifecycle perspective (requirements gathering through production deployment and support) in aspects of Business Intelligence solutions using platforms such as Microstrategy and Tableau.
- Proficient with SQL, Complex SQL Tuning, Stored Procedures, SQL Server Data Warehousing best practices, partitioning, indexing, constraints, and optimizer statistics.
- Hands on experience architecting and developing ETL in a Talend environment. Deep understanding of ETL framework – Developing Audit, Balance, Control, Validation architecture.
- Ability to work with Senior Enterprise Architects and Data Architects to develop EDW logical and physical roadmap, repeatable development and deployment frameworks etc.
- Proficient with working in a highly Agile (SCRUM) environment.
- Ability to advice senior IT management on Data Warehouse and ETL trends
As part of our standard hiring process for new employees, employment with the Bill and Melinda Gates Foundation will be contingent upon successful completion of a background check.