Business Intelligence Developer

Job Title: Business Intelligence Developer

Department: Business Intelligence

Reports to: Director of Business Intelligence

Exemption: Non-Exempt

Date Revised: 09/16/2025

Position Summary

The Business Intelligence (BI) Developer plays a key role in developing, implementing, and

maintaining BI solutions that support business objectives. This position collaborates with the BI team

and business stakeholders to translate requirements into functional reports, dashboards, and data

solutions. The BI Developer focuses on hands-on development in SQL and Power BI, providing

ongoing technical support for BI systems, fulfilling helpdesk requests and ad-hoc data inquiries to

ensure the agency has timely and accurate information.

Essential Functions

• Develop, test, and deploy end-to-end BI solutions, including reports and dashboards, using tools such as Power BI
• Write, optimize, and maintain queries, stored procedure and functions for data extraction, transformation, and manipulation
• Build semantic models and write DAX measures for report development
• Create visualizations to stakeholder specifications using bar charts, time-series graphs, custom buttons/filters, etc.
• Respond to and resolve BI-related helpdesk requests in a timely manner
• Fulfill ad-hoc data requests for business stakeholders
• Support the installation, deployment, and population of databases
• Perform routine database and BI system maintenance, including applying upgrades and fixes.
• Assist in the implementation of maintenance plans and integrity checks
• Create and maintain technical documentation for new and existing BI solutions
• Assist in training users in the startup and basic use of database systems and reports
• Work with the BI team to validate data models and ensure data quality and integrity in developed solutions
• Evaluate legacy reporting systems for updating to current business definitions and migration to Power BI

Job Role Expectations

• Complete all assigned tasks and training by assigned deadline
• Stay abreast of new technologies and design approaches
• Develop a deep understanding of department needs and unique position requirements and key success drivers
• Apply sound judgment and know when to escalate issues and concerns
• Maintain confidentiality on a business need-to-know basis with all aspects of employee, organizational, and donor information
• Other duties as assigned

Organizational Expectations

• Uphold LOPA core values of selfless, authentic and passionate
• Serves as a role model for all employee and leadership written expectations
• Timely completion of all required educational training, tasks and SOP reviews by assigned due date

Work Environment

• Possible exposure to communicable diseases, bloodborne pathogens, airborne illnesses, hazardous materials, pharmacological agents with little likelihood of harm if established health precautions are followed.
• May, at times, have exposure to blood, packaged organs and tissues for transplant and/or research in a hospital setting or while in the office.
• Possible mental and visual fatigue associated with detailed work.
• This position requires travel, as needed.

Physical Demands

• Frequently remaining in a stationary position, often standing or sitting for prolonged periods.
• Occasionally reaching with hands and arms.
• Occasionally adjusting or moving objects up to 10 pounds in all directions.
• Frequently communicating with others verbally and electronically to exchange information.
• Occasionally stooping, bending, kneeling or crouching.
• Frequently repeating motions that may include the wrists, hands and/or fingers.
• Frequently assessing the accuracy, neatness and thoroughness of the work assigned.
• Frequently doing work that requires visual acuity and the use of fine motor skills.
• Need for the ability to hear.

Education and Experience

Bachelor’s degree from four-year college university in STEM or Business with five to seven

years related experience and/or training; or equivalent combination of education and

experience commensurate with the requirements for the position. Proficiency in data modeling,

report/dashboard design, SQL database administration and query optimization.

Knowledge, Skills & Abilities

• Ability to read, analyze and interpret complex data and technical procedures.
• Ability to write reports, business correspondence, and procedure manuals.
• Ability to calculate figures and compute data.
• Ability to solve practical problems.
• Ability to multitask.
• Thorough knowledge of software, BI and database systems.