ThoughtFocus

Data Analyst

ThoughtFocus • $95K — $115K *
Brookfield, WI 53045In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 7+ years of software or data engineering experience
  • 4+ years of production Apache Spark pipelines experience with Java and Python
  • Advanced SQL and relational data modeling skills, familiarity with Snowflake and MySQL
  • 3+ years managing AWS workloads and implements workflow orchestration
  • 3+ years in building and maintaining production REST APIs, especially with PHP and Symfony
  • Strong proficiency in AI development tools and judgment on AI output
  • Experience managing external integrations and handling compliance-sensitive data.

Responsibilities

  • Build and optimize production Apache Spark pipelines for conversion data
  • Design data models for data lake and warehouse technologies on AWS
  • Create and manage optimization feeds and integrations with external partners
  • Develop and maintain production REST APIs with secure changes
  • Diagnose production issues, manage data workflows, and execute necessary changes
  • Write unit and integration tests for data pipelines and APIs
  • Manage staged releases, rollbacks, and production diagnostics.

Benefits

  • Comprehensive health and wellness programs
  • Flexible work hours and remote work opportunities
  • Professional development and continuing education stipends
  • A collaborative team culture fostering innovation
  • Access to cutting-edge technologies and tools.
Full Job Description
Responsibilities:
  • Build, optimize, and operate production Apache Spark pipelines that generate attributed conversion and optimization feeds from large-scale impression and conversion data.
  • Design and evolve data processing and models across modern data lake and warehouse technologies, orchestrated with a production workflow scheduler on AWS.
  • Build and operate partner optimization feeds and integrations with external partners, including schemas, identity fields and unique IDs, file delivery, reconciliation, and SLAs.
  • Build, change, and operate production REST APIs, including PHP APIs, delivering secure, backward-compatible changes end to end (implementation, validation, authorization, data access, documentation, automated testing, and production diagnostics).
  • Trace and modify behavior across controllers, database queries, templates, JavaScript, and automated tests.
  • Diagnose production failures, reconcile partner-facing data, execute backfills, and manage staged releases and rollbacks.
  • Write and maintain unit and integration tests across pipelines, APIs, and feeds.

Qualifications and Education Requirements:
  • 7+ years of professional software or data engineering experience.
  • 4+ years building, optimizing, and maintaining production Apache Spark pipelines, with strong Java and Python skills across JVM Spark and PySpark.
  • Advanced SQL, relational data modeling, and large-scale data processing experience, including production work with Snowflake, MySQL, and Iceberg.
  • 3+ years operating AWS data workloads using S3 and Airflow (or equivalent production workflow orchestration); container orchestration and data-catalog experience a plus.
  • 3+ years building, changing, and operating production REST APIs, including PHP APIs built with Symfony or a closely equivalent PHP MVC framework.
  • Demonstrated proficiency using AI development tools to deliver production-quality work efficiently - including AI-assisted coding, code review, documentation, and investigation, working with agentic code harnesses, and spec-based (spec-driven) AI development - with the judgment to know when to rely on AI output and when not to.
  • Ability to independently deliver secure, backward-compatible API changes, including implementation, validation, authorization, data access, documentation, automated testing, and production diagnostics.
  • Experience implementing external provider or client integrations involving schemas, APIs, file delivery, identity fields, reconciliation, privacy-sensitive data, and SLAs.
  • Production full-stack experience with PHP, Symfony (or a comparable framework), Doctrine, Twig (or another server-rendered template system), and JavaScript.
  • Ability to trace and modify behavior across controllers, database queries, templates, JavaScript, and automated tests.
  • Experience writing unit and integration tests for data pipelines, APIs, and web applications.
  • Ability to diagnose production failures, reconcile data, execute backfills, manage staged releases and rollbacks, and support delivery commitments.
  • Hands-on experience building and running big data systems, with a focus on performance, reliability, and data quality.
  • Experience in ad tech or advertising measurement, such as attribution, conversions, audience and impression data, identity matching, or partner optimization feeds.
  • Ability to ramp quickly and deliver with minimal onboarding in an existing, complex codebase.

Preferred Skills:
  • Direct experience building partner optimization or advertising feeds with external platforms (DSPs, publishers, or measurement partners).
  • Experience with deterministic and probabilistic identity matching - unique IDs, device IDs, IP-based matching, and identity graphs.
  • Familiarity with edge/log delivery infrastructure and pixel/impression tracking.
  • Experience with data lake table formats and query engines at large scale.
  • Experience with privacy and compliance-driven data workflows (deletion, opt-out, suppression, data retention).
  • Comfort operating in uncharted territory - turning ambiguity into production systems without a detailed guide.

About ThoughtFocus

ThoughtFocus is a privately held technology consulting and services company. The company provides services in the areas of digital transformation, cloud computing, data analytics, and software development. ThoughtFocus was founded in 2004 and is headquartered in Smyrna, Georgia.
Learn more about ThoughtFocus
Size
2,000 employees
Industry
Information Technology
Founded
2004
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at ThoughtFocus

  • ThoughtFocus
    Data Analyst
    $95K — $115K *
    Brookfield, WI 53045 (Waukesha County)
    Today
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Data Analyst jobs:

NationwideBrookfield, WI