Business Intelligence Developer

LOPA; Covington (LA); On-site; USD 85,000 - 115,000; Full time

Job summary

LOPA in Covington, LA is seeking a hands-on Business Intelligence Developer to design, implement, and support BI solutions. You will work with the BI team and stakeholders to translate requirements into reports, dashboards, and data models tailored to agency needs, using query optimization, DAX measures, and cloud services.

The role focuses on development in relational databases and BI tools, providing ongoing support, maintenance, and user training. Onsite in Covington with travel as needed.

Qualifications

• Bachelor’s degree in STEM or Business; 5–7 years related experience or equivalent
• Proficiency in data modeling, report/dashboard design, SQL database administration and query optimization
• Ability to read, analyze and interpret complex data and technical procedures

Responsibilities

• Develop, test, and deploy end-to-end BI solutions including reports and dashboards
• Write, optimize, and maintain queries, stored procedures, and functions for data extraction and transformation
• Build semantic models and write DAX measures for report development
• Create visualizations per stakeholder specifications using various chart types
• Respond to and resolve BI-related helpdesk requests in a timely manner
• Assist in maintaining databases, applying upgrades and fixes
• Create and maintain technical documentation for BI solutions
• Train users on basic database systems and reports
• Validate data models and ensure data quality and integrity

Skills

SQL

Power BI

DAX

ETL

Data modeling

Education

Bachelor's degree in STEM or Business

Tools

Power BI Desktop

SQL Server

Azure/AWS cloud

Job description

Job Title: Business Intelligence Developer

Department: Business Intelligence

Reports to: Director of Business Intelligence

Exemption: Exempt

LOCATION: This is an ONSITE position. Located in Covington, LA.

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 relational databases, and visualization software, cloud environments, and automation tools 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, dashboards, and applications—leveraging data visualization software, workflow automation platforms, cloud services, and modern AI tools.
• 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.