Job Description
Data Engineer Salary: Open + Bonus Location: Chicago, IL Hybrid: 3 days onsite, 2 days remote We are unable to provide sponsorship for this role Qualifications Bachelor s degree 3+ years of experience as a data analyst, data engineer, software engineer, data scientist, financial risk analyst, business intelligence analyst Ability to write and optimize complex analytical (SELECT) SQL queries Ability to write and optimize python for custom data pipeline code (virtual environments, scripts vs. modules vs packages, functional programming, unit testing) Strong Experience with data visualization tools - Tableau and/or Alteryx Experience with Git Preferred Experience with transformation/semantic layer frameworks, such as dbt Familiarity with services on at least one cloud computing platform, such as AWS or Azure, or a cloud data platform such as Databricks or Snowflake Familiarity with data modeling design concepts such as 3rd-normal form or denormalization modeling concepts such as star-schema Exposure to batch orchestration tools such as Apache Airflow, Dagster, or Prefect Understanding of applied statistics and hands-on experience applying these concepts Responsibilities Design and maintain analytical solutions drawing from both raw and semantic data layers Partner with business units to gather requirements and develop targeted analytics solutions Create data models ensuring information availability in the analytics warehouse for analysis and dashboard development Help establish Data Analytics standards and collaborate with embedded business analysts to ensure adherence Develop comprehensive documentation and testing protocols to guarantee data accuracy and accessibility Identify and distribute data and analytics best practices across the team Continuously expand knowledge of data and analytics engineering methodologies to enhance infrastructure maintainability and reliability Champion self-service capabilities and data literacy among business users through semantic layer utilization, analytics platforms (Tableau, Python), and CI/CD tools