Principal Data Analytics Engineer

DriveWealth•Chicago, IL
•$220,000 - $240,000•Hybrid

About The Position

DriveWealth is hiring a Principal Data Analytics Engineer to build innovative data products that provide actionable insights for internal teams and external partners. The role focuses on curating and maintaining key data sources and statistics, and combines hands-on engineering with architectural leadership. The engineer is expected to spend 60–70% of their time writing code while shaping a scalable data ecosystem and developing performant, resilient models and reporting solutions using Databricks, dbt, and Python. The role owns data products throughout their lifecycle, from concept and architecture through production deployment, optimization, and maintenance. It involves developing complex dbt models and transformations for high-volume financial datasets, building production-grade Python automation, improving query performance and incremental loading, and implementing deployment pipelines and data-quality checks. The Principal Engineer also leads technical initiatives, partners with Product, Finance, Operations, Risk, and Trading stakeholders, and mentors engineers through code reviews, pair programming, and architectural guidance. The position is open to candidates in Chicago, Illinois. Chicago-based employees are expected to work in the office three days per week on a schedule set by the hiring manager or team. Applicants must already be authorized to work in the United States without current or future visa sponsorship.

Requirements

  • At least 8 years of professional experience in analytics engineering or data engineering, including building and scaling analytical data ecosystems.
  • Expert proficiency in SQL, including optimizing complex queries and data models at scale.
  • Advanced proficiency in Python for data manipulation using Pandas, Polars, or Spark, and for interacting with APIs and AWS services.
  • Experience with Databricks analytics workloads, including building and optimizing data models using Databricks SQL and dbt.
  • Experience with dbt materializations, macros, and package management.
  • Experience architecting FinTech and Capital Markets data models, including trade lifecycles, clearing and settlement, risk models, and financial reporting.
  • Proficiency leveraging AI tools such as GitHub Copilot or similar LLMs to accelerate coding, automate documentation, and improve engineering workflows.
  • Ability to build reusable and modular data solutions rather than one-off scripts.
  • Experience treating data as software through unit testing, CI/CD, comprehensive documentation, and SLA monitoring.
  • Ability to independently diagnose and resolve complex errors or issues in distributed systems such as Spark and Databricks.
  • Bachelor’s degree in Computer Science, Software Engineering, or a related technical field.
  • Authorized to work in the United States on a full-time basis without current or future visa sponsorship.

Nice To Haves

  • Experience implementing Airflow or similar orchestration tools.
  • Experience with Sigma Computing from a data-modeling perspective.
  • Experience building Data Apps within Databricks.
  • Experience using AI or LLM tools to enable faster, smarter analytics workflows.

Responsibilities

  • Own the full lifecycle of data products, from conceptualization and architecture through production deployment, optimization, and maintenance.
  • Design and code complex dbt models and transformation logic for high-volume financial datasets, including trade transactions, stock ledgers, and clearing and settlement records.
  • Develop production-grade Python scripts for data processing, anomaly detection, and custom orchestration.
  • Optimize query performance and incremental loading strategies to reduce cost and latency; refactor legacy code.
  • Implement data deployment and reporting pipelines using Git and dbt Cloud, including version control and integration.
  • Build automated testing frameworks and validation suites using dbt tests and Python to ensure data integrity.
  • Lead major technical initiatives by scoping, designing, and managing complex data projects while contributing directly to the codebase.
  • Partner with Product, Finance, Operations, Risk, and Trading stakeholders to translate requirements into data products and reporting solutions.
  • Provide technical mentorship, conduct code reviews, and help engineers resolve blockers through pair programming and architectural guidance.

Benefits

  • Competitive compensation, equity, and a 401(k) match.
  • Medical insurance.
  • Dental insurance.
  • Vision insurance.
  • Disability insurance.
  • Paid parental leave.
  • Wellness reimbursement.
  • Company-provided phone.
  • Personal development allowance.
  • Generous paid time off.
  • Observed holidays.
  • Base compensation, bonus, equity, 401(k) match, and heavily subsidized benefits and perks.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service