Data Intelligence Developer I

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.

As a Data Intelligence Developer I at Cedars-Sinai Medical Center you will work 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.

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.