Cedars-Sinai Senior Epic Clarity/ SQL Developer in Los Angeles, California
Come join us and find out why Cedars-Sinai has been ranked as one of the top 100 best places to work in IT as ranked by 2018 Computerworld Magazine and awarded "Most Wired, Level 10" in 2019 by Chime Healthcare's Most Wired!
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 the right people, processes and technologies.
What will you be doing in this role?
Triages intake of data requests and seek understanding of technical requirements.
Uses SQL programming code to develop required reports.
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.
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.
Bachelor's Degree in computer science, data science, or related field.
Master's Degree, preferred.
Epic certification in: Clarity, Reporting Workbench, and/or Radar preferred.
5 years' experience with SQL and experience 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.
Experience in system analysis, user relations, and vendor interactions.
Knowledge of relation database technology and client-server applications.
Demonstrated understanding of healthcare applications as well as the needs and priorities of patient care providers.
Technical proficiency in Reporting Workbench and Radar build.
Able to teach complex Reporting Workbench and Radar build concepts.
Experience in Reporting Workbench and Radar build, preferred.
Experience writing SQL statements and accessing relational database system, preferred.
Experience analyzing basic to moderately complex Clarity report requests, Reporting Workbench and Radar build requests, 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.