Understand report requirements and build reports and functions as desired.
With minimal supervision, performs analysis, development, and testing of complex reporting solutions.
Build strong working relationships with users and team members, including Directors and above. Gains trust and respect of key users.
Manage multiple independent complex activities.
Manage tasks, dependencies, and user/team expectations regarding scope and timeline of solution delivery.
Participates in, and effectively contributes to, project working groups with team members, users, analysts, clinicians, and Beaumont leadership.
Independently performs analysis, development, and testing of solutions.
Utilizes depth of reporting and tool specific expertise to recommend leading edge solutions to users that meet their expressed and unexpressed future needs.
Designs and develops complex reporting solutions that enable user functionality with minimal on-going maintenance and post-production incidents.
Provides expertise in understanding and using Beaumont data models and systems, and acts as resource in the interpretation and use of data generated and utilized by users.
Participates in teams to define design and development standards and conduct peer reviews of solution designs.
Troubleshoots incidents surrounding supported solutions.
Tune performance of complex solutions (both queries and database structures).
Organizes and conducts regular project status sessions and design reviews leveraging appropriate project artifacts. Consistently contributes valuable input during design reviews of team member solutions.
Education: BS/BA in Information Technology, Engineering, Mathematics or business-related field or equivalent work experience.
Experience: Four or more years’ experience in either (or both) Business Intelligence or Healthcare technology.
License/Certification: Epic Clarity Data Model certification (preferred)
Knowledge, Skills, and Abilities
Delivers high quality Reporting & Analytics solutions that meet user requirements with minimal on-going maintenance and a low volume of production incidents (production failures, help desk calls, etc.).
Proficient with, and contributes to, best practices and common processes for developing solutions with Beaumont tools (i.e., Crystal Reports, WebI, Qliview, Qliksense etc.) utilized in role.
Troubleshoots and performs root cause analysis of incidents and establishes countermeasures to improve supported applications.
5 years’ experience with SQL in an Oracle and/or SQL Server environment. Proficient with complex SQL (multi joins, subqueries, unions) and creation of database objects (tables, views, materialized views, etc.). Ability to utilize performance tuning utilities (Explain Plans, etc.) to optimize queries.
Complex Report writing & proficient in metadata (universe) creation with Beaumont standard tools.
Recognized expert with one or more reporting/ visualization tool.
Able to work without direct supervision based on general direction provided by a superior, is able to provide guidance to peers, and makes recommendations to supervisors on best path forward. Provides regular updates to supervisor on pending tasks, pain points, and potential roadblocks.
Demonstrated ability for completing multiple complex projects.
Experience working with Crystal Reports, WebI, PL/SQL, DDL, T-SQL, Toad, Epic, Clarity, Compass, Data Modeling required