Sr. SQL Developer

About ACB

The Advertising Checking Bureau (ACB) has been a trusted partner in channel marketing for over 100 years, managing reward programs for 200 leading brands across Co-op Advertising, MDF Programs, Consumer Rebates, and Channel Spiff Programs. Our U.S.-based team combines deep industry expertise with a genuine commitment to getting it right — for our clients, our data, and each other.

We're a mid-sized company where your work is visible, your impact is real, and the problems you solve actually matter to the business.

The Role

We're looking for a Senior SQL Developer who is as comfortable digging into a complex data problem as they are thinking about where data infrastructure needs to go next. This is a hands-on role with real influence — you won't just be maintaining what exists, you'll be helping shape what comes next.

This role is hybrid, you could be based out of our Tempe, AZ or Memphis, TN office.

What You'll Actually Be Doing Day to Day

Most of your time will be spent working directly in SQL Server — writing and tuning complex T-SQL, building and maintaining stored procedures, and keeping our data pipelines running cleanly and accurately. You'll work closely with the IT, operations, and data teams to translate business needs into reliable, well-documented SQL solutions.

Beyond day-to-day execution, you'll have a meaningful role in helping us modernize. We have a significant amount of legacy infrastructure built up over decades of client-driven development — SSIS packages, manual workflows, and processes that were built for a different era. We're actively working to reduce that technical debt, and we need someone who can help us think through what better looks like, not just maintain what exists.

Specifically, you can expect to:

• Write and optimize complex T-SQL — stored procedures, functions, and queries against large, complex datasets
• Build and maintain ETL/ELT pipelines, including existing SSIS packages and newer approaches as we modernize
• Develop and maintain SSRS reports and support the transition toward modern BI tooling such as Power BI
• Design and document database schemas, data models, and ERD diagrams
• Identify and resolve data quality issues — accuracy, completeness, consistency
• Convert legacy manual processes into automated, auditable SQL solutions
• Collaborate across IT, operations, and client teams to understand requirements and deliver solutions
• Contribute to the creation, review and update of data governance standards and participate in enforcing the same
• Help evaluate and introduce modern SQL Server capabilities that ACB hasn't yet explored

What You Bring

Required:

• 5 years of professional SQL development experience in production environments
• Deep T-SQL expertise — complex queries, stored procedures, performance tuning, large datasets
• The ability to translate non-technical business needs into technical data solutions
• Solid understanding of relational database design, data modeling, and ERD
• Experience with ETL/ELT operations and data pipeline development
• Familiarity with SSIS and SSRS — and an opinion about where things are heading
• Strong communication skills — you can explain data problems to non-technical stakeholders clearly
• Attention to detail and a genuine commitment to data accuracy
• Comfortable working in a fast-moving environment where priorities shift and you manage your own time effectively

Preferred:

• Experience with modern BI tools — Power BI, Tableau, or similar
• An understanding of CDC and how to best implement it
• Familiarity with ELT patterns and cloud data concepts (data lakes, Azure, etc.)
• Exposure to version control (Git) and agile workflows
• Microsoft SQL Server or Azure certifications
• Background in financial systems, incentive programs, channel marketing, or advertising
• An interest in — or experience with — evaluating newer SQL Server features and guiding teams toward better patterns

Why ACB

• Real impact. In a team of ~30 IT professionals supporting a $6B business, your contributions are visible and valued.
• Hybrid flexibility. 2-3 days in office per week in Tempe or Memphis. The rest is yours to manage.
• A company that's investing. We pay competitively for senior talent. We know what good costs, and we're committed to it.
• Interesting problems. Decades of client-driven development means there is genuinely meaningful modernization work to be done — the kind that requires experience, judgment, and someone who cares about doing it right.
• Stable foundation. Over 100 years in business, a loyal client base, and a team that tends to stay. If you want a place where you can plant a flag and build something, this is it.

A Note on Our Stack

We'll be honest: our environment includes some legacy technology — SSIS, SSRS, on-premises SQL Server infrastructure — that has been in place for a long time. We're not asking you to pretend that's cutting-edge. What we are looking for is someone who understands that environment deeply, can keep it running reliably, and has the experience and perspective to help us make smart decisions about modernizing it. If you've seen the full arc — from legacy to modern — and have opinions about how to navigate that transition without breaking things, you'll fit right in here.