The Sr. ETL developer will work as part of the Data Services team reporting to the Director of Enterprise Data. They will be primarily responsible for implementing ETL processes that populate Kimball style star schemas using a variety of source data on multiple SQL Server 2014 data warehouse implementations supporting multiple products. They will also participate in the requirements gathering process and assist with designing the business process dimensional models. The candidate will have a deep understanding of both OLTP and star schemas with OLAP being a huge plus. Further, they will do deep analysis on source data to determine the feasibility of using this data to solve business needs. The resulting ETL processes should be scalable, efficient, audited and as re-usable as possible.
Develop, design, tune and maintain SSIS packages to perform the ETL process.
Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
Perform data profiling and source to target mappings (while capturing ETL and business metadata) for populating Kimball style dimensional models.
Write scripts for automated testing of data in the target facts and dimensions.
Capture audit information during all phases of the ETL process.
Write and maintain documentation of the ETL processes via process flow diagrams.
Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.
Collaborate with business users, other data services team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.
Skills and Experience
5+ years SQL Server Experience
5+ years SSIS Experience
3-5 years of experience with data warehousing and business intelligence projects.
Preferred (should have a few):
Dimensional modeling experience preferably with a modeling tool such as Idera, Toad Data Modeler, ERwin, Embarcadero etc.
Experience with SSAS and MDX
Real-time data warehousing Aggregation of analytical data in a data warehouse using continuous or near real- time loads
Operational reporting and dashboards
Experience pulling data from a variety of data source types (Postgres a plus).
Cloud experience with AWS or Azure
Familiarity with the Kimball lifecycle
Java and/or .NET experience a plus
Strong experience interfacing with business users and understanding their requirements