Lead Data Engineer
Providence10 days ago
Hyderābād, IndiaStaff+
Responsibilities
- Design and deliver scalable end-to-end data engineering and analytics solutions using Oracle Fusion Data Intelligence, Oracle Analytics Cloud, Oracle Data Integrator, Oracle databases, Autonomous Data Warehouse, SQL, PL/SQL, and related cloud technologies.
- Develop and support Oracle FDI and OAC extensions, semantic models, datasets, dashboards, reporting solutions, and custom data requirements.
- Design and implement ETL/ELT pipelines and data integration solutions across Oracle Fusion, enterprise data platforms, analytics systems, and downstream applications.
- Design and maintain data warehouses, dimensional and semantic models, tables, views, and reusable analytical data layers.
- Build full and incremental data-load processes with transformation, validation, reconciliation, error handling, logging, and data-quality controls.
- Optimize SQL, PL/SQL, pipelines, integrations, data models, and analytics solutions for performance, scalability, reliability, and maintainability.
- Lead production troubleshooting, root-cause analysis, preventive improvements, testing, UAT, deployments, migrations, upgrades, releases, and production stabilization.
- Collaborate with business, functional, application, engineering, analytics, cloud/platform, and product teams to translate requirements into technical solutions.
- Provide technical leadership through architecture and design reviews, code reviews, mentoring, engineering standards, and reusable solution development.
- Contribute to modernization of legacy data and reporting solutions and evaluate modern cloud-based and AI-enabled data engineering capabilities.
- Maintain solution designs, data mappings, operational documentation, technical standards, and support procedures.
Requirements
- 6–8 years of hands-on experience in data engineering, data warehousing, business intelligence, analytics, data integration, or related areas.
- Strong hands-on expertise with Oracle Fusion Data Intelligence, Oracle Analytics Cloud, and Oracle Data Integrator in enterprise-scale solutions.
- Strong experience with Oracle Database and/or Oracle Autonomous Data Warehouse and advanced proficiency in SQL and PL/SQL.
- Understanding of ETL/ELT architecture, data pipelines, integration, transformation, orchestration, and full/incremental data-load patterns.
- Experience with Oracle Fusion application data, FDI extensions, enterprise reporting, and custom data integrations.
- Knowledge of data warehousing, dimensional modeling, semantic modeling, data integration architecture, and analytical/reporting architectures.
- Experience with data validation, reconciliation, data-quality controls, source-to-target mapping, logging, monitoring, and observability.
- Experience with production support, root-cause analysis, performance tuning, and resolution of complex data and analytics issues.
- Experience across the development-to-production lifecycle, including design, development, testing, UAT, deployment, upgrades, releases, migrations, and production stabilization.
- Understanding of cloud data architecture, data sharing, security, governance, metadata, performance, and operational reliability.
- Familiarity with Git/version control, code reviews, development standards, documentation, and CI/CD concepts.
- Ability to lead technical discussions, guide developers, review designs, identify technical risks and dependencies, and drive solutions across multiple teams.
- Strong collaboration and communication skills with the ability to translate business requirements into technical solutions.
- Oracle AI Data Platform and modern AI-enabled data engineering and analytics experience are preferred.
- Snowflake experience with ingestion, transformation, SQL development, data modeling, data sharing, and cloud data engineering is preferred.
- Exposure to OCI, REST APIs, Power BI, Apache Iceberg, modern/open data architectures, and AI-assisted engineering is advantageous.
- Bachelor's or master's degree in Computer Science or a related field.
Benefits
- The posting describes a collaborative, learning-oriented environment focused on exploration, experimentation, innovation, and continual service improvement.
About Providence
Providence is a nonprofit Catholic health system that operates hospitals, clinics, and related care services for patients and communities across the western U.S. It runs 51 hospitals and 829 clinics and also offers a health plan in select markets. Headquartered in Renton, Washington, Providence provides acute, ambulatory, virtual, and home-based care along with pharmacy and behavioral health services, supported by centralized technology, cybersecurity, and shared services teams.