Career Evolutions is looking for a Senior ETL/Data Integration Developer for a fast-growing company headquartered in Scottsdale, AZ. Full-time, direct hire opportunity with compensation up to $125,000.
Job Summary:
The successful candidate will be able to build high quality and innovative solutions in a fast pace growing Franchise Company. As a Senior ETL/Data Integration Developer, 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:
Understand requirements, develop design and technical specification documents and perform impact analysis
Perform Unit and Integration Testing
Maintain ETL and the supporting data objects for our growing BI infrastructure
Schedule and monitor ETL processes
Create simple to complex analytical solutions
Design and maintain complex data schema projects
Identify architectural improvements to enhance ETL performance and workflows
Collaborate with BI Developers to build extendable analytical data models
Provide ad hoc data requests
Troubleshoot production issues and performance tuning of query performance, ETL performance and report performance
Work with 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)