The primary responsibilities of the ETL Developer with EdgeCo Holdings includes the extraction, transformation, and loading of data from multiple source systems into the reporting data warehouse as well as the administration and maintenance of processes and procedures essential for the reporting of KPI metrics.
The ETL Developer reports to the Director of the Project Management Office, and is on point for designing, developing, testing, documenting, implementing, and providing ongoing support for KPI metric reporting.
This would be a hybrid role.
Duties and Responsibilities:
Design and implement ETL processes, programs, and scripts.
Assist with design and implementation of data warehouse and KPI metric reporting solutions.
Develop workflows and mappings to integrate data from various systems into the data warehouse.
Develop data quality processes and reporting.
Gather, refine, and document requirements.
Unit test workflows and mappings.
Troubleshoot and correct ETL solutions.
Develop data integrations using ETL methodology.
Implement best practice solutions per development standards.
Ensure documentation is created, maintained and accurate.
Understand the business processes, how the application supports the business process and apply that knowledge to develop solutions.
Bachelors degree in Computer Science, Information Systems, or equivalent experience in related field is required.
3+ years ETL experience to/from multiple sources of data such as SQL, Oracle, Vendor Product DB’s, Cloud Storage (Azure).
3+ years’ experience working in a data warehouse environment with multi-technology data sources in an Extract, Transform and Load (ETL) capacity.
3+ years’ experience working with relational and dimensional data models.
Experienced in using APIs for data retrieval.
Knowledge of and experience using Agile/SCRUM methodology, Azure DevOps, Jira, Power BI, Miro, and Monday.com is preferred.
Strong verbal and written communication skills, and interpersonal skills with the ability to interact with individuals at all levels of the organization.
Ability to multi-task, prioritize, and work efficiently while ensuring accuracy and attention to detail.
Energetic self-starter with the ability to work independently as well as be a motivated team player.