Cedars-Sinai Senior Epic Clarity/ SQL Developer in Los Angeles, California
Grow your career at Cedars-Sinai!
The Enterprise Information Services (EIS) team at Cedars-Sinai understands that true clinical transformation and the optimization of a clinical information systems implementation is fueled through the alignment of people, processes and technologies.
Why work here?
Beyond an outstanding benefit package, 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 standard of patient care we strive for.
What will I be doing in this role:
The Senior Report Developer works with users throughout the organization in collecting 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 sophisticated 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. Considered highly skilled and proficient in the subject area of extracting and presenting data through technical methods SQL, views, stored procedures, BO universes, etc. Conducts sophisticated work important to the organization.
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 closely with inter-departmental and cross-departmental resources to migrate new or improved 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.
Deploys reports electronically using the appropriate enterprise reporting environment and strategy.
Executes 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.
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.
5 years' experience with SQL and solid understanding with a range of query tools such as Oracle, SAS, Crystal Reports, Business Objects, Microsoft SQL, Tableau, etc. Hands on experience performing reporting analysis and developing custom reports.
Experience with patient care-oriented databases, hospital-based administrative database applications and data warehousing technology, system analysis, user relations, and vendor interactions. Knowledge of relation database technology and client-server applications.
Experience analyzing basic to moderately sophisticated Clarity report requests, Reporting Workbench and Radar build requests.
Experience writing SQL statements and accessing relational database system.
Experience in Reporting Workbench and Radar build.
Demonstrated understanding of healthcare applications as well as the needs and priorities of patient care providers.
Able to teach sophisticated Reporting Workbench and Radar build concepts.
Bachelor's degree in computer science, data science, or related field, required.
Master's degree in computer science, data science, or quantitative related field (preferred).
Epic Certification required (Epic Clarity Data Model, Reporting Workbench, and/or Radar certificate preferred).
Cedars-Sinai is an EEO employer. Cedars-Sinai does not unlawfully discriminate on the basis of the race, religion, color, national origin, citizenship, ancestry, physical or mental disability, legally protected medical condition (cancer-related or genetic characteristics or any genetic information), marital status, sex, gender, sexual orientation, gender identity, gender expression, pregnancy, age (40 or older), military and/or veteran status or any other basis protected by federal or state law.