{"schemaVersion":"jobsearcher.job.v1","id":"48a84cd24116cf09b7c3569b","url":"https://jobsearcher.com/jobs/48a84cd24116cf09b7c3569b","canonicalUrl":"https://jobsearcher.com/jobs/48a84cd24116cf09b7c3569b","title":"Senior SQL Developer","description":"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 performanceTechnical 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 operationsPerformance & 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 scalabilityCollaboration & 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 deadlinesWhat 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 accuracyEducation - High school degree required- Bachelor's degree in Computer Science, Software Development, Information Technology, or related field preferredPreferred - 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.","company":"Advertising Checking Bureau Acb","rawCompany":"advertising checking bureau acb","city":"Memphis","state":"TN","isRemote":false,"isActive":false,"createdAt":"2026-04-12T19:46:14.964Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior SQL Developer","description":"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 performanceTechnical 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 operationsPerformance & 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 scalabilityCollaboration & 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 deadlinesWhat 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 accuracyEducation - High school degree required- Bachelor's degree in Computer Science, Software Development, Information Technology, or related field preferredPreferred - 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.","datePosted":"2026-04-12T19:46:14.964Z","dateModified":"2026-04-12T19:46:14.964Z","hiringOrganization":{"@type":"Organization","name":"Advertising Checking Bureau Acb","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Memphis","addressRegion":"TN","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"48a84cd24116cf09b7c3569b"},"url":"https://jobsearcher.com/jobs/48a84cd24116cf09b7c3569b"}}