Senior Consultant, Advisory Services Job at Optum Services, Inc., Eden Prairie, MN

SktROGJtM21sSXE4RDNrM0ZNYjNRSGg3a1E9PQ==
  • Optum Services, Inc.
  • Eden Prairie, MN

Job Description

EMPLOYER: Optum Services, Inc. JOB TITLE: Senior Consultant, Advisory Services LOCATION: 1 Optum Circle, Eden Prairie, MN 55344 (Telecommuting available from anywhere in the U.S.) DUTIES: Research, design, and develop computer and network software or specialized utility programs. Duties include: 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/GitHub; 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; and Develop innovative approaches. Telecommuting is available from anywhere in the U.S. REQUIREMENTS: Employer will accept a Master's degree in Technology Management or a related field and three (3) years of experience in the job offered or in a related computer-related occupation. Position requires 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 process using SSIS to extract data from Heterogenous 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 visualization using SSRS, PowerBI 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 manage 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 the jobs, ensuring efficient and timely execution on the 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; and Coordinating/facilitating communications between the client organization and internal teams. RATE OF PAY: $145,018.00- $184,590 / per year Please apply via GlobalRecruitment@uhg.com and search for job #2333312

Job Tags

Remote work,

Similar Jobs

Maxion Corp

Work At Home Data Entry - Remote - Administrative Assistant Job at Maxion Corp

Join Our Team as a Work-From-Home Data Entry Research Panelist! Are you ready to earn money from the comfort of your own home? This exciting opportunity is perfect for anyone with a variety of skills and backgrounds whether youve been an administrative...

The Barker Lounge

Dog Bather Job at The Barker Lounge

We are looking for a dog bather/group leader to join our Barker Lounge team at our 1719 Montford Drive location. It is important to recognize this as a dual position . The candidate will have bathing experience in the past and also must work as a staff group leader...

Experian

Account Executive , Auto Industry, (Advertising Martech & Agencies) Job at Experian

 ...position at Experian Automotive will work across lines of Dealer Agencies, Marketing Tech, CDPs and more. You will grow existing lines...  ...clients.As the sales lead on your portfolio of automotive advertisers, you will be responsible for revenue growth, short- and long-term... 

Elevate Human Capital

Warehouse Associate/Order Puller Job at Elevate Human Capital

 ...array of functions that may include receiving and processing incoming stock and materials, picking and filling orders from stock, packing and shipping orders, or managing, organizing and retrieving stock in the warehouse. QUALIFICATIONS: One to two years of warehouse... 

Riverside Medical Clinic

NURSE EDUCATOR - DIABETES - Full Time Job at Riverside Medical Clinic

 ...sex, and cultural and religious beliefs, which may affect the education process and compliance. Also responsible for developing and advising...  ...or EXPERIENCE: Must be a graduate from an accredited school of nursing. Bachelors Degree from a four-year college or university...