Design and architect robust ETL/data pipelines on cloud platforms. Build and automate data ingestion and preprocessing using Spark/Databricks, AWS Glue, Airflow. Implement warehousing architectures (EDW, DM, ODS, MOLAP/ROLAP), ensure SQL-based data quality, use version control, and deliver tested production pipelines while communicating with stakeholders.
This is a remote position.
Roles & Responsibilities
- Strong verbal/written communication & facilitation skills. Ability to take a requirement document, work through any ambiguity and follow through to implementation independently
- Strong analytical and problem-solving abilities
- Strong work ethic, sense of ownership and a team player
- Architect and design robust ETL processes using tools like Spark, Airflow, AWS Glue etc. to desired client specifications
- Ability to analyze the data to identify the necessary pre-processing steps for the automated ETL processes
- Solid understanding of SQL using databases like MS SQL Server, Redshift, etc.
- Experience in Cloud Infrastructure (AWS, Azure, GCP)
- Delivering the data pipeline with Quality and automated testing
- Bachelor’s degree in computer science, information technology, or a related field.
- Extensive knowledge of coding languages used to build data pipelines, such as Java, Scala, and/or Python
- Experience with Databricks or Spark
- Hands on experience building data pipelines in AWS using AWS Glue, Redshift, S3 buckets and other relevant technologies.
- Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW.
- Proven work experience as an ETL developer.
- Experience using Source Code and Version Control systems like Git etc.
- Strong project management skills.
- Ability to analyze a company’s big-picture data needs.
- Clear communication skills.
- Ability to troubleshoot and solve complex technical problems.
- Desire to continually keep up with advancements in data best practices
Similar Jobs
.png){kind=logo}
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Define and lead the architecture of NBCUniversal’s greenfield Microsoft Fabric enterprise data platform. Establish lakehouse, warehouse, integration, real-time streaming, data modeling, governance, security, DevOps, and observability standards. Translate architecture and business objectives into delivery roadmaps, epics, stories, and implementation plans while guiding multidisciplinary engineering teams. Design scalable solutions combining operational, historical, master, and reference data to support reporting, analytics, automation, AI, and reusable data products.
Top Skills:
Amazon KinesisAPIsAzure DevopsAzure Event HubsBicepChange Data CaptureCi/CdData FactoryDelta LakeEventhouseEventstreamGithub ActionsKafkaLakehouseAzureMicrosoft FabricNotebooksOnelakePower BIPysparkPythonReal-Time IntelligenceSemantic ModelsSQLTerraformWarehouse
Artificial Intelligence • Insurance • Software • Automation
Own the architecture and standards for a trustworthy BI analytics platform. Design data models, ingestion and transformation patterns, lineage, PII controls, reliability SLAs, observability, schema governance, and cost management. Partner with engineers, analysts, business leaders, Security, Legal, and Compliance; enforce testing, CI/CD, infrastructure as code, and data quality practices. Mentor data professionals and document architectural decisions.
Top Skills:
AirflowAlationAtlanCi/CdCollibraDagsterDatahubDbtGitPythonSnowflakeSQLTerraform
Database
Leads enterprise data-platform architecture for clients using Microsoft Fabric and Azure. Responsibilities include discovery, target-state design, data modeling, migrations, DevOps and CI/CD, governance, security, AI/ML enablement, consulting, pre-sales, technical delivery leadership, mentoring, and development of reusable architecture assets. The role requires hands-on Fabric production experience, enterprise-scale implementation ownership, advanced SQL and Python/PySpark skills, client communication, and travel up to 25%.
Top Skills:
Adls Gen2AzureAzure Ai SearchAzure Data FactoryAzure DevopsAzure FunctionsAzure Key VaultAzure Machine LearningAzure OpenaiAzure Sql DatabaseAzure Sql Managed InstanceAzure Synapse AnalyticsBicepCosmos DbDacpacDatabricksDatabricks Asset BundlesDataflows Gen2DaxDirect LakeEr/StudioErwin Data ModelerEvent HubsFabric Data FactoryFabric Git IntegrationFabric IqFabric Rest ApisFabric WarehouseFabric-CicdFoundry IqGitGithub ActionsGithub CopilotGraph In FabricKqlLakehouseManaged VnetsMicrosoft Entra IdMicrosoft FabricMicrosoft FoundryMicrosoft PurviewOnelakePower BIPowershellPrivate LinkPysparkPythonSparkSpark SqlSQL ServerSqldbmSqlpackageSsasSsisT-SqlTerraformUnity Catalog
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
