Responsibilities
- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities
- Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
- Maintain and improve already existing processes
- Ensure that the data architecture is scalable and maintainable
- Work with the business in designing and delivering correct, high quality data
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
- Prepare documentation for further reference
- Perform other duties as assigned
- Microsoft SQL Server knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
- Knowledge of data modeling principles
- Organizational skills, including time management and planning
- Knowledge, Skills, and Abilities:
- Knowledge of data extraction from various SQL/NoSQL data storage mechanisms and Big Data technologies
Minimum Qualifications:
- Bachelor’s degree in related field or equivalent combination of education and experience
- 5+ years relevant experience to include:
- Python and/or Powershell
- Microsoft SQL Server Integration Services (SSIS)
Preferred Qualifications:
- 2+ years of experience with Talend ETL and other ETL systems
- 2+ years of experience with the full development lifecycle and associated change management process
- 2+ years of experience with JIRA for task tracking
- 2+ years of experience with Confluence for documentation
