[Hiring] Senior Consultant, Advisory Services @UnitedHealth Group

Role Description

This role involves research, design, and development of 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/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
• Develop innovative approaches

Qualifications

• 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

Requirements

• 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 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
• Coordinating/facilitating communications between the client organization and internal teams

Benefits

• Full range of comprehensive benefits, including medical, dental and vision
• Matching 401k
• Employee stock purchase plan