Senior Analytics Engineer, Revenue Accounting (Snowflake)

The Specialty Alliance; Southlake (TX); Sur place; USD 130 000 - 180 000; Plein temps

Résumé du poste

The Senior Analytics Engineer, Revenue Accounting at The Specialty Alliance will design and build a governed transformation layer for the revenue-accounting data product. You will convert heterogeneous source data into controlled, auditable outputs supporting reconciliations, accruals, and journal-entry work.

You will translate accounting requirements into durable data logic, deliver automated tests, and collaborate with Finance stakeholders to ensure accurate, trusted reporting.

Qualifications

• Bachelors degree in a relevant field or equivalent practical experience.
• 5+ years of analytics engineering or related experience.
• Deep SQL expertise and Snowflake or similar cloud platform.
• Experience with dbt or similar transformation/testing frameworks.
• Ability translating complex business logic into curated data models.
• Strong knowledge of data quality, lineage, and release practices.
• Experience collaborating with business stakeholders to refine metrics.
• Familiarity with Python, Git, CI/CD, and automated quality checks.

Responsabilités

• 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 documentation and version control.
• Create curated subject-area datasets for charges, payments, contractual adjustments, refunds, 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.
• Collaborate 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 for Finance/audit stakeholders.
• Contribute to 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.

Connaissances

SQL

Snowflake

dbt

Python

Git

CI/CD

Formation

Bachelors degree in CS/IS/Engineering/Finance/Accounting

Outils

Azure Data Factory

Databricks

Azure DevOps

Description du poste

The Senior Analytics Engineer, Revenue Accounting at The Specialty Alliance will design and build a governed transformation layer for the revenue-accounting data product. You will convert heterogeneous source data into controlled, auditable outputs supporting reconciliations, accruals, and journal-entry work.

You will translate accounting requirements into durable data logic, deliver automated tests, and collaborate with Finance stakeholders to ensure accurate, trusted reporting.