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
Big Data • Cloud • Software • Database
Partner with People teams to turn HR and org data into actionable insights. Build complex queries, statistical analyses, dashboards, and a centralized people data repository. Drive data governance, data quality, and stakeholder communication to support hiring, retention, productivity, and workforce decision-making.
Top Skills:
Cloud Data WarehouseData EngineeringData ModelingData QualityData WarehousingHrisPythonRSQLTableau
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
Lead and grow a data engineering team that builds and operates ingestion, transformation, orchestration, and serving layers and a self-serve analytics substrate. Own data quality, observability, cost efficiency, SLAs, and engineering practices while partnering with Data Science, BIE, Analytics, and Product to deliver reliable, reusable data products.
Top Skills:
AirflowBigQueryCi/CdDatabricksDbtLlm-Based ToolingSnowflakeSpark
Artificial Intelligence • Big Data • Healthtech • Database • Business Intelligence
Senior Technical Sourcer responsible for top-of-funnel candidate generation across Product, Design, Data, Engineering, and IT/Security globally. Use LinkedIn, GitHub, Boolean search, AI tools, and ATS (Lever) to identify and engage passive talent, build market intelligence, run recruiter phone screens for mid/senior roles, track sourcing metrics, and champion diversity-focused sourcing strategies while partnering with recruiters and hiring managers.
Top Skills:
Ai-Assisted Sourcing ToolsBoolean SearchCloudData EngineeringDevOpsDistributed SystemsGitLeverLinkedin RecruiterSocial Platforms
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
