What will you be doing in this role:
The Senior 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.
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.
Req ID : 3810
Working Title : Senior Report Developer - Remote
Department : EIS Report Development
Business Entity : Cedars-Sinai Medical Center
Job Category : Information Technology
Job Specialty : Bus Intelligence/Reporting
Overtime Status : EXEMPT
Primary Shift : Day
Shift Duration : 8 hour
Base Pay : $103,833.60 - $166,129.60