Senior Data Developer

Job 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 DoDesign, develop, and maintain data integration solutions using SQL Server, SSIS, Azure Data Factory, and related toolsBuild scalable, reliable ETL pipelines to support enterprise business intelligence and analyticsLead the design of logical data models and implement optimized physical database structuresDevelop and manage operational data stores, data marts, and enterprise data modelsCollaborate with business stakeholders to gather data requirements and translate them into technical solutionsIntegrate data from multiple sources including databases, APIs, and flat filesPerform data transformation, cleansing, validation, and aggregation to ensure high data qualityMonitor, optimize, and troubleshoot ETL performance and data workflowsDeploy, schedule, and maintain production data processes with proper documentation and controlsEnsure data accuracy, security, and availability through governance, access controls, and backup strategiesWhat Makes You SuccessfulSuccess in this role requires a strong ability to understand and interpret organizational data. You will develop deep domain knowledge to effectively support integrated data design initiatives and deliver high-quality, data-driven solutions that enable informed business decisionsStrong expertise in SQL development, including complex queries, stored procedures, and performance tuningDeep understanding of ETL design, data modeling, and data warehousing conceptsAbility to design scalable, efficient database architectures and data pipelinesStrong analytical and problem-solving skills with attention to detailExperience translating business needs into technical data solutionsEffective communication skills to explain complex concepts to both technical and non-technical audiencesCommitment to data accuracy, quality, and continuous improvementBasic Qualifications5+ years of experience as an ETL Developer, Data Engineer, Database Developer, or similar roleStrong experience with SQL Server, SSIS, and Azure Data FactoryProficiency in SQL, including query writing, optimization, and data manipulationExperience with data modeling, dimensional modeling, and data warehousing principlesHands-on experience building and maintaining ETL pipelinesFamiliarity with tools such as SSMS, SSRS, and Power BIPreferred QualificationsBachelor's degree in Computer Science, Information Technology, Engineering, or related fieldExperience with OLAP, MDX, and multidimensional data modelsFamiliarity with programming languages such as Python, Java, or .NETExperience with cloud data platforms (e.g., Azure SQL, AWS RDS)Knowledge of database security, backup, and recovery strategiesExperience creating semantic models or datasets for reporting tools like Power BIThis Role Might Be a Great Fit If You...Enjoy building data solutions that drive business insights and decision-makingThrive in solving complex data challenges and optimizing performanceAre detail-oriented and passionate about data accuracy and qualityLike collaborating with cross-functional teams to turn data into valueAre eager to deepen your understanding of enterprise data and systemsTake ownership of your work and enjoy designing scalable, long-term solutionsWhat We OfferCompetitive compensationComprehensive medical, dental, and vision benefits401(k) with company matchPaid time off and company holidaysOpportunities to shape compensation strategy in a growing organizationA collaborative, high-impact leadership environment At APCO, the way we work matters just as much as the results we deliver. Our values guide how we work, how we partner, and how we deliver results. We C.A.R.E.Committed – We build strong, high-trust relationships with our partners and each other.Accountable – We take ownership of outcomes and hold ourselves to the highest standards of performance and integrity.Results-Driven – We focus on delivering measurable outcomes that create value for our partners and our business.Excellent – We strive for excellence in everything we do while balancing short-term performance with long-term success. If you're excited about joining a team that values collaboration, accountability, and continuous improvement, we'd love to hear from you. By submitting your application, you acknowledge that you have read and understand our Privacy Policy and Terms & Conditions. APCO Holdings may collect personal information (such as name, contact details, and employment history) to evaluate your candidacy. We may share this data with our subsidiaries, affiliates, and service providers. We retain applicant data only as long as necessary for the hiring process or as required by law.We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.