Build and maintain scalable ETL/ELT pipelines using Azure Data Factory, Snowflake, dbt, and SQL. Develop data models, transformations, tests, and documentation; ingest data from APIs, databases, files, and enterprise applications; optimize performance; ensure data quality; troubleshoot failures; and support production deployments and monitoring.
This is a remote position.
We are looking for an experienced Data Engineer with strong hands-on experience in Azure Data Factory (ADF), Snowflake, dbt, and SQL. The ideal candidate will be responsible for building and maintaining scalable data pipelines, transforming data, and developing reliable data solutions for analytics and reporting.
- Design, develop, and maintain ETL/ELT data pipelines using Azure Data Factory (ADF).
- Build and optimize data solutions using Snowflake as the cloud data warehouse.
- Develop data transformation models using dbt (Data Build Tool).
- Write complex and optimized SQL queries, stored procedures, views, and transformations.
- Develop data pipelines to ingest data from various sources including APIs, databases, files, and enterprise applications.
- Perform data cleansing, transformation, validation, and reconciliation to ensure data quality and accuracy.
- Implement incremental data loads, scheduling, dependency management, and error handling in ADF.
- Develop scalable and optimized Snowflake data models, tables, views, and SQL transformations.
- Build and maintain dbt models, tests, macros, and documentation.
- Troubleshoot pipeline failures, data issues, and performance problems across ADF, Snowflake, and dbt.
- Work with business analysts, data architects, and other engineering teams to understand data requirements and deliver solutions.
- Support production deployments, monitoring, and ongoing enhancement of data pipelines.
- 4+ years of experience in Data Engineering.
- Strong hands-on experience with:
- Azure Data Factory (ADF)
- Snowflake
- dbt
- Advanced SQL
- Azure Data Factory (ADF)
- Strong understanding of ETL/ELT concepts and data warehousing.
- Experience developing complex data pipelines and data transformations.
- Good understanding of dimensional data modeling, including fact and dimension tables.
- Experience with Snowflake performance optimization and query tuning.
- Hands-on experience with dbt models, tests, incremental models, macros, and Jinja.
- Strong troubleshooting and production support skills.
- Experience with Azure cloud services, particularly Azure Storage, Azure Functions, Databricks, or Key Vault.
- Experience integrating data through REST APIs, JSON, CSV, and relational databases.
- Experience with Python or PySpark is a plus.
- Experience with Git and CI/CD using Azure DevOps or similar tools.
- Understanding of data governance, data quality, and security best practices.
- Experience working with large-scale enterprise data platforms.
Similar Jobs
Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
Leads end-to-end marketing strategy and execution for Commercial and Corporate Banking, including client acquisition, retention, product adoption, digital campaigns, ABM, sales enablement, events, analytics, optimization, budgeting, and regulatory governance. Partners with senior banking, sales, data, and digital stakeholders to develop value propositions, integrated marketing plans, and measurable growth initiatives in a regulated B2B financial services environment.
Top Skills:
Adobe AnalyticsDemandbaseMicrosoft CopilotExcelMicrosoft PowerpointMicrosoft WordPardotSalesforce
.png)
Artificial Intelligence • Big Data • Software • Analytics • Business Intelligence • Big Data Analytics
Leads the East Coast Commercial Sales Engineering team supporting SMB and mid-market customers. Responsibilities include hiring and developing Sales Engineers, owning technical wins, guiding demos and evaluations, partnering cross-functionally on product alignment, managing team systems and tools, and using performance data to improve deal progression and execution.
Top Skills:
AISaaS
Artificial Intelligence • Marketing Tech • Software
Lead technical client onboarding, migrations, solution design, integrations, data orchestration, troubleshooting, and project delivery for Movable Ink’s AI-powered personalization platform. Partner with clients and internal teams to implement custom workflows, APIs, webhooks, and data solutions. Conduct training and workshops, provide product expertise, advise on roadmap improvements, and support long-term client success across email and mobile marketing programs.
Top Skills:
Adobe CampaignAdobe Journey OptimizerAIAirshipAPIsAttentiveBirdBloomreachBrazeCdpCheetah DigitalCordialCSSCustom AppsData LakesData WarehousesEpsilonETLHTMLIterableJavaScriptMachine LearningMovable Ink Da VinciMovable Ink StudioOracle ResponsysPythonSalesforce Marketing CloudSinchVibesWebhooksZeta
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
