Lead Data Engineer, Revenue Accounting

GI ALLIANCE; Southlake (TX); On-site; USD 140,000 - 180,000; Full time

Job summary

Paycom is seeking a Lead Data Engineer, Revenue Accounting to design and operate automated revenue-recognition data products. You will build governed data pipelines on Azure/Snowflake, translating practice-management, billing, and GL data into auditable revenue outputs.

The role combines engineering, data modeling, and close-cycle support, collaborating with Finance, Revenue Cycle, and technology to improve timing, accuracy, and scalability of revenue data assets.

Qualifications

• Bachelor’s degree in a related field or equivalent experience.
• 8+ years data engineering, analytics or warehousing experience.
• 3+ years leading complex technical deliveries or teams.
• Strong SQL and Python, with production data-pipeline experience.
• Experience with Snowflake and Azure in ELT/ETL environments.

Responsibilities

• Own the technical roadmap and delivery plan for the Revenue Recognition Data Product.
• Architect scalable ingestion, transformation, and orchestration pipelines using Azure and Snowflake.
• Develop a canonical revenue-accounting data model with controller ownership preserved by Accounting.
• Establish automated reconciliations across source systems and the general ledger.
• Build data controls, lineage, and runbooks for close processes and auditability.

Skills

SQL

Python

Data modeling

Stakeholder management

Communications

Education

Bachelor's degree in computer science, information systems, engineering, accounting, finance, or related

Tools

Snowflake

Azure

dbt

Azure Data Factory

Azure Databricks

Terraform

Airflow

CI/CD tools

Job description

Company Conformance StatementsIn the performance of their respective tasks and duties all employees are expected to conform to the following:Perform quality work within deadlines with or without direct supervision.Interact professionally with other employees, customers and suppliers.Work effectively as a senior contributor on all projects.Work independently while understanding the necessity for communicating and coordinating team efforts with departments and organizations.Position purposeThe Lead Data Engineer, Revenue Accounting will lead the design, delivery, and operation of The Specialty Alliance’s automated revenue-recognition and accrual data product. The role is designed to support a physician-led, multi-specialty MSO model that provides shared infrastructure, analytics, contracting, compliance, and revenue-cycle support while preserving practice-level clinical autonomy.This leader will build governed data pipelines and reconciliation-ready accounting datasets on Azure/Snowflake, translating source-system activity such as practice-management, billing, RCM, contractual, and general-ledger data into timely, traceable, and explainable revenue and accrual outputs. The position combines hands-on engineering, financial controls design, data modeling, and close-cycle delivery support.The primary purpose of the role is to standardize and automate revenue recognition and accrual processes across affiliated practices while improving control, transparency, auditability, and scalability. The successful candidate will partner with Finance, Accounting, Revenue Cycle, and technology teams to reduce manual work, shorten close timelines, improve reconciliation quality, and create durable financial-data assets.Responsibilities/Duties/Functions/Tasks:Own the technical roadmap and delivery plan for the Revenue Recognition Data Product, including source onboarding, data quality, reconciliation, controls, and production support.Architect and build scalable ingestion, transformation, and orchestration pipelines using Azure services and Snowflake.Develop a canonical revenue-accounting data model that standardizes charges, payments, adjustments, contractual allowances, refunds, credit balances, unapplied cash, denials, reserves, accruals, and journal-entry support.Translate accounting requirements and revenue-recognition policy into transparent, version-controlled transformation logic, while Accounting retains policy ownership and final close approval.Establish automated reconciliations among source systems, subledgers, RCM platforms, data-product outputs, and the general ledger, with documented exception-management workflows.Build data controls for completeness, accuracy, timeliness, uniqueness, lineage, change management, and period-close signoff.Produce auditable documentation, including source-to-target mappings, business rules, control evidence, lineage, data dictionaries, runbooks, and release records.Partner with Finance and Revenue Cycle leaders to define close-calendar milestones, materiality thresholds, approval points, and service-level expectations.Lead technical discovery and onboarding for multiple practice groups and acquired entities, balancing enterprise standardization with local-system variation.Implement observability and support practices, including monitoring, alerting, incident response, root-cause analysis, and post-close validation.Establish reusable engineering standards for SQL, Python, Git-based development, CI/CD, testing, infrastructure-as-code, security, and peer review.Mentor engineers and provide technical leadership for future revenue-accounting engineering workstreams.Communicate clearly with technical and nontechnical stakeholders, including reconciliation results, delivery status, risks, decisions needed, and realized value.QualificationsBachelor’s degree in computer science, information systems, engineering, accounting, finance, or a related discipline; equivalent practical experience considered.8+ years of data engineering, analytics engineering, data warehousing, or related experience.3+ years leading complex technical deliveries, technical workstreams, or other engineers.Demonstrated experience building production data pipelines and curated data models using Snowflake and Azure.Strong SQL and Python skills, including transformation logic, testing, troubleshooting, and performance tuning.Experience with modern ELT/ETL, orchestration, CI/CD, Git-based development, automated testing, and production monitoring.Experience integrating heterogeneous financial, operational, billing, ERP, practice-management, or RCM systems.Strong understanding of data modeling, reconciliation design, data quality, lineage, metadata, security, and operational support.Ability to translate complex business and accounting concepts into maintainable, testable data logic.Strong stakeholder-management and written-communication skills, with the ability to work effectively with Accounting, Finance, auditors, revenue-cycle operators, and engineers.Preferred qualificationsHealthcare-provider, MSO, physician-practice, payer, or revenue-cycle experience.Direct experience supporting revenue recognition, accruals, month-end close, GL interfaces, accounting reserves, or financial controls.Familiarity with healthcare-revenue concepts such as charge capture, remittances, contractual adjustments, denial trends, refunds, patient balances, and AR aging.Experience with dbt, Azure Data Factory, Azure Databricks, Azure DevOps, Terraform, Airflow, or comparable tooling.Knowledge of healthcare privacy and security obligations, including HIPAA-aligned data handling.CPA, CMA, accounting degree, or meaningful partnership experience with controllership and audit stakeholders.Experience in M&A, multi-entity consolidation, practice onboarding, or system conversion work.Performance Requirements:Self-managed or need little supervisionPersistence in staying on task to solve technical problemsFlexibility and initiativeAccountability for own schedule and reporting on activitiesConceptual thinkingEquipment Operated: This role routinely uses standard office equipment such as computers, phones, and fax machines.Work Environment: This job operates in professional office environments.Physical Requirements: While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; and taste or smell. The employee must occasionally lift or move up to 50 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus.