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.
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, access controls, and backup strategies
What Makes You Successful
- 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
Basic Qualifications
- 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
Preferred Qualifications
- 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
This Role Might Be a Great Fit If You…
- Enjoy building data solutions that drive business insights and decision-making
- Thrive in solving complex data challenges and optimizing performance
- Are detail-oriented and passionate about data accuracy and quality
- Like collaborating with cross-functional teams to turn data into value
- Are eager to deepen your understanding of enterprise data and systems
- Take ownership of your work and enjoy designing scalable, long-term solutions
What We Offer
- Competitive compensation
- Comprehensive medical, dental, and vision benefits
- 401(k) with company match
- Paid time off and company holidays
- Opportunities to shape compensation strategy in a growing organization
- A collaborative, high-impact leadership environment
Skills Required
- 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 complex queries, stored procedures, optimization, and data manipulation
- Experience with data modeling, dimensional modeling, and data warehousing principles
- Hands-on experience building and maintaining ETL pipelines
- Familiarity with SSMS, SSRS, and Power BI
- Bachelor's degree in Computer Science, IT, 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 Power BI
What We Do
APCO, established in 1984, is a leading marketer and administrator of extended vehicle service contracts, warranties, and other related products sold primarily by automobile dealers located throughout the United States. APCO has expanded its offerings over the last decade to include leading-edge training for dealership sales and finance teams. The company markets its products using the EasyCare and GWC brands, as well as other private label automobile manufacturer brands, through a network of independent agents and an internal salesforce that specialize in consulting with and servicing the automotive dealership markets. EasyCare and GWC Warranty are the only "Motor Trend Recommended Best Buy" brands in the automotive aftermarket. For further information about APCO, see www.gwcwarranty.com and www.easycare.com.
.png){kind=logo}
