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

K2krUkRua01HSldmZ0l2c2VtYjRUVE1qV0E9PQ==
  • 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

Walmart Inc.

Manager, Quality Control-Sam's Club Job at Walmart Inc.

 ...What you'll do at Position Summary... What you'll do... Job Description Working at Sams Club means a career without boundaries. Theres always room to grow, to take on another challenge, to roll up your sleeves and contribute, and to find professional... 

Transwest Mobile Truck & Trailer

Heavy Duty Diesel Mechanic (Mobile) Job at Transwest Mobile Truck & Trailer

 ...What Youll Do Lead advanced diagnostics and repairs on heavy-duty diesel engines, hydraulics, electrical systems (including CAN bus and...  .... ~ Expert-level knowledge of electrical, hydraulic, and mechanical systems. ~ Proficiency in advanced diagnostics and complex... 

Erosion Solutions

CDL Company Dump Truck Driver Job at Erosion Solutions

 ...About the Job: We are seeking dependable Class A CDL Truck Drivers to join our Englewood, TN team. Candidates who are licensed in manual transmission are a strong plus. This is a local driving position that provides steady, year-round work with a MondayFriday schedule... 

MaverickX

Biology Lab Technician Job at MaverickX

 ...ordering and inventory management of laboratory supplies. Qualifications ~ Bachelors in biochemistry, molecular biology, biotechnology, or a related field. ~1-2 years of hands-on experience in a laboratory setting. ~ Experience in protein purification techniques... 

JND

HR Generalist 3 (16623-1) Job at JND

 ...)~ Paid Time Off ~401K ~ H1B/Green Card Sponsorship for qualified employee ~ Hands-on experience at global industry leader Samsung ~ Opportunities for career advancement Compensation $30-32/hr Position Summary The Manager, HRBP for Samsung Electronics...