Senior Data Developer

APCO Holdings•Ponte Vedra, FL

About The Position

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.

Requirements

5+ years of experience as an ETL Developer, Data Engineer, Database Developer, or similar role
Strong experience with SQL Server, SSIS, and Azure Data Factory
Proficiency in SQL, including query writing, optimization, and data manipulation
Experience with data modeling, dimensional modeling, and data warehousing principles
Hands-on experience building and maintaining ETL pipelines
Familiarity with tools such as SSMS, SSRS, and Power BI
Strong expertise in SQL development, including complex queries, stored procedures, and performance tuning
Deep understanding of ETL design, data modeling, and data warehousing concepts
Ability to design scalable, efficient database architectures and data pipelines
Strong analytical and problem-solving skills with attention to detail
Experience translating business needs into technical data solutions
Effective communication skills to explain complex concepts to both technical and non-technical audiences
Commitment to data accuracy, quality, and continuous improvement

Nice To Haves

Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field
Experience with OLAP, MDX, and multidimensional data models
Familiarity with programming languages such as Python, Java, or .NET
Experience with cloud data platforms (e.g., Azure SQL, AWS RDS)
Knowledge of database security, backup, and recovery strategies
Experience creating semantic models or datasets for reporting tools like Power BI

Responsibilities

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 solutions
Integrate 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, access controls, and backup strategies