EX Squared is looking for a Data Engineer II to play a key role in designing, building, and maintaining our modern data platform. You will own complex data pipelines and integrations that support strategic decision-making and business operations.
What You'll Do
- Design and implement scalable, maintainable ETL/ELT pipelines for a variety of use cases.
- Build and optimize integrations with cloud services, databases, APIs, and third-party platforms.
- Own production data workflows end-to-end, including testing, deployment, monitoring, and troubleshooting.
- Collaborate with cross-functional stakeholders to understand business needs and translate them into technical data solutions.
- Lead technical discussions and participate in architecture reviews to shape our evolving data platform.
- Write clean, well-documented, production-grade code in Python and SQL.
- Improve data model design and data warehouse performance (e.g., partitioning, indexing, denormalization strategies).
- Champion best practices around testing, observability, CI/CD, and data governance.
- Mentor junior team members and contribute to peer code reviews.
What We're Looking For
- 3+ years of experience in a data engineering or software engineering role.
- Proficiency in Python and advanced SQL for complex data transformations and performance tuning.
- Experience building and maintaining production pipelines using tools like Airflow, dbt, or similar workflow/orchestration tools.
- Strong understanding of cloud-based data infrastructure (e.g., AWS, GCP, or Azure).
- Knowledge of data modeling techniques and data warehouse design.
- Experience working with structured and semi-structured data from APIs, SaaS tools, and databases.
- Familiarity with version control (Git), CI/CD, and Agile development methodologies.
- Strong communication and collaboration skills.
Nice to Have
- Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, or a related technical field.
- Experience with modern data warehouses like Redshift, BigQuery, or Snowflake.
- Exposure to modern DevOps/dataops practices (e.g., Terraform, Docker, dbt Cloud).
- Experience integrating with Salesforce or other CRM/marketing platforms.
- Knowledge of data privacy and compliance considerations (e.g., FERPA, GDPR).
Technical Stack
- Languages & Tools: Python, SQL, Airflow, dbt, Git
- Cloud & Data Platforms: AWS, GCP, Azure, Redshift, BigQuery, Snowflake
- Infrastructure & Integrations: Terraform, Docker, Salesforce
Team & Environment
You will collaborate closely with product, analytics, and engineering teams, reporting to the Executive Director, Technical Strategy and Operations.
Benefits & Compensation
- Compensation: $90,000 to $125,000 + equity
- Hybrid work arrangement
- Paid parental leave
- Medical, dental and vision insurance
- FSA, HSA
- Employer-paid short-term and optional long-term disability
- 401k with an employer match vested immediately
- Generous PTO plan that accrues with tenure
- Professional development
- Tuition reimbursement program
- Discounted onsite gym
- Optional pet insurance
Work Mode
This role is hybrid based in Chicago, Illinois.
EX Squared is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
