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.
Leadership and Culture
We believe that energized people, working well together, fueled by great leadership in an inclusive environment in which they thrive, will do phenomenal things.
Core Knowledge and Skills
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
Education and Experience
Bachelor’s degree with 12+ years of architecture and hands-on development of Enterprise Data Warehouse environment with focus on Data Integration (ETL).
Reports to: Deputy Director, Global Data & Analytics
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.
The Bill & Melinda Gates Foundation is dedicated to the belief that all lives have equal value. We’re committed to creating a workplace where employees thrive both personally and professionally. We also believe our employees should reflect the rich diversity of the global populations we aim to serve—in race, gender, age, cultures and beliefs—and we support this diversity through all of our employment practices.
All applicants and employees who are drawn to serve the mission of the Bill & Melinda Gates Foundation will enjoy equality of opportunity and fair treatment without regard to:
From poverty to health, to education, the Bill and Melinda Gates foundation focuses on improving the lives of billions of people worldwide. There are four problem areas the organization focuses on; the Global Development Division, Global Health Division, United States Division, and Global Policy & Advocacy Division. In developing countries the foundation focuses on improving the health and welln...ess of people as well as helping children and families escape from extreme hunger and poverty. In the United States, the foundation focuses on low-income families and makes sure that everyone has opportunities to receive an education that will help them succeed. The foundation works with numerous organizations around the world to tackle critical problems and addresses challenging inequalities. The headquarters of this organization is based in Seattle, Washington, one of the most proactive global health and non-profit cities in the world.