University Hospitals

The Report Developer II is a self-motivated highly technical individual who works with customers and peers to design, develop, modify and test reports that meet the customers’ needs.. The Report Developer II maintains a thorough understanding of all major data sources internal to the organization.. Develop requirements and specifications in coordination with Database Administration team and UH Architects for data marts and data warehouses to support clinical and business analytics.. 3+ years report development and analytics experience using Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) Required and. Experience pulling data from many different types of databases for analysis including Microsoft SQL Server, Oracle, Sybase, and Microsoft Access is desired.

report developer

Description Position Summary The Report Developer II is a self-motivated highly technical individual who works with customers and peers to design, develop, modify and test reports that meet the customers’ needs. This role requires a solid understanding of complex large scale data models for healthcare clinical and business systems and the underlying associated processes. The Report Developer II maintains a thorough understanding of all major data sources internal to the organization. Essential Functions <ul><li>Develop requirements and specifications in coordination with Database Administration team and UH Architects for data marts and data warehouses to support clinical and business analytics. Gather appropriate specifications for data collection and transformation requirements and build report prototypes rapidly and accurately.</li><li>Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources throughout the organization to support ad hoc reporting.</li><li>Designs, develops and supports “self-service” reporting options (i.e building tabular data models).</li><li>Create functional and technical documentation including "as-built" documents, dashboard design specifications, operating manuals, release notes and security requirements for reports created and maintained. Update documentation on an annual basis or when changes occur.</li><li>Writes stored procedures and indexes, and completes code reviews in conjunction with DBA and/or development team and provides guidance to reporting team members on their code development.</li><li>Perform quality assurance testing of reports and dashboards, and facilitate user acceptance testing (UAT) sessions. Ensure quality of the reports prior to releasing to production.</li><li>Provides technical support in retrieving data from a variety of database types and languages utilizing T-SQL as may be required.</li><li>Perform quality assurance testing of reports and facilitates user acceptance testing (UAT). Ensure quality of the reports prior to releasing to production. Develops and maintains documentation templates and standards for documentation of data extraction and output specifications, reports and other requirements.</li><li>Proactively identifies and addresses scalability and performance bottlenecks to support data volumes.</li><li>Where appropriate, evaluate and recommend new tools in clinical intelligence, reporting, and analysis. </li></ul>Required For All Jobs <ul><li>Performs other duties as assigned.</li><li>Complies with all policies and standards.</li><li>For specific duties and responsibilities, refer to documentation provided by the department during orientation.</li><li>Must abide by all requirements to safely and securely maintain Protected Health Information (PHI) for our patients. Annual training, the UH Code of Conduct and UH policies and procedures are in place to address appropriate use of PHI in the workplace. </li></ul>Qualifications Qualifications Education <ul><li>High School Equivalent / GED . Required and</li><li>Bachelor’s Degree in Computer Science, Computer Engineering, Business Management, Mathematics or related field Preferred </li></ul>Work Experience <ul><li>3+ years report development and analytics experience using Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) Required and</li><li>2+ years experience in IT Healthcare Preferred and</li><li>Epic Certifications strongly preferred</li><ul><li>Caboodle Data Model</li><li>Clarity Data Model</li><li>Clinical Data Model or Rev Cycle Data Model</li><li>Cogito</li></ul><li>Experience with data cube development and reporting Required and</li><li>Experience with Microsoft SSIS Required and</li><li>Experience pulling data from many different types of databases for analysis including Microsoft SQL Server, Oracle, Sybase, and Microsoft Access is desired. Preferred </li></ul>Knowledge, Skills, & Abilities <ul><li>Knowledge and understanding of standardized Data Warehousing Concepts. Required</li><li>Thorough understanding of stored procedures, T-SQL, functions, and SQL Queries. Required</li><li>Must demonstrate ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports. Required</li><li>Must work at a very high level of accuracy and have a broad knowledge of technical workings of database structure and reporting protocols. Required</li><li>Knowledge of programming languages MS SQL,Net Framework and other related systems. Required</li><li>Strong written and verbal communication skills are. Required</li><li>Must have strong analytical skills with an ability to organize and communicate thoughts clearly. Required </li></ul>Physical Demands <ul><li>Standing Occasionally</li><li>Walking Occasionally</li><li>Sitting Constantly</li><li>Lifting Rarely 20 lbs</li><li>Carrying Rarely 20 lbs</li><li>Pushing Rarely 20 lbs</li><li>Pulling Rarely 20 lbs</li><li>Climbing Rarely 20 lbs</li><li>Balancing Rarely</li><li>Stooping Rarely</li><li>Kneeling Rarely</li><li>Crouching Rarely</li><li>Crawling Rarely</li><li>Reaching Rarely</li><li>Handling Occasionally</li><li>Grasping Occasionally</li><li>Feeling Rarely</li><li>Talking Constantly</li><li>Hearing Constantly</li><li>Repetitive Motions Frequently</li><li>Eye/Hand/Foot Coordination Frequently</li></ul>

START NEW SEARCH