ETL Conversion Architect

Overview

ETL Conversion Architect – PCMI (Policy Claim Management International). PCMI is a fast-growing SaaS provider of integrated software for Extended Warranty Management and Finance & Insurance (F&I) administration. Our team, located in the US, Poland, and Thailand, builds the PCRS platform that automates the full administration lifecycle of all extended warranties, F&I products, and service contracts for our customers.

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 establishes scalable frameworks, validation models, and governance structures that enable the Professional Services team to execute conversions consistently, accurately, and with minimal rework.

• 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.

• Build automated validation assets and exception monitoring templates that the broader team can leverage in Excel, SQL Server, or other tooling.
• Partner with Dev Ops/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).

• Define standardized conversion preview formats (e.g., before/after field‑level reports) to be used in pre‑conversion workshops with clients.
• Serve as a client‑facing SME during data onboarding and conversion planning sessions—guiding clients through expected outcomes, resolving mapping discrepancies, and confirming alignment prior to data transformation.
• Act as a Trusted Advisor throughout the full conversion lifecycle, from pre‑conversion planning through post‑load validation, ensuring transparency, accuracy, and accountability.
• Ensure ongoing data quality assurance by defining scalable approaches for post‑load reconciliation, control totals, and referential integrity validations.

• 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 across conversions, ensuring full auditability.
• Define procedures for flagging scope changes or deviations from standard conversions and providing inputs into project change control discussions.

None.

• 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 Insurance, F&I, Accounting, Risk Management, or warranty admin platforms.
• Experience working in Professional Services…