SeniorDataDeveloper

## Description APCO Holdings partners with dealerships across North America to deliver innovative vehicle protection products and services that enhance the ownership experience for customers and drive growth for our partners. Through our family of brands, we bring together industry expertise, technology, and data-driven insights to help dealers strengthen their finance and insurance performance and build lasting relationships with their customers. Our teams work collaboratively across operations, technology, risk, finance, marketing, and sales to deliver solutions that create measurable value and support the continued growth of APCO and the partners we serve. We’re looking for a Senior Data Developer to design and build scalable data integration solutions using SQL Server, SSIS, and Azure Data Factory. You’ll develop reliable ETL pipelines, lead data modeling efforts, and create data stores and marts that power business intelligence. This role requires a strong understanding of organizational data to deliver effective, enterprise-wide data solutions. ## What You'll Do Design, develop, and maintain data integration solutions using SQL Server, SSIS, Azure Data Factory, and related tools Build scalable, reliable ETL pipelines to support enterprise business intelligence and analytics Lead the design of logical data models and implement optimized physical database structures Develop and manage operational data stores, data marts, and enterprise data models Collaborate with business stakeholders to gather data requirements and translate them into technical solutionsIntegrate data from multiple sources including databases, APIs, and flat files Perform data transformation, cleansing, validation, and aggregation to ensure high data quality Monitor, optimize, and troubleshoot ETL performance and data workflows Deploy, schedule, and maintain production data processes with proper documentation and controls Ensure data accuracy, security, and availability through governance, acc