ETL Developer

Description

The Sr. Data Warehouse Engineer is a member of the Informatics EDW group which builds and supports the Enterprise Data Warehouse to deliver strategic business value to the organization. The Sr. DW Engineer will collaborate with product owners to plan and define requirements, and then with the implementation team to design, develop, test and maintain a high performance data warehouse environment. The DW architecture delivers BI capabilities including predefined, adhoc, dynamic reporting, OLAP analysis, and dashboards as well as data sharing interfaces with other systems. EducationMinimum Education RequirementsBachelors degree or equivalent combination of education and experience.Preferred EducationBachelors Degree Bachelors degree or advanced degree in computer sciences, mathematics, business administration, MIS, healthcare or public administration. Knowledge/SkillsMinimum Knowledge/Skills RequirementsIntermediate Requirements gathering Experience with ETL and ELT Experience with Quality Assurance and Testing in a relational database environment Experience in the implementation of end user analytical toolsets Experience working in an agile development methodology Handson programming and database design skills (primarily SQL and stored procedures) Experience designing Data Management processes and standards for Metadata Management, Data Architecture, Data Quality, and Data Security.Advanced Excellent analytical skills Excellent spoken, listening and written communication at various levels of the business. Ability to select and apply highly technical and specialized toolsets and quickly to adapt to changes and advances in technology for Data Warehousing (RDBMS, ETL, etc.), OLAP and BI systems. Strong data warehouse modeling expertise (i.e. integrated model, and star/snowflake schema data model). Subject Matter Expert (SME) in Business Intelligence/Data Warehouse (BIDW) data modelling best practices. Demonstrated experience developing measurement, business intelligence, and data warehousing solutions. ExperienceMinimum Experience Requirements10 or more years Information systems experience in a data warehouse/business intelligence, measurement or application development environment.8 years Demonstrated experience in two or more of the following Data analysis; requirements gathering; data modeling; ETL; ELT, quality assurance; testing of DW systems; BI reporting.