Business Intelligence Administrator/Developer/Job Req 537151490

PRINCIPAL RESPONSIBILITIES:

The Business Intelligence Administrator/Developer, reporting to the Senior Director, Analytics, is responsible for supporting and administering the reporting system needs of the Alliance. This position requires an understanding of business intelligence platforms and complex report development. The Business Intelligence Administrator/Developer routinely supports business decisions and operational processes, frequently interacting with analysts within the department, IT, and other primary report users.

Principal responsibilities include:

• Document and communicate best practices to drive consistency among users and improve system/tool performance.
• Design, develop, and deliver Business Objects and Power BI reports and dashboards.
• Perform business analysis and requirement gathering of assigned projects.
• Develop and maintain complex queries and stored procedures from relational databases, large data sets and multiple data sources.
• Perform other duties and special projects as assigned.
• Document report processes/logic.
• Work autonomously and collaboratively with report requestors, providing guidance to define report requirements and validate results.
• Troubleshoot BI platform and reporting system failures and performance issues.
• Design, develop, and deliver Business Objects universes.
• Design, configure, optimize and maintain business intelligence (BI) tools, including but not limited to Business Objects and Power BI.
• Identify areas of improvement, organize and perform upgrades for BI tools.
• Manage user requests for licenses, facilitate onboarding and basic training, and respond to user questions.

ESSENTIAL FUNCTIONS OF THE JOB

• Comply with the organization’s Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls.
• Report writing, data analysis, and procedure development.
• Perform quality process review.
• Administer and maintain analytical reporting tools including Business Objects and Power BI.
• Consult with managers, IT, and employee users.
• Communicate effectively and efficiently internally and externally.
• Manage and prioritze with meeting deliverables and expectations.

PHYSICAL REQUIREMENTS

• Constant and close visual work at desk or computer.
• Frequent use of telephone headset.
• Constant verbal and written communication with staff and other business associates by telephone, correspondence, or in person.
• Frequent walking and standing.
• Frequent lifting of folders and other objects weighing between 0 and 30 lbs.
• Constant sitting and working at desk.
• Constant data entry using keyboard and/or mouse.

Number of Employees Supervised: 0

MINIMUM QUALIFICATIONS:

EDUCATION OR TRAINING EQUIVALENT TO:

• Bachelor’s degree in a computer science, software engineering, or related field preferred.

MINIMUM YEARS OF ADDITIONAL RELATED EXPERIENCE:

• Minimum three years of administration experience with Business Objects product suite.
• Minimum three years of experience in data systems and SQL, preferably in healthcare industry.
• Minimum one year of administration experience with Power BI and/or other BI visualization tool.

SPECIAL QUALIFICATIONS (SKILLS, ABILITIES, LICENSE):

• Excellent written, verbal and interpersonal communication skills, and be able to successfully relate to internal and external customers of all levels.
• Exhibit excellent critical thinking and problem-solving skills.
• Experience in working with relational databases, large data sets and multiple data sources is required.
• Well organized and detail oriented.
• Experience with validating and auditing data.
• Experience with other reporting tools (i.e. SSRS) is preferred.
• Ability to multi-task, effectively manage competing priorities, deliverables, expectations, and ambiguity is essential.
• Knowledge of healthcare principles and data is preferred.
• Solid experience with Business Objects (BO) product suite and Power BI (or other BI visualization tool), including administration, universe (BO) and report development, maintenance and software upgrades, is required.
• Strong SQL/PLSQL, SSIS, SSRS, SPROC, and SQL server database development skills are required.
• Expert level knowledge of writing complex queries and stored procedures is required.

Salary Range: $136,119.77 - $204,179.66 /annually