Solutions Engineer Advisor Sr ETL

United Global Technologies; Indianapolis (IN); Remote; USD 90,000 - 130,000; Full time

Job summary

A leading technology company seeks a Data Engineer to design and develop scalable cloud data pipelines. The role involves collaborating with teams to enhance data processing and reporting, requiring strong technical skills and over 7 years of experience in the field. This position offers a remote work option and potential for a hybrid schedule.

Qualifications

• 7+ years of related experience in data engineering.
• Proficiency with cloud data platforms, especially AWS.
• Experience with healthcare claims processing preferred.

Responsibilities

• Design and develop scalable cloud data pipelines using AWS tools.
• Integrate data from various sources for comprehensive analysis.
• Develop dashboards and reports in Power BI for data insights.

Skills

Data process orchestration

Problem-solving

Critical thinking

SQL

Python

Scala

R

T-SQL

Education

BA/BS degree

Tools

AWS Glue

Power BI

Job description

Job Responsibilities:

1. Program on specific application subsets within the company's application portfolio, participating in all phases of the development and maintenance lifecycle, typically for an assigned business unit or department, using various customer technology platforms.
2. Maintain active relationships with customers to determine business requirements, lead requirements gathering meetings, and review designs with the business.
3. Collaborate with Web and marketing teams to enhance the presence of web products.
4. Own the change request process and coordinate with relevant teams.
5. Develop and manage a list of final enhancements.
6. Define application scope and objectives; supervise the preparation of technical and functional specifications for programming.
7. Conduct technical and code reviews.
8. Ensure completion of unit testing, system testing, and proper system implementation.
9. Deliver application technology solutions and oversee data information planning efforts.
10. Coordinate and manage on-call support; oversee system monitoring.
11. Manage the technical development environment within the Enterprise team.
12. Lead multiple or large projects and facilitate large group JAD sessions for requirements gathering and modeling.
13. Lead vendor evaluation and analysis.
14. Require a BA/BS degree or technical training, with 7+ years of related experience, multi-platform expertise, and advanced knowledge of business and technical applications.
15. Mentor others and provide troubleshooting support.
16. Prefer experience with multiple databases and languages.

Preferred Skills and Experience:

• Over 5 years designing, developing, testing, and implementing enterprise ETL solutions, process automation, and orchestration.
• Proficiency with cloud data platforms, especially AWS data pipeline tools.
• Expertise in data process orchestration, near-real-time and batch pipelines.
• Skilled in Python, Scala, SQL, R, T-SQL.
• Ability to troubleshoot and optimize SQL queries.
• Experience with data processing resource monitoring and proactive alerting.
• Relevant certifications in data engineering/development.
• Experience in healthcare claims processing, understanding data security and privacy.
• Strong critical thinking and problem-solving skills.

Key Responsibilities:

• Design and develop scalable cloud data pipelines using AWS tools like AWS Glue.
• Create and maintain data models for efficient querying and reporting.
• Integrate data from various sources for comprehensive analysis.
• Develop dashboards and reports in Power BI for data insights.
• Optimize ETL processes and Power BI reports for performance.
• Collaborate with cross-functional teams to meet data requirements.
• Proficiency in SQL, Python, Scala.
• Build data visualizations to highlight trends and outliers.
• Monitor and improve data pipelines and visualizations.
• Provide project updates and conduct data quality reviews.
• Ensure secure and efficient data processing and storage.

Work Schedule and Location:

Standard hours (Mon-Fri, 40 hours/week) within EST timeframes (7am-6pm). Remote role as a temporary worker; potential hybrid schedule if converted, requiring proximity within 50 miles of specified locations in Indianapolis, IN; Denison, TX; Baltimore, MD; Harrisburg, PA; Syracuse, NY; Portland, ME; Hingham, MA.