ETL Developer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
ETL Developer building Azure data pipelines and high-volume ETL systems for First American’s title insurance, settlement, and mortgage technology solutions.
Responsibilities:
- Develop, design, and implement ETL workflows using Azure Data Factory, Synapse Pipelines, Azure Data Lake, SQL, PySpark, and Synapse Spark Pools
- Develop complex ETL pipelines, data transformation logic, and integration processes for high-volume data processing
- Implement efficient data extraction, transformation, and loading strategies
- Set up, configure, and deploy ETL systems for optimal performance
- Monitor workflows, troubleshoot issues, and optimize data processing
- Review and refine pipelines to improve performance, scalability, and fault tolerance
- Collaborate with business stakeholders, architects, and team members to identify business logic and translate it into ETL processes
- Design and implement business rules, data validation logic, and complex transformations
- Ensure ETL design, coding standards, and data governance best practices
- Oversee code reviews and testing of ETL solutions
- Document ETL designs, business logic, and workflow processes
Requirements:
- 8–10 years of experience in data engineering and ETL development
- Hands-on experience with Azure Data Factory (ADF), Synapse Pipelines, Azure Data Lake, T-SQL/SQL, PySpark, Synapse Spark Pools, Azure Data Lake Storage Gen2 (ADLS), Delta Lake, Azure Synapse Analytics, and Data Vault
- Experience designing, developing, and deploying ETL workflows using DevOps CI/CD pipelines and processes
- Experience with high-performance data processing and data integration strategies
- Strong hands-on experience setting up Synapse pipelines and managing large-scale ETL processes
- Very good knowledge of data warehousing
- Advanced SQL proficiency, including query optimization, complex transformations, and large datasets
- Experience implementing complex business logic, data validation, transformation, and enrichment in ETL processes
- Experience with Azure SQL Database, Azure Data Lake, and Azure Blob Storage
- Experience with ETL tools and technologies such as Azure Synapse Analytics, PySpark, Synapse Spark Pools, and SSIS (good to have)
- Experience with ADLS Gen2 and Delta Lake
- Experience tuning, troubleshooting, and optimizing high-volume ETL pipelines
- Excellent knowledge of creating stored procedures, views, and functions
- Excellent communication and interpersonal skills
- Strong problem-solving ability
- Ability to handle multiple priorities, adapt to changing requirements, and meet deadlines
Benefits:
- Remote work arrangement
- Equal opportunity and inclusive workplace commitment
Similar Jobs
Analytics Engineer 5 – Promotional Media
Analytics Engineer building analytics tools, dashboards, and observability for Netflix promotional media and marketing systems. Improving asset recommendations, campaign performance, and subscriber growth.
Analytics Engineer II
Analytics Engineer II building trusted marketing data models and pipelines for Instacart’s grocery delivery platform. Supporting attribution, paid marketing, SEO, and retailer marketing analytics.
Analytics Engineer
Analytics Engineer building scalable dbt and SQL models for Qonto’s European SME finance workspace. Partnering with Product, Growth, and Ops Finance analytics teams while migrating to Omni.
Analytics Engineering Lead
Analytics Engineering Lead shaping Tiko’s dbt and Tableau data platform for adolescent health services across Africa. Leading semantic modelling, governance, and analytics engineering enablement.
Principal Solutions Engineer, Data & AI
Founding Solutions Engineer enabling MedScout’s MedTech revenue acceleration platform through enterprise data integrations and AI solutions. Owning discovery, technical validation, security reviews, demos, and reusable sales enablement.
Analytics Engineer
Analytics Engineer building scalable data models and AI-enabled workflows for Ontic’s enterprise security software platform. Partnering across teams to power metrics, operational decisions, and enterprise analytics infrastructure.
Analytics Engineer
Analytics Engineer desenvolvendo pipelines, modelagens e produtos de dados para crédito e recuperação na Reply. Criando features e sustentando soluções de machine learning para decisões automatizadas.
Data Analytics Engineer
Data Analytics Engineer building BI dashboards, SQL models, and reporting pipelines for SunnyData’s data consulting clients. Translating business needs into reliable, actionable analytics.
Analytics Engineer
Analytics Engineer building governed warehouses, semantic layers, and reusable data assets for Common App. Enabling scalable analytics and college admissions research through reliable data infrastructure.
Senior Solutions Engineer, AI Data – Model Evaluation Solutions
Senior Solutions Engineer shaping scalable AI data and model evaluation solutions for Argos. Translating complex customer requirements into pilots, proposals, workflows, and delivery plans.
Lead Analytics Engineer
Lead Analytics Engineer modernizing SavATree’s enterprise data and analytics capabilities. Building governed Snowflake, Databricks, and dbt products, internal tools, and AI-enabled workflow automations.
Senior Software Engineer – Spatial Analytics, Open Formats
Senior Software Engineer defining CARTO’s cloud-native spatial analytics, SQL, and open-format strategy. Shaping AI-agent execution across warehouses, lakehouses, and geospatial standards.
Data Analytics, AI Solutions Engineer
Data Analytics & AI Solutions Engineer designing and maintaining Power BI dashboards. Driving AI capabilities and data analytics in a pharmaceutical context at Veranova.
AI Engineer, Data Intelligence Analyst
AI Engineer analyzing data intelligence projects at Cedars-Sinai. Supporting AI solutions development and healthcare data analysis in a secure environment.
Senior AI, Data Solutions Engineer
Senior AI & Data Solutions Engineer developing scalable AI and machine learning solutions at Carrier. Collaborating with cross-functional teams to improve business performance through innovative analytics.
Principal Engineer – SAP Analytics Solution Architect
Principal Engineer - SAP Analytics Solution Architect at a digital product engineering company. Leading design and implementation of SAP data analytics solutions with remote work options.
Project Controls Specialist – Data Analytics, Reporting
Project Controls Specialist IV responsible for data analytics and reporting at Granite Construction. Administering Power BI systems and collaborating with project controls teams.
Data Analytics Engineer
Data Analytics Engineer focused on migrating data processes and ensuring governance at Imagemaker. Collaborates with business areas for process development and validation.
Analytics Engineer – Life Sciences Delivery Operations
Analytics Engineer managing data delivery operations using real-world data for life sciences. Authoring and maintaining data transformation jobs while collaborating with channel partners.
Lead Analytics Engineer
Lead Analytics Engineer designing and developing data integrations for HCSC's Enterprise BI Data Marts. Collaborating on data processes and architecture with a focus on analytics engineering.