SQL Developer

About ACB

The Advertising Checking Bureau (ACB) is a powerhouse in channel marketing, managing over $6B in annual reward programs for 200+ leading brands. We specialize in Co-op Advertising, MDF Programs, Consumer Rebates, and Channel Spiff Programs across consumer and B2B markets. Our award-winning team of full-time, U.S.-based professionals delivers exceptional results through decades of experience and cutting-edge analytics.

Your Mission

Transform data chaos into clarity. As our Senior SQL Developer, you'll architect and optimize mission-critical SQL solutions that power our $6B+ in channel marketing programs. You'll modernize legacy processes, ensure data perfection, and build the scalable infrastructure that drives business intelligence for 200+ leading brands.

What You'll Do

Database Architecture & Design

- Design robust database structures with normalization best practices

- Create and maintain comprehensive ERD diagrams for complex systems

- Develop database schemas that support scalability and performance

Technical Development

- Author complex T-SQL programs including stored procedures, triggers, views, and functions

- Design and implement SSIS packages for ETL operations from various data sources

- Develop and maintain SSRS reports for business intelligence and operations

- Transform legacy manual processes into modern, automated SQL solutions with zero loss of fidelity

- Leverage server-side scripting to enhance data operations

Performance & Quality

- Analyze large datasets to uncover trends, anomalies, and optimization opportunities

- Troubleshoot complex data issues, ensuring accuracy, completeness, and consistency

- Continuously monitor and tune SQL code for maximum performance and scalability

Collaboration & Leadership

- Partner with IT, operations, management, and client representatives across all organizational levels

- Translate business requirements and technical specifications into robust SQL solutions

- Document code, processes, and data flows for clarity and maintainability

- Assist in establishing data management, governance, policies and procedures

- Mentor junior team members and thrive in a highly collaborative environment

- Multi-task effectively while managing competing priorities and meeting critical deadlines

What You Bring

Required

- 5+ years of professional experience with complex SQL in production environments

- Expertise in T-SQL, SSIS, SSRS, ETL operations, and server-side scripting

- Strong understanding of relational database design, ERD, and data modeling

- Proven ability with large datasets, complex data structures, and performance tuning

- Experience modernizing manual workflows into automated SQL systems while ensuring data integrity

- General knowledge of operating systems, network, computer hardware, and IT infrastructures

- Strong written, verbal, and interpersonal communication skills

- Excellent attention to detail and commitment to data accuracy

Education

- High school degree required

- Bachelor's degree in Computer Science, Software Development, Information Technology, or related field preferred

Preferred

- Certifications in Microsoft technologies (SQL Server, Azure, etc.)

- Experience with Power BI, Tableau, or other BI tools

- Familiarity with version control systems (Git) and agile methodologies

- Background in financial, channel marketing, advertising, or incentive programs

Why Choose ACB?

Join a pivotal role where your technical expertise directly impacts how 200+ Fortune 500 brands manage billions in channel marketing programs. Report directly to the IT Manager and enjoy hybrid flexibility in Tempe, AZ or Memphis, TN, while working a team committed to excellence.