Role: Data Warehouse and BI Maintenance and Operations Engineer
Location: Remote
Position: 1
Work Arrangement: Remote
Role OverviewWe are seeking an experienced Data Warehouse and BI Maintenance and Operations Engineer to support the data lake, data warehouse, and reporting layer of a Medicaid Analytics platform. The platform integrates Medicaid claims and clinical data to enable analytics and reporting for a State Medicaid Program.
The ideal candidate will have strong experience in SQL, Snowflake, ETL processes, and Python, with the ability to support production operations, troubleshoot data pipelines, resolve incidents, and maintain reporting solutions. Previous experience in the healthcare domain, particularly Medicaid, is preferred.
Required Skills- Strong experience with SQL and database troubleshooting.
- Hands-on experience with Snowflake.
- Experience supporting ETL processes and data pipelines.
- Working knowledge of Python.
- Experience in production support, monitoring, and incident management.
- Ability to troubleshoot data processing, integration, and reporting issues.
- Strong analytical, problem-solving, and communication skills.
Preferred Skills- Experience with Tableau.
- Experience with Cognos reporting.
- Healthcare domain experience, preferably Medicaid claims and clinical data.
- Experience supporting data warehouses, data lakes, and BI platforms.
Key Responsibilities- Monitor production data pipelines, batch jobs, interfaces, reports, and overall system health, including weekend monitoring on a team rotation basis.
- Investigate and resolve job failures, processing exceptions, performance issues, and operational alerts.
- Support the data warehouse and reporting layer by troubleshooting reports, dashboards, data models, queries, and data availability issues affecting federal, state, and ad hoc reporting.
- Communicate data warehouse refresh status, delays, and potential impacts to clients and other vendor teams.
- Triage and resolve help desk tickets within defined SLAs, troubleshooting issues across application, data, integration, infrastructure, and reporting layers.
- Lead or support root cause analysis for significant or recurring incidents and implement corrective and preventive actions.
- Analyze defects and deliver approved fixes and minor enhancements, including impact analysis, development or configuration changes, unit testing, deployment support, and documentation updates.
- Coordinate with offshore development teams on changes, defect fixes, and day-to-day activities.
- Support release planning, design validations, deployments, patches, configuration changes, and upgrades in accordance with approved change management processes.
- Participate in maintenance windows, post-deployment verification, and rollback activities when required.
Expected Deliverables- Stable production operations and effective monitoring of data pipelines, data warehouse, and reporting platforms.
- Timely resolution of help desk tickets and production incidents within applicable SLAs.
- Root cause analysis and corrective actions for recurring production issues.
- Approved defect fixes and minor enhancements.
- Release, deployment, and post-deployment support.
- Updated operational and technical documentation.
Education RequirementBachelor's degree in Computer Science, Information Technology, Engineering, Business Administration, or a related field is preferred.
Our Perks and BenefitsOur benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning experience, and provide care and support for you and your loved ones.
We also offer:
- Health Insurance with Dental & Vision
- 401K Plan
- Life Insurance, STD & LTD
- Paid Vacations & Holidays
- Continuous Skill Based Development and Career Advancement Opportunities