Lead Business Intelligence Developer- Remote

UPMC; Pittsburgh (Allegheny County); On-site; USD 110,000 - 140,000; Full time

Job summary

UPMC is seeking a Lead Business Intelligence Developer to manage BI assets for the Department of Health Economics and partner with clinical and business leaders to translate needs into semantic models and user-friendly BI tools.

The role emphasizes Power BI, data storytelling, and tools like SQL, Fabric, Snowflake, and Excel, with a Monday–Friday schedule in a remote setting. Strong analytical and communication skills are essential.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 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.
• Design and maintain reusable semantic models and serve as a SME and point of contact for technical users.
• 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.
• Completes on-going 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; may require extended hours.
• Develop and maintain reports and services using tools like Power BI, Excel, SQL, Microsoft Fabric, and Snowflake.
• Identify departmental needs and provide recommendations for addressing and resolving business issues to management as appropriate.

Skills

Analytical skills

Interpersonal skills

Data storytelling

Critical thinking

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

SQL Server

SSRS

SSIS

Microsoft Fabric

Snowflake

Excel

Job description

The Lead Business Intelligence Developer will be responsible for the overall management and development of business intelligence assets for the Department of Health Economics. Utilizing strong interpersonal skills, business acumen, and critical thinking, the individual will partner and consult with business and clinical leaders to identify and understand business needs. Once business needs are understood, the individual will utilize semantic model design and data visualization technical skills (Power BI strongly preferred), data storytelling skills, and creativity, to provide user-friendly, easy to consume BI tools and assets for our stakeholders. This individual will also assess the current suite of BI tools within the department and identify opportunities for combining or organizing information differently for ease of consumption. The individual will also build tools that allow for more in-depth exploration of our already existing and future-state groomed data assets. The individual will also champion existing assets and assist in helping our user base on understanding the suite of tools we have and how to appropriately leverage depending on the business need. Health insurance experience not required, but strongly desired.

This is a full time position working Monday through Friday and will be a remote position.

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.
• Design and maintain reusable semantic models and serve as a SME and point of contact for technical users.
• 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.
• Completes on-going 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 (these deadlines and turnaround times will, at times, require the employee to work until the project is completed, meaning extended daily work hours, extended work weeks, or both).
• Serve as a process expert and provide training and support to other Business Intelligence and Analytics staff as needed. Assume supervisory support and quality control review as needed.
• Develop and maintain reports and services using tools like Power BI, Excel, SQL, Microsoft Fabric, and Snowflake.
• Responds 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. Documents requirements, defines scope and objectives, and formulates strategy.
• Develop and maintain working relationships with business partners, professional peers, other team members, and external contacts as appropriate.
• 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.

Licensure, Certifications, and Clearances:

• Act 34

UPMC is an Equal Opportunity Employer/Disability/Veteran