Data Engineering Analyst

About Us

TechTorch is a fast-growing consultancy at the intersection of enterprise tech, AI, and private equity. We partner with top-tier PE funds and their portfolio companies to deliver AI-powered platforms, data accelerators, and digital transformation projects that generate measurable value — fast.

Founded by former Bain consultants, CIOs, and enterprise tech leaders, we blend startup agility with big-firm experience. We’re not a typical startup — we were built to deliver.

About the Role – Data Analyst

As a Data Analyst, you’ll be a key contributor to building a modern Azure-native data platform for one of our private equity-backed clients.

You’ll analyze current data sources and legacy reports, reverse-engineer business logic, and translate complex reporting requirements into structured data specifications. You’ll also support data profiling, validation, and the design of a Common Data Model (Bronze/Silver/Gold).

Your work will directly influence dbt model development, data pipelines, and reporting layers — all serving as the organization’s single source of truth.

Tech Stack

• SQL (advanced querying, troubleshooting)

• dbt, ETL, data modeling (dimensional/relational)

• Data profiling, validation, quality checks

• Azure Data Services (preferred), AWS/GCP also welcome

• Familiarity with Medallion architecture

• Bonus: Python (Pandas), Salesforce data

What You’ll Do

• Analyze raw and semi-structured datasets to understand key metrics and usage

• Reverse-engineer legacy SQL, stored procedures, reports

• Perform data profiling and assess quality issues

• Translate business needs into clear data specs, rules, and mappings

• Support Common Data Model design (Bronze/Silver/Gold)

• Define data validation, error handling, and quality checks

• Collaborate closely with Data Architects and engineers

• Support testing and debugging through validation reports and business logic guidance

• Engage with business stakeholders to clarify reporting needs

Requirements

• 5+ years of experience in enterprise data analysis

• Strong SQL skills (querying, analysis, debugging)

• Deep experience in data profiling and validation

• Familiarity with relational and dimensional modeling

• Ability to understand and document transformation logic

• Experience working across technical and business teams

• Knowledge of modern data architectures (Medallion, warehouse design)

• Clear, structured communication skills

• English: fluent spoken and written

Nice to Have

• Python (Pandas) for exploratory analysis

• Experience with Salesforce data

• Cloud experience (Azure preferred, AWS/GCP okay)

Why Join Us?

• Projects with high-impact PE-backed companies

• Work with ex-Bain, top-tier CIOs, and data leaders

• Real ownership and visibility in project delivery

• Remote-first culture built on speed, clarity, and results

• A fast-paced environment for high performers who want to grow

Our Values

• Client First – Value and outcomes over slide decks

• We, Not Me – We move faster as a team

• Get Stuff Done – Execution over bureaucracy

• AI First – AI is embedded into what we build

• Own It – We take full responsibility

• Agile Mindset – We adapt fast and improve constantly