Remote Data Warehouse Developer
at Applied Technology Services

Summary

Join our team at ATS to help customers solve problems with a wide array of technology solutions. We are seeking a Data Warehouse Developer - ETL to support the Data Analytics Team in retrieving data from multiple systems.

Requirements

• Thorough knowledge of the principles and practices of software development best practices
• At least five years of experience in ETL methodologies and development
• Degree from an accredited college with a bachelor’s degree in computer science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications, or a related field. May be substituted with relevant software development experience of 5 or more years
• 3+ years of SSIS experience
• Experience working with Azure SQL Instance
• Skill in SQL Server scripting
• Skill in data modeling
• Skill in the operation of computers and peripheral equipment
• Skill in creative and analytic problem solving
• Understanding of Data Warehousing principles, concepts, and architecture
• Ability to manage multiple priorities and meet project delivery dates
• Ability to effectively analyze and manage requirements
• Ability to visualize complex issues
• Knowledge of personal computers, Microsoft Office suite of tools including Word, Excel, PowerPoint, and Visio
• Knowledge of programming concepts and the Software Development Lifecycle (SDLC)

Responsibilities

• Support the Data Analytics Team in retrieving data from multiple data systems for use in data extracts, reports, and dashboards to ensure data quality before release
• Create, execute, and monitor ETL processes including tracking and documenting findings
• Create test scripts using SQL programming to validate data points against transactional systems and the data warehouse
• Creating documentation needed to support repeatability of testing metrics

Benefits

• Competitive compensation
• Health benefits including Medical, Dental and Vision
• Vacation and Personal Days
• 401K
• Employee Assistance Plan
• Continuous education and learning opportunities