Career Evolutions is looking for a Senior ETL Integration Developer for a fast-growing company headquartered in Scottsdale, AZ. Full-time, direct hire, opportunity with compensation up to $115,000.
Job Title: Senior ETL Integration Developer
Job Summary: You will build high quality and innovative solutions in a fast pace growing Franchise Company. You will be responsible for designing/architecture and implementing and monitoring highly scalable Data Warehouse/Data Mart solutions. Maintenance and support for legacy ETL processes
Responsibilities:
Analyze requirements, develop design and technical specification documents and perform impact analysis
Execute Unit and Integration Testing
Maintain ETL and the supporting data objects for our growing BI infrastructure
Schedule and monitor ETL processes
Make simple to complex analytical solutions
Design and maintain complex data schema projects
Determine architectural improvements to enhance ETL performance and workflows
Work with BI Developers to build extendable analytical data models
Troubleshoot production issues and performance tuning of query performance, ETL performance and report performance
Participate on onsite development teams, as well as, various 3rd party vendors and offsite resources
Qualifications:
Bachelors of Science degree in Information Technology or equivalent
7-10 years’ experience with Data Integration (SSIS) including change data capture, auditing and logging
7-10 years’ SQL Server database development (T-SQL, stored procedures, Database Object Creation)
Experience with Dimensional Modeling (Erwin, ER Studio, …)
Experience with Enterprise Data Hub
Proven experience in data management, data quality and interpretation across complex data sets (10 terabyte and above with multiple data sources)