BI Analyst: SQL, Data Modeling & Reporting

Builds and supports business intelligence and analytics initiatives to enhance departmental and organizational effectiveness, efficiency and safety. Works closely with other Information Technology staff to plan and implement strategies. Writes, clarifies, and interprets specifications for reports and translates specifications into report. Investigates, analyzes, and evaluates customer desires to asses reporting needs. Designs, documents, develops, tests, implements, and maintains user reports. Recommends guidelines, standards, and methodology changes as needed.

• A bachelor’s degree in computer science or a related field.
• At least 2 years of experience in one or more of the listed roles, or four years of commensurate experience.
• Experience with and knowledge of Crystal Report Development, SQL script development, and an operational understanding of the technologies that support a hospital system.
• Preferred: skills in Epic Clarity report development.
• Intermediate to advanced skills required in the functional areas above.
• Advanced SQL and experience with a variety of relational databases.
• Working experience with an object‑oriented language:
  Python, Java, C++, etc.
• 2+ years of work experience with a BI tool (Qlik preferred).
• Strong organizational and multitasking skills with ability to balance multiple priorities.
• Ability to build strong cross‑functional relationships with other departments and work collaboratively.

• Conduct analysis of departmental, organizational, and individual information needs relative to specific assignments.
• Analyze system performance, data integrity, and security requirements during development and resolution work.
• Document all phases of project and product life cycles.
• Provide technical assistance in resolving developed tools issues, remaining technically current in assigned areas.
• Establish and continue development toward personal career goals.
• Develop or participate in development of reports, queries, scripts, and system testing strategies.
• Support and educate others regarding applications and tools developed, as well as third‑party applications assigned.
• Develop SQL and other report solutions.
• Participate in support of applications that require scripting methodologies.
• Assist in any other activity as assigned.

• Experience in Business Intelligence tools.
• Expertise in database design and administration.
• Strong knowledge of analytics and data modeling.
• Proficiency in SQL and data mining techniques.

• Excellent problem‑solving and analytical skills.
• Strong attention to detail.
• Excellent communication and interpersonal skills.
• Ability to work independently and in a team environment.
• Strong customer service orientation.