Lead ETL DEVELOPER
Diverse Lynx - Baltimore, Maryland, United States, 21276
Work at Diverse Lynx
Overview
- View job
Overview
Baltimore. MD- 3 Days Onsite 2 days remote Experience: 10+ Year Duration: Long term
Alongside a team, the ETL/ELT Developer will be responsible for the development of integrations employing industry standard tools for data extraction, transformation and loading (ETL) to / from core critical enterprise systems. The ETL developer should specialize in designing, building, and maintaining data pipelines that move data to / from various sources and to / from cloud-based data warehouses or data lakes. They will focus on ensuring data is extracted, transformed, and loaded efficiently and reliably for analytics and other downstream systems uses.
The ETL/ELT Developer Responsibilities:
Data Transformation:
Develop and optimize data transformations using cloud-based tools and technologies to cleanse, enrich, aggregate, and reshape data according to business requirements.
Load transformed data into cloud data warehouses (like Snowflake, Azure Synapse, or BigQuery ) or data lakes for storage and further analysis.
Performance Optimization
: Ensue efficient data processing and pipeline performance within on-premises and cloud environments by leveraging cloud-native services and optimizing resource utilization.
Utilizing cloud-specific tools and services (e.g., FiveTran, Snowpipe, Streams and Tasks, Azure Data Factory) for ETL processes.
Orchestration and Automation
: Automate ETL workflows using orchestration tools or cloud-based workflow services. Data Integration
: Design and implement ETL pipelines that extract data from diverse cloud and on-premises sources (databases, APIs, files, etc.). Collaborate with data analysts, systems analysts, developers and other stakeholders to understand data requirements and ensure the successful delivery of data for analytics and other business needs. Create and/or update knowledge base articles regarding procedures, workflows, user guides, process run books, etc. Participate within the change management process. Job Requirements
BS in Information Systems, Information Technology, or a related field is required.
Work experience in lieu of degree or concentration is acceptable. Minimum of 5 - 7 years of similar work experience as a ETL Developer in a comparable environment and industry. Snowflake
- Intermediate level knowledge required. Proficiency in Python and/or R is a plus Excellent analytical and troubleshooting skills. Excellent organizational, teamwork and time management skills. Excellent oral and written communication skills. Ability to handle multiple parallel tasks.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.