Lead Business Intelligence Developer- Remote

$74,734 - $127,546/Yr

University of Pittsburgh Medical Center - Pittsburgh, PA

Full-time - Mid Level

Remote - Pittsburgh, PA

Hospitals

About the position

UPMC Health Plan has an exciting opportunity for a Lead Business Intelligence Developer position in the Health Economics department. This is a full-time position working daylight hours and is a remote position. The Lead Business Intelligence Analyst needs to have analytical and programming capabilities to develop and maintain reports and services using tools like Power BI, Excel, and SQL. The Lead Business Intelligence Analyst will work with clients to define, analyze, and document complex business and reporting requirements. The Lead Business Intelligence Analyst must have the ability to plan and execute complex projects from concept to reality. This role requires superb business process analysis and interpersonal skills, as well as the ability to provide information consumable by senior business decision makers. In this role, you will be responsible for the full lifecycle of analytic activities, including requirements gathering and data designs, development of analytic tools, and reporting capabilities. The position demands strong analytical skills with the ability to collect, organize, analyze, and prepare standard and ad hoc reports in a timely and meaningful way, with attention to detail and accuracy. You will work with clients from diverse areas of the business, including financial, clinical, operations, and actuarial staff, to define, analyze, and document complex business and reporting requirements. Additionally, the Lead Business Intelligence Analyst will complete ongoing training on-the-job, through courses, and self-study to maintain and enhance technical capabilities. Meeting deadlines and turnaround times set by managers and department directors is crucial, and this may require extended daily work hours or extended work weeks. You will serve as a process expert, providing training and support to other Business Intelligence staff as needed, and assume supervisory support and quality control review as necessary. The role also involves developing and maintaining reports and services using tools like Power BI, Excel, and SQL, overseeing other Business Intelligence Analysts on a day-to-day basis, and providing guidance and assistance as necessary. The Lead Business Intelligence Analyst will also be responsible for identifying departmental needs and providing recommendations for addressing and resolving business issues to management as appropriate, coordinating the orientation of new staff members, and evaluating and documenting client needs, including current processes and proposed revisions. This position requires a Bachelor's degree in computer science or a related field, along with a minimum of five years of relevant professional experience in requirements gathering, analysis, design, database development, or reporting analysis.

Responsibilities

• Possess strong analytical skills with the ability to collect, organize, analyze, and prepare standard and ad hoc reports in a timely and meaningful way with attention to detail and accuracy.
• Work with clients from diverse areas of the business including financial, clinical, operations, and actuarial staff to define, analyze, and document complex business and reporting requirements.
• Complete ongoing training on-the-job, through courses and self-study to maintain and enhance technical capabilities.
• Meet deadlines and turnaround times set by managers and department director, which may require extended daily work hours or extended work weeks.
• Serve as a process expert and provide training and support to other Business Intelligence staff as needed.
• Assume supervisory support and quality control review as needed.
• Develop and maintain reports and services using tools like Power BI, Excel, and SQL.
• Oversee other Business Intelligence Analysts on a day-to-day basis and provide guidance/assistance as necessary.
• Respond to unfamiliar, undefined, or unexpected situations with a professionally prescribed standard response.
• Perform peer reviews as requested.
• Identify departmental needs and provide recommendations for addressing and resolving business issues to management as appropriate.
• Coordinate the orientation of new staff members.
• Evaluate and document client needs, including current processes and proposed revisions.
• Document requirements, define scope and objectives, and formulate strategy.
• Responsible for the distribution of work assignments for their team as well as workload management within their team.
• Develop and maintain working relationships with business partners, professional peers, other team members, and external contacts as appropriate.

Requirements

• Bachelor's degree in computer science or related field (Mathematics, Economics, Health Care, Information Management or Statistics) is required.
• Minimum five years of relevant professional experience required in requirements gathering, analysis, design, database development or reporting analysis.
• Demonstrate a high degree of professionalism, enthusiasm and initiative on a daily basis.
• Ability to work in a fast-paced environment a must.
• Ability to manage multiple tasks and projects, and forge strong interpersonal relationships within the department, with other departments, and with external audiences.
• Ability to plan, organize, monitor and control projects to achieve project objectives.
• Attention to detail is critical to the success of this position, with demonstrated competency in customer orientation and the ability to deal with ambiguity.
• Excellent planning, communication, documentation, organizational, analytical, and problem-solving abilities.
• Advanced mathematical skills.
• Ability to interpret and summarize results of various analyses in a timely and meaningful way.
• Ability to effectively approach problem solving.
• Must be flexible and willing to perform other tasks as assigned by the manager or upper-level analysts.
• Excellent written and verbal communication and presentation skills to effectively communicate information to all levels within the organization.
• Must possess a highly proficient understanding of relational databases (SQL Server preferred), database structures (complex views), stored procedures, SSRS, and SSIS.

Benefits

• Health insurance
• On-the-job training