ETL Conversion Architect

Who We Are

PCMI (Policy Claim Management International) is a fast-growing, leading provider of integrated software for Extended Warranty Management and Finance and Insurance (F&I) administration. We are a SaaS company that operates in a fast paced, entrepreneurial environment. Our 3 teams located in the US, Poland, and Thailand work collaboratively around the clock to build our PCRS platform that automates the full administration lifecycle of all extended warranties, F&I products, and service contracts for our customers.

What You’ll Do 

The ETL Conversion Architect will play a critical leadership role in shaping the data conversion strategy for enterprise-scale implementations of PCMI’s PCRS platform. Rather than focusing solely on individual project delivery, this role is also responsible for establishing scalable frameworks, validation models, and governance structures that enable the broader Professional Services team to execute conversions with consistency, accuracy, and minimal rework. 

Acting as the subject matter expert in ETL methodology, this individual will define how legacy data is transformed, validated, and migrated into PCRS—prioritizing transparency, client alignment, and time-to-value. From developing SQL-based source-to-target comparison models to enabling trust-but-verify conversion tracking, this role is essential to building a repeatable, high-confidence conversion process that accelerates client onboarding and elevates delivery quality across the organization. 

In this role, you will own:

Practice-Level Framework Design: 

• Architect and maintain source-to-target field-level validation frameworks that ensure field-level integrity across legacy and PCRS systems.
• Design standardized SQL Server validation pipelines (leveraging SSIS) to log and store pre/post conversion data, enabling clear traceability and trust-but-verify validation with clients.
• Establish conversion hypothesis protocols—defining expected outcomes from each extract-transformation-load (ETL) step before execution begins.
• Define and govern control total expectations (e.g., contract count, rate bucket totals, claim payments) across major business objects like Contracts, Claims, and Payments.

Automation & Quality Enablement: 

• Build automated validation assets and exception monitoring templates that the broader team can leverage in Excel, SQL Server, or other tooling.
• Partner with DevOps/Engineering to maintain a centralized SQL repository of validation rules, transformation logic, and data anomaly flags.
• Provide field-level transformation and mapping patterns for common edge cases (e.g., address concatenation, rate truncation, legacy formatting inconsistencies).

Client Alignment & Delivery Readiness: 

• Define standardized conversion preview formats (e.g., before/after field-level reports) to be used in pre-conversion workshops with clients—helping them visualize how legacy data will translate into PCRS before any transformation begins.
• Serve as a client-facing SME during data onboarding and conversion planning sessions—guiding clients through expected outcomes, resolving mapping discrepancies, and confirming mutual alignment prior to data transformation.
• Act as a Trusted Advisor for clients throughout the full conversion lifecycle, from pre-conversion planning through post-load validation – ensuring transparency, accuracy, and accountability are maintained across all data migration milestones.
• Ensure ongoing data quality assurance by defining scalable approaches for post-load reconciliation, control totals, and referential integrity validations – enabling early detection of discrepancies and reducing reliance on UAT as the primary validation checkpoint.

Governance & Oversight: 

• Own the conversion data quality strategy for PCRS implementations – including release-specific adjustments based on schema evolution.
• Govern the process for tracking, storing, and surfacing control totals (financial and transactional) across conversions—ensuring full auditability.
• Define procedures for flagging scope changes or deviations from standard conversions and providing inputs into project change control discussions.

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.  

Supervisory Responsibilities 

• None.

What You’ll Need to Join Our Team

• 10+ years of progressive experience in ETL development, data conversion, and SaaS implementation, with a proven track record of designing and delivering scalable, SQL-based data frameworks in complex client environments.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent hands-on experience with high-volume data conversion projects.
• Deep expertise in Microsoft SQL Server, including schema design, scripting, data transformation, validation logic, stored procedures, and performance tuning.
• Proficiency in ETL frameworks and tools (e.g., SSIS, custom SQL-based ETL engines), with strong ability to architect reusable pipelines and enforce field-level mapping logic.

• Solid understanding of SaaS platforms, especially in highly configurable systems within the following industries: Insurance, F&I, Accounting, Risk Management, or warranty admin platforms.
• Experience working in Professional Services organizations with a focus on implementation quality, timeline predictability, and cost control.
• Strong communication skills with demonstrated ability to translate complex technical designs into digestible summary insights for non-technical audiences, including PMs and clients.
• Background in mentoring technical consultants and conversion engineers, and establishing standards for scalable data practices across client projects.
• Familiarity with Agile or Waterfall delivery methodologies, as well as Change Management, Data Governance, and Test Validation frameworks.
• Experience collaborating with Product and Engineering to identify platform gaps, inform roadmap priorities, and drive customer outcomes through technical innovation.

Required Skills/Abilities

• Expert-level proficiency in ETL processes, frameworks, and source-to-target data mapping.
• Strong SQL skills and experience working with SQL Server for complex data transformations.
• Proficient in managing and querying large datasets across staging and production layers.
• Familiarity with REST APIs, JSON, XML, and Batch processing for system integrations.
• Competent in scripting with PowerShell and Python for ETL automation and validation.
• Strong analytical mindset with a focus on quality, traceability, and reusability of conversions.
• Excellent communication skills, capable of translating technical insights for non-technical audiences.
• Highly organized with the ability to manage multiple priorities under tight deadlines.
• Comfortable in a high-paced, client-facing environment with evolving business needs.

Physical Requirements 

• Prolonged periods of sitting at a desk and working on a computer.
• Must be able to lift up to 15 pounds at times.

Travel Requirements 

• Must be able to travel to client meetings or PCMI office; up to 10%

Why Work For Us

• Competitive Compensation from $150,000-$170,000 Annually*
• Comprehensive Benefit Package**
• Health, Dental & Vision Insurance
• Health Savings Account (HSA) 
• Flexible Spending Account (FSA)
• Short- & Long-Term Disability Insurance
  • Company-paid Long-Term Disability
• Company-paid Life Insurance 
• Voluntary Life Insurance 
• Voluntary Accident Insurance 
• Employee Assistance Program 
• 401k with generous Company Match
• Commuter Benefits 
• Paid Time Off accrued per pay period. 
• 10 Paid Holidays
• Paid Parental Leave
• Annual Bonus Program 
• Professional Development Opportunities 
• Employee Events 
• Wellness Programs 
• Employee Discount Programs 
• Office in Park Ridge, IL - Convenient location to Blue Line 

*Individual compensation packages are based on various factors unique to each candidate, including skill set, experience, qualifications, and other job-related aspects.

**Eligible to enroll in the first day of employment for immediate coverage.

Although the role is remote, PCMI can only hire employees in the following states: 

• AL
• CT
• FL
• GA
• IL
• KY
• MO
• NH
• NC
• OH
• PA
• TX

Note: It is required for this role to be in the Park Ridge, IL office, 2 days per week if candidate is located in the Chicagoland area.