Senior Epic Report Developer - Remote

Grow your career at Cedars-Sinai!

Cedars-Sinai placed in the top 20 on Newsweek?s "World's Best Smart Hospitals 2024" list, which highlights hospitals that have excelled in the utilization of electronic functionalities, telemedicine, digital imaging, artificial intelligence and robotics.

The organization?s Healthtech excellence was acknowledged again, this time by the esteemed "CHIME Digital Health Most Wired" recognition program. Cedars-Sinai was assigned a Level 10-the most prestigious level of certification-among more than 300 surveyed healthcare organizations. Cedars-Sinai netted high scores across multiple verticals and particularly excelled in areas of infrastructure, interoperability, and population health innovation.

Why work here?

Beyond an outstanding benefit package and competitive salaries, we take pride in hiring the best, most committed employees. Our staff reflects the culturally and ethnically diverse community we serve. They are proof of our dedication to creating a multifaceted, inclusive environment that fuels innovation and the gold standard of patient care we strive for.

What will you be doing in this role:

The Senior Epic Report Developer works with users throughout the organization in gathering requirements, designing, and developing organization-wide reports. Create and reports, ad hoc requests, dashboards, and deliverables.  Designs, tests, and implements reports and data extracts from enterprise database sources. Writes structured Query Language (SQL) queries against a complex data models. Translate requests into the programming specifications as needed. Uses enterprise reporting tool across the organization. Provides ongoing support for production reporting environments. Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis. Under minimal to no supervision, independently responsible for more complex projects. Considered highly skilled and proficient in the discipline of extracting and presenting data through technical methods SQL, views, stored procedures, BO universes, etc. Conducts complex work important to the organization. Provide consultation to users and lead cross-functional teams to address data and analytic issues.

• Triages intake of data requests and seek understanding of technical requirements.
• Uses SQL programming code to develop required reports.
• Responsible for the development and delivery lifecycle during the following phases:
• Requirement Assessment: Works with enterprise data intelligence analysts to analyze and understand business requirements.
• Development: Based on requirements, develops functionality by following internal development standards. Technical solution to include detailed design documentation, code, configuration, and other supporting technical documents. Incorporates end-user requests and requirements to develop enterprise reporting solutions.
• Testing: Performs unit, regression, connectivity and full end-to-end integration tests, when it applies; Supports quality insurance effort to gain user acceptance.
• Delivery: Works collaboratively with inter-departmental and cross-departmental resources to migrate new or enhanced functionality from test to production. Provides effective communication across the team as appropriate. Follows change control standards and processes for release to production.
• Facilitates design and technical meetings. Provides technical documentation to internal business and design teams.
• Writes and optimizes moderately complex to advanced queries.
• Deploys reports electronically using the appropriate enterprise reporting environment and strategy.
• Manages the process of moving reports into a production mode.
• Facilities the validation and testing of new or revised reports. Works with user to verify results and content, develops errors or exception reports when applicable and receives official user sign off on completed work.
• Tracks, documents, and facilitates resolution of all reporting technical issues.  Keeps problem resolution log and proactively manages growth and utilization of analytic reporting products.
• Maintains technical and end-user documentation. Utilizes a wide-range of business intelligence tools SAS, Crystal Reports, Microsoft Access and Business Objects. 
• Maintains the business objects "universe" that supports report writing in that tool.
• Primary/Secondary responsibility for maintenance of all on-line production reports and associated user accounts used throughout the organization.  Includes scheduling of reports, monitoring report updates from source files and notification of report availability and refresh schedule.  User account management includes creation of new accounts and deletion and revision to existing accounts.
• Follows team standards, development methodology and processes for specification, implementation, testing, change management, distribution, and documentation of reports.

*Approved Remote States: Arizona, California, Colorado, Florida, Georgia, Minnesota, Nevada, Oregon, Texas*

Experience Requirements:

Five (5) plus years of experience with SQL and experience with a range of query tools such as Oracle, SAS, Crystal Reports, Business Objects, Microsoft SQL, Tableau, etc.

Experience with patient care-oriented databases, hospital-based administrative database applications and data warehousing technology.

Experience in system analysis, user relations, and vendor interactions.

Knowledge of relation database technology and client-server applications.

Educational/Certification Requirements:

Bachelor's degree in Computer Science, Information Technology, Healthcare, or related field.

Epic Certification preferred.

#LI-Remote