Sr Analytics Engineer (33003)

GI Alliance; Southlake (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

GI Alliance seeks a Senior Analytics Engineer for Revenue Accounting to design and implement governed transformations on Snowflake. You will build finance-ready data models, automated tests, and reconciliation datasets, bridging data engineering and finance analytics to ensure auditable, scalable outputs.

The role focuses on translating complex accounting logic into robust pipelines, collaborating with finance stakeholders, and ensuring data quality, lineage, and release controls across

Qualifications

• Bachelor's degree or equivalent practical experience.
• 5+ years in analytics/data engineering or related.
• Expertise in SQL and production-grade transformation logic in Snowflake or similar.
• Experience with dbt or similar ETL/transform frameworks, including tests.
• Translate complex business logic into scalable data models and pipelines.
• Knowledge of data quality, lineage, and controlled-release practices.
• Collaborate with stakeholders to refine metrics and improve reporting.
• Familiarity with Python, Git, CI/CD, and automated quality checks.

Responsibilities

• Design, build, and maintain Snowflake transformation models for revenue-related use cases.
• Translate accounting requirements into scalable SQL and analytics patterns with documentation.
• Create curated datasets covering charges, payments, adjustments, refunds, and reserves.
• Implement automated data tests for completeness, accuracy, and reconciliation behavior.
• Collaborate with data engineers and finance analysts to validate logic and outputs.
• Optimize performance, lineage, and maintainability across practices.
• Support parallel runs, validation, and post-release issue resolution.
• Document transformation logic, finance definitions, and test coverage.

Skills

SQL

Snowflake

Python

Git

CI/CD

Data modeling

Data testing

Education

Bachelor's degree in CS/IS/Engineering/Finance/Accounting/Math

Tools

dbt

Azure Data Factory

Databricks

Azure DevOps

Git

Job description

Company Conformance Statements

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

Company Conformance Statements

In 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 purpose

The Senior Analytics Engineer, Revenue Accounting will design and build the governed transformation layer for The Specialty Alliance's revenue-recognition and accrual data product. The role supports a physician-led, multi-specialty MSO model that combines shared operational infrastructure and analytics with practice-level autonomy, making standardized financial data models and transparent business logic essential.

This engineer will focus on Snowflake-based transformation logic, curated finance-ready data models, automated tests, and reconciliation-supporting datasets that convert source data into trusted accounting outputs. The position is deeply hands-on and sits between core data engineering and finance analytics, ensuring revenue-accounting logic is accurate, explainable, auditable, and scalable.

The primary purpose of the role is to transform heterogeneous source-system data into controlled, reusable, and finance-approved revenue-accounting models. This role will help reduce spreadsheet-driven accounting work, improve consistency across practices, and create durable data assets that support reconciliations, accruals, journal-entry support, and management reporting.

Responsibilities/Duties/Functions/Tasks

• Design, build, and maintain Snowflake transformation models for revenue, accrual, reconciliation, and close-support use cases.
• Translate accounting and business requirements into scalable SQL and analytics-engineering patterns, with strong documentation and version control.
• Build curated subject-area datasets covering charges, payments, contractual adjustments, refunds, credit balances, unapplied cash, denials, reserves, and other finance-relevant concepts.
• Implement automated data tests for completeness, accuracy, period alignment, duplication, referential integrity, and reconciliation behavior.
• Partner with the Lead Data Engineer to implement canonical revenue-accounting models, reusable transformation standards, and deployment controls.
• Work closely with the Revenue Accounting Data Product Owner and Finance Data Analyst to validate business logic, investigate variances, and refine outputs.
• Optimize model performance, lineage clarity, maintainability, and reusability across practices and future use cases.
• Support parallel runs, close-cycle validation, exception triage, and post-release issue resolution.
• Document transformation logic, finance definitions, test coverage, and release changes in a way Finance and audit stakeholders can understand.
• Contribute to engineering best practices for SQL, Python, Git, CI/CD, peer review, naming standards, and release management.
• Mentor junior analytics engineers or engineers assigned to future revenue-accounting workstreams.

Qualifications

• Bachelor's degree in computer science, information systems, engineering, finance, accounting, mathematics, or a related field; equivalent practical experience considered.
• 5+ years of analytics engineering, data engineering, BI engineering, or related experience.
• Deep expertise in SQL and strong experience building production-grade transformation logic in Snowflake or a comparable cloud data platform.
• Experience with dbt or similar transformation and testing frameworks, including documentation and modular model design.
• Experience translating complex business logic into scalable curated data models and testable data pipelines.
• Strong understanding of data quality, reconciliation principles, lineage, metadata, and controlled-release practices.
• Experience partnering with business stakeholders to refine metric definitions, resolve discrepancies, and improve trusted reporting outputs.
• Familiarity with Python, Git-based development, CI/CD, and automated quality checks.

Preferred Qualifications

• Healthcare-provider, MSO, physician-practice, payer, or revenue-cycle domain experience.
• Direct exposure to accounting, close support, revenue-recognition logic, accruals, reserves, or GL-supporting datasets.
• Experience with Azure ecosystem tools such as Azure Data Factory, Databricks, Azure DevOps, or comparable cloud tooling.
• Knowledge of healthcare-revenue concepts such as claims, remittances, contractual adjustments, denials, refunds, and AR aging.
• Experience supporting finance or audit stakeholders with lineage, rule documentation, and test evidence.
• Exposure to multi-entity data standardization, acquisitions, or system conversions.

Performance Requirements

• Self-managed or need little supervision
• Persistence in staying on task to solve technical problems
• Flexibility and initiative
• Accountability for own schedule and reporting on activities
• Conceptual thinking

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