Lead Business Intelligence Developer- Remote

UPMC

14h•Remote

About The Position

The Lead Business Intelligence Developer manages and develops business intelligence assets for the Department of Health Economics. The role partners with business and clinical leaders to understand business needs and uses semantic model design, data visualization, data storytelling, and creativity to deliver user-friendly BI tools and assets. Power BI is strongly preferred. The developer assesses the department’s current BI tools, identifies opportunities to organize or combine information for easier use, and creates tools for deeper exploration of existing and future-state data assets. The role also promotes existing tools and helps users understand which tools to use for different business needs. Health insurance experience is not required but is strongly desired. This is a full-time remote position working Monday through Friday. The role may require extended daily hours or extended work weeks to meet project deadlines and turnaround times.

Requirements

Bachelor’s degree in Computer Science or a related field, such as Mathematics, Economics, Health Care, Information Management, or Statistics.
At least five years of relevant professional experience in requirements gathering, analysis, design, database development, or reporting analysis.
Demonstrated professionalism, enthusiasm, and initiative.
Ability to work in a fast-paced environment and manage multiple tasks and projects.
Ability to build strong interpersonal relationships within the department, across departments, and with external audiences.
Ability to plan, organize, monitor, and control projects to achieve objectives.
Strong attention to detail, customer orientation, and ability to deal with ambiguity.
Excellent planning, communication, documentation, organizational, analytical, and problem-solving abilities.
Advanced mathematical skills.
Ability to interpret and summarize analysis results in a timely and meaningful way.
Excellent written, verbal communication, and presentation skills for communicating with all organizational levels.
Highly proficient understanding of relational databases (SQL Server preferred), database structures including complex views, stored procedures, SSRS, and SSIS.
Must be flexible and willing to perform other tasks as assigned by the manager or upper-level analysts.
Act 34 clearance.

Nice To Haves

Health insurance experience is strongly desired but not required.
Power BI experience is strongly preferred.

Responsibilities

Collect, organize, analyze, and prepare standard and ad hoc reports accurately and in a timely, meaningful way.
Design and maintain reusable semantic models and serve as a subject matter expert and point of contact for technical users.
Work with financial, clinical, operations, and actuarial clients to define, analyze, and document complex business and reporting requirements.
Complete ongoing on-the-job, course-based, and self-directed training to maintain and enhance technical capabilities.
Meet deadlines and turnaround times, including working extended daily hours or work weeks when needed to complete projects.
Serve as a process expert and provide training and support to other Business Intelligence and Analytics staff; provide supervisory support and quality control review as needed.
Develop and maintain reports and services using Power BI, Excel, SQL, Microsoft Fabric, and Snowflake.
Respond professionally to unfamiliar, undefined, or unexpected situations.
Perform peer reviews as requested.
Identify departmental needs and recommend solutions to management.
Coordinate orientation for new staff members.
Evaluate and document client needs, current processes, and proposed revisions; document requirements, define scope and objectives, and formulate strategy.
Develop and maintain working relationships with business partners, professional peers, team members, and external contacts.