Senior Consultant, Advisory Services

Senior Consultant, Advisory Services - 2373455

Employer: Optum Services, Inc.

Location: 1 Optum Circle, Eden Prairie, MN 55344 (Telecommuting available from anywhere in the U.S.)

• Research, design, and develop computer and network software or specialized utility programs.
• Perform all phases of software engineering including requirements analysis, application design, code development, and testing.
• Design and implement product features in collaboration with business and IT stakeholders.
• Design reusable stored procedures, routines, and functions to perform complex transformations components.
• Lead technology decisions, drive product implementation and delivery.
• Troubleshoot production support issues post deployment and determine solutions as required.
• Create and maintain data pipelines using Azure and Snowflake as primary tools.
• Manage code in Git/Git Hub.
• Understand data requirements and design optimal pipelines to fulfill use‑cases.
• Understand logical and physical data models to ensure data integrity is maintained.
• Tune and optimize data processes.
• Oversee code deployments to production environment, troubleshoot production data issues.
• Model large datasets to maximize performance for our Business Intelligence Team.
• Provide accurate and timely estimates for tasks.
• Provide support and leadership in critical production support issue resolution.
• Conduct or facilitate root cause analysis on all in‑scope incidents and recommend a corrective action plan.
• Work with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements.
• Conduct code reviews to ensure the work delivered by the team is of high‑quality standards.
• Develop innovative approaches.

• Master's degree in Technology Management or a related field.
• Three (3) years of experience in the job offered or in a related computer‑related occupation.
• Three (3) years of experience in the following:
• Designing, implementing, and managing scalable data warehousing using Snowflake and integrating with Azure cloud services.
• Building, parameterizing and optimizing SSIS packages and creating robust ETL processes using SSIS to extract data from heterogeneous source systems.
• Writing complex SQL queries, stored procedures, functions, CDC, indexes (clustered and non‑clustered).
• Optimizing SSIS and SQL procedures to improve the performance and scalability of the application.
• Developing reports, dashboards and visualizations using SSRS, Power BI and other BI tools to deliver valuable insights for business stakeholders.
• Building dashboards using Power BI data visualization.
• Git or Git Hub for version control and managing code repositories.
• Implementing robust error‑handling mechanisms in SSIS using event handlers, logging, and restarts to ensure data accuracy and fault tolerance.
• Configuring, scheduling and monitoring jobs, ensuring efficient and timely execution on workflows and ETL jobs.
• Enhancing application to call web services for user authentication, automate mail notifications and seamless user interaction with integrated services.
• Drive high levels of client satisfaction by focusing efforts on results that meet or exceed the client’s expectations.
• Maintaining ongoing contact with clients to identify and address emerging issues/concerns.
• Coordinating/facilitating communication between the client organization and internal teams.

Rate of Pay: $ - $184,590 per year

Benefits include medical, dental and vision coverage, matching 401(k), and an employee stock purchase plan.

Equal Opportunity

Employer:

United Health Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

United Health Group is a drug‑free workplace. Candidates are required to pass a drug test before beginning employment.