What are the responsibilities and job description for the Senior SQL Developer position at Advertising Checking Bureau (ACB)?
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.
- Ready to architect the data solutions that power channel marketing's biggest programs? Apply today and become part of ACB's award-winning team.
Salary : $6