The Data Engineering Advisor will be a key contributor to ensure the successful delivery of ETL Production Services and Application Support. To be successful in this role, you must have an advanced understanding of ETL processes and be experienced in supporting Production Services applications. You must also have excellent communication skills and be able to build and maintain relationships with both internal and external stakeholders.
They will be responsible for partnering with key players in Customer Service, Client Service, Provider Service, and Workforce Planning, while drawing on support from Technology, Finance, Strategy, Operational Readiness, and Solutions Delivery.
Essential Functions:
- Design, develop, and maintain ETL processes to ensure successful delivery of Production Services applications.
- Provide technical support for Production Services applications.
- Build and maintain relationships with internal and external stakeholders.
- Identify and address issues related to Production Services applications.
- Monitor and optimize ETL processes and applications performance.
- Create and implement best practices to ensure successful delivery and support of Production Services applications.
- Troubleshoot and resolve Production Services application issues.
- Collaborate with other team members to ensure timely and successful delivery of Production Services applications.
- Prepare detailed technical documentation.
Qualifications:
- 5+ years of relevant production support and project experience.
- Experience with Relational Database Development – Oracle, Teradata, SQL Server, PostgreSQL or equivalent required.
- Strong understanding of database concepts and experience with query optimization and performance tuning.
- Hands-on experience with ETL tools such as Informatica, along with proficiency in scripting languages like Python.
- Experience with scheduling tools such as CA Workload Automation.
- Knowledge of cloud computing concepts and experience with AWS services, such as S3, EC2, Lambda, and Glue.
- Hands on experience with Databricks and Airflow monitoring.
- Excellent problem-solving skills and the ability to analyze complex issues and implement effective solutions.
Primary Skills:
- Informatica, SQL (SQL Server, Oracle, Teradata)
- Job Scheduling (Airflow, DAG, Control M, etc.)
- Performance Tuning, Site Reliability Engineering, Issue Resolution
- Python, Databricks, DevOps, Basic Cloud Experience (AWS/Azure/GCP)
Additional Skills:
- Cloud Certification (AWS Cloud Practitioner or similar), Apache Spark