Job Title: ETL Developer
Job Level: Individual Contributor
Job Family: Technology
Job Type: Full-time

FLSA Classification: Exempt
Department: Technology
Reports to: Director of Technology
Location: Boulder, CO 80301 (Only Considering Local Candidates)

Job Summary: This ETL Developer is responsible for the timely capture, evaluation, and load of retail point of sales (POS) data for cleansing and integrating into BDS Analytics proprietary systems. The ideal candidate has experience using or evaluating retail POS data, knowledge of standard retail measures, has a keen eye for detail, and can quickly identify and resolve issues.

Essential Functions and Responsibilities:

• Provide first and second level troubleshooting, baseline and operational support
• Design, document and implement new ETL and enhancements and modify existing code
• Work independently to develop, configure, and unit test programs from specs (source to target mappings)
• Work closely with data architects, reporting team and application team on ETL development
• Design and document ETL solutions for projects, estimate work effort and oversee delivery
• Identify improvements to the data warehouse environment. Work with the team to implement these solutions
• Develop automation of data acquisition, transformation and movement. Adapt ETL/Integration processes to accommodate changes in source systems and new business user requirements. Strive to continuously improve solution delivery processes and practices
• Adhere to best practices and methodologies for ETL development Escalate issues to the right party when required
• Perform other duties as assigned

Job-related Education and/or Experience:

• Bachelor’s Degree in Computer Science or Information Systems; or equivalent combination of education and relevant experience
• 3-5 years of experience with relational databases
• Knowledge of ETL (Extract, Transform and Load processes)
• Ability to work collaboratively with diverse groups and establish ongoing relationships
• Capable of quickly understanding how systems are used in order to provide efficient support
• Demonstrated outstanding customer orientation using strong communication skills
• Ability to lead meetings with technical peers regarding BI/Integration solutions
• Ability to handle multiple projects and deadlines with minimal supervision
• Ability to be agile and work in a complex environment
• Knowledge of SQL programming using Microsoft SQL-Server T-SQL
• Familiarity with GIT
• Experience with ETL tools such as SSIS
• Basic knowledge of manipulating CSV files via Python a plus
• Ability to work in a team environment 

Conditions of Employment: Pre-employment background check

Work Environment: Normal office environment

Travel: 0%

BDS Analytics, Inc. is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate based on race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition
pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.