The analyst will develop and optimize ETL workflows, write complex SQL queries, collaborate with stakeholders, and ensure data quality and delivery.
About the Role
We are seeking a motivated SQL / ETL Analyst to join our data team and support the design, development, and maintenance of data pipelines and reporting solutions. This role is ideal for a mid-level analyst with strong SQL skills and hands-on experience using ETL tools such as Alteryx or Pentaho.
The successful candidate will work closely with business and technical stakeholders to ensure reliable, high-quality data delivery and will contribute to improving and optimizing existing ETL processes.
Key Responsibilities
- Develop, maintain, and optimize ETL workflows and data pipelines
- Write and optimize complex SQL queries, views, and stored procedures
- Build and maintain data solutions using Alteryx, Pentaho, or similar ETL tools
- Collaborate with business and technical stakeholders to gather requirements and translate them into technical solutions
- Perform data validation, quality assurance, and troubleshooting
- Monitor and improve ETL performance and reliability
- Support reporting, analytics, and downstream data consumers
- Document data processes, workflows, and technical designs
Required Qualifications
- 5–8 years of experience in SQL development and ETL/data integration
- Strong proficiency in SQL (SQL Server, Oracle, PostgreSQL, MySQL, or similar)
- Hands-on experience with Alteryx and/or Pentaho
- Solid understanding of ETL best practices and data warehousing concepts
- Experience working with large, complex datasets
- Strong analytical, problem-solving, and communication skills
Preferred Qualifications
- Experience with additional ETL tools (SSIS, Informatica, Talend, etc.)
- Familiarity with BI and reporting tools (Power BI, Tableau, Looker, etc.)
- Exposure to cloud platforms such as AWS, Azure, or GCP
- Basic scripting experience (Python or similar)
What We Offer
- Comprehensive benefits package (401K, health, dental, vision)
- Collaborative and supportive team environment
- Opportunities for professional growth and skill development
- 100% Remote, except for in-person training
Similar Jobs
Artificial Intelligence • Fintech • Healthtech • Software
Lead Data & Integrations Engineering to enhance healthcare integration and data platforms. Manage delivery processes, team development, operational excellence, and cross-functional partnerships.
Top Skills:
Data EngineeringIntegration Engineering
Artificial Intelligence • HR Tech • Professional Services • Software
Senior sales hunter responsible for acquiring new enterprise clients for Analytics, AI/ML, GenAI, Data Science, and Data Engineering consulting services. Build CXO relationships, manage full sales cycle from prospecting to close, hit revenue quotas, leverage strategic partnerships (Microsoft, Databricks), and travel nationally to engage clients.
Top Skills:
AIAi/MlAnalyticsBiData EngineeringData ScienceDatabricksGenaiMicrosoft
Healthtech
As a Principal Technical Product Manager, you will lead the AI Platform team's roadmap, working with AI engineers and data scientists to optimize AI solutions and improve patient care through technology.
Top Skills:
AIAPIsAWSAzureCloud InfrastructureData EngineeringDatabricksDevOpsEnterprise Software DevelopmentGCPMachine Learning
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
