Senior Data Engineer

Position:  Senior Data Engineer – ETL Architecture & Domo

Experience:

5–8 Years

Role Summary
We are seeking a Senior Data Engineer to architect and implement scalable ETL frameworks for transforming Excel-based RCM operational data into a governed, analytics-ready data model within Domo.

The ideal candidate will drive data engineering strategy, automation, performance optimization, and data governance across the reporting lifecycle.

Key Responsibilities
Architecture & Design
Design end-to-end ETL/ELT architecture for ingesting multi-source data (Excel, flat files, APIs)
Build scalable ingestion pipelines using Domo Workbench, APIs, and automated scheduling
Define enterprise-grade data modeling standards (fact/dimension, star schema, conformed dimensions)
Establish naming conventions, dataset versioning, and environment promotion standards

Data Engineering & Transformation
Develop advanced SQL transformations and Magic ETL dataflows
Implement complex business logic including AR aging, denial categorization, payment posting, adjustments, and revenue analytics
Perform data normalisation, deduplication, and reconciliation against source systems
Optimize dataflows for performance and refresh efficiency
Implement incremental loads and change data capture (CDC) logic

Automation & Optimization
Automate file ingestion from network/shared drives or secure storage environments
Develop Python-based pre-processing scripts where required
Configure job scheduling, monitoring, logging, and failure alerts
Reduce manual reporting dependencies through process automation

Data Governance & Quality
Implement data validation frameworks and reconciliation checkpoints
Design audit trails for report traceability
Ensure SLA adherence for daily, weekly, and monthly reporting cycles
Establish data quality KPIs and monitoring dashboards

Collaboration & Leadership
Partner with MIS, Operations, and Business stakeholders to translate RCM logic into structured datasets
Mentor junior data engineers and analysts
Conduct technical design reviews and enforce engineering best practices
Drive continuous improvement initiatives in reporting modernization

Required Technical Skills
6+ years of hands-on experience in ETL pipeline development
Advanced SQL expertise (joins, window functions, performance tuning, query optimization)
Strong experience in Domo (Workbench, Magic ETL, SQL Dataflows, Dataset Governance)
Experience handling large structured Excel datasets and automating ingestion
Proficiency in Python for data manipulation (pandas, file automation, scripting)
Strong understanding of data modeling and warehousing concepts
Experience designing incremental and full refresh strategies
Exposure to secure data handling and role-based access control

Preferred Qualifications
Experience in Healthcare / RCM analytics
Familiarity with AR, Denials, Payments, Adjustments, Claims lifecycle
Experience migrating legacy Excel reporting to BI platforms
Knowledge of data orchestration tools or workflow schedulers