Solutions Engineer Advisor Sr (ETL)
Job title: Solutions Engineer Advisor Sr (ETL) in Indianapolis, IN at United Global Technologies
Company: United Global Technologies
Job description: Job Description:
Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms.
Primary duties may include but are not limited to:
Maintains active relationships with customers to determine business requirements, leads requirements gathering meetings and reviews designs with the business.
Leads efforts with Web and marketing team to increase the presence of web products.
Owns the change request process and coordinates with other teams as necessary.
Develops and owns list of final enhancements.
Develops and defines application scope and objectives and supervises the preparation of technical and/or functional specifications from with programs will be written.
Performs technical design reviews and code reviews.
Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan.
Responsible for delivery of application technology solutions and data information planning effort.
Coordinates and manages on-call support and owns the system monitoring process.
Owns the technical development environment and works on the Enterprise team.
Leads multiple or large projects and facilitates large group JAD sessions for requirements, modeling in several disciplines.
Leads vendor evaluation and analysis.
Requires an BA/BS degree in related field or technical institute training;
7 or more years related experience; multi-platform experience, and expert level experience with business and technical applications; or any combination of education and experience, which would provide an equivalent background.
Incumbent should also have the ability to mentor others and provide troubleshooting support.
Multi database and/or multi language preferred.
Preferred Skills, Capabilities and Experiences:
Over 5 years of experience in designing, developing, testing, and implementing enterprise ETL solutions, as well as process automation and orchestration.
Proficiency with cloud data processing platforms and technologies, including AWS data pipeline toolsets.
Expertise in data process orchestration and the design and development of near-real-time and batch data pipelines.
Skilled in programming languages such as Python, Scala, SQL, R, and T-SQL.
Ability to analyze, troubleshoot, and optimize SQL queries, with the capability to recommend improvements.
Experience in analyzing and monitoring data processing resources, implementing proactive alerts and notifications based on SLAs.
Possession of relevant certifications in data engineering/development platforms and related technologies.
Experience in the healthcare claims processing industry with an understanding of data security and privacy considerations.
Strong critical thinking and problem-solving skills.
Key Responsibilities:
Design and develop scalable cloud data pipelines using AWS technologies, such as AWS Glue, for extracting, transforming, and loading (ETL) data from various sources into data lakes or warehouses.
Create and maintain data models to support efficient querying and reporting, ensuring data integrity and consistency.
Integrate data from multiple sources, including relational databases, APIs, and unstructured data, to provide a unified view for analysis.
Develop interactive dashboards and reports in Microsoft Power BI to present data insights to stakeholders and facilitate informed decision-making.
Optimize ETL processes and Power BI reports for performance, ensuring data availability and responsiveness.
Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver solutions that meet business needs.
Demonstrate proficiency in SQL and scripting languages such as Python or Scala.
Build data visualizations to effectively illustrate trends, patterns, and outliers.
Monitor and refine data pipelines and visualization tools to meet SLAs and delivery expectations.
Provide timely updates to customers, business units, and staff regarding projects and tasks.
Conduct proactive data reviews to ensure the quality and accuracy of reporting solutions.
Ensure data processing and storage operations are conducted efficiently and in compliance with security guidelines.
Standard work days (Mon-Fri--40 hours per week) and working with teammates within EST timeframes (7am-6pm window) to support team collaboration and meetings. (Remote role as a temp worker) Hybrid schedule if converted--must be 50 miles from one of these locations.
These Locations:
Indianapolis, IN
Denison, TX
Baltimore, MD
Harrisburg, PA
Syracuse, NY
Portland, ME
Hingham, MA
Expected salary:
Location: Indianapolis, IN
Apply for the job now!
Apply Now
Company: United Global Technologies
Job description: Job Description:
Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit or corporate department and utilizing various customer technology platforms.
Primary duties may include but are not limited to:
Maintains active relationships with customers to determine business requirements, leads requirements gathering meetings and reviews designs with the business.
Leads efforts with Web and marketing team to increase the presence of web products.
Owns the change request process and coordinates with other teams as necessary.
Develops and owns list of final enhancements.
Develops and defines application scope and objectives and supervises the preparation of technical and/or functional specifications from with programs will be written.
Performs technical design reviews and code reviews.
Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan.
Responsible for delivery of application technology solutions and data information planning effort.
Coordinates and manages on-call support and owns the system monitoring process.
Owns the technical development environment and works on the Enterprise team.
Leads multiple or large projects and facilitates large group JAD sessions for requirements, modeling in several disciplines.
Leads vendor evaluation and analysis.
Requires an BA/BS degree in related field or technical institute training;
7 or more years related experience; multi-platform experience, and expert level experience with business and technical applications; or any combination of education and experience, which would provide an equivalent background.
Incumbent should also have the ability to mentor others and provide troubleshooting support.
Multi database and/or multi language preferred.
Preferred Skills, Capabilities and Experiences:
Over 5 years of experience in designing, developing, testing, and implementing enterprise ETL solutions, as well as process automation and orchestration.
Proficiency with cloud data processing platforms and technologies, including AWS data pipeline toolsets.
Expertise in data process orchestration and the design and development of near-real-time and batch data pipelines.
Skilled in programming languages such as Python, Scala, SQL, R, and T-SQL.
Ability to analyze, troubleshoot, and optimize SQL queries, with the capability to recommend improvements.
Experience in analyzing and monitoring data processing resources, implementing proactive alerts and notifications based on SLAs.
Possession of relevant certifications in data engineering/development platforms and related technologies.
Experience in the healthcare claims processing industry with an understanding of data security and privacy considerations.
Strong critical thinking and problem-solving skills.
Key Responsibilities:
Design and develop scalable cloud data pipelines using AWS technologies, such as AWS Glue, for extracting, transforming, and loading (ETL) data from various sources into data lakes or warehouses.
Create and maintain data models to support efficient querying and reporting, ensuring data integrity and consistency.
Integrate data from multiple sources, including relational databases, APIs, and unstructured data, to provide a unified view for analysis.
Develop interactive dashboards and reports in Microsoft Power BI to present data insights to stakeholders and facilitate informed decision-making.
Optimize ETL processes and Power BI reports for performance, ensuring data availability and responsiveness.
Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to understand data requirements and deliver solutions that meet business needs.
Demonstrate proficiency in SQL and scripting languages such as Python or Scala.
Build data visualizations to effectively illustrate trends, patterns, and outliers.
Monitor and refine data pipelines and visualization tools to meet SLAs and delivery expectations.
Provide timely updates to customers, business units, and staff regarding projects and tasks.
Conduct proactive data reviews to ensure the quality and accuracy of reporting solutions.
Ensure data processing and storage operations are conducted efficiently and in compliance with security guidelines.
Standard work days (Mon-Fri--40 hours per week) and working with teammates within EST timeframes (7am-6pm window) to support team collaboration and meetings. (Remote role as a temp worker) Hybrid schedule if converted--must be 50 miles from one of these locations.
These Locations:
Indianapolis, IN
Denison, TX
Baltimore, MD
Harrisburg, PA
Syracuse, NY
Portland, ME
Hingham, MA
Expected salary:
Location: Indianapolis, IN
Apply for the job now!
Apply Now