Business Intelligence Developer IV - 1625 Van Ness Avenue

We are so glad you are interested in joining Sutter Health! 

Organization:

CPMC-California Pacific Med Center

Position Overview:

Primarily creates reports using a combination of SQL, Tableau or Crystal Reports. Prepares reporting solutions which are predominantly hospital clinical operations reports. Data often sourced from EPIC Clarity. A combination of adhoc reports, scheduled reports and dynamic dashboards produced. Processes include report requirements gathering, wireframing or prototyping reporting solutions, scheduling and fulfilling work using SCRUM/AGILE methodologies, validating solutions, placing solutions in QA and Production environments, and finally, creating a catalog of reports on SharePoint site or with Collibra. General tools most used include SSMS, Tableau, Crystal Reports, and SAP Business Objects (BI LaunchPad).

Responsible for providing end-to-end reporting and analytical services to internal business partners and leadership. Develops and leads integrated solutions and effectively applies both business knowledge and technical expertise to design, develop, and implement Business Intelligence BI solutions, databases, data warehouses, data marts, interfaces, custom programming, complex reports, and analysis. Provides technical expertise in the architecture and development of integrated data and business process improvement solutions for functional areas through the use of technology in support of Sutter Health.

Incumbent responsible for providing end-to-end reporting and analytical services to internal business partners and leadership. Develops and leads integrated solutions and effectively applies both business knowledge and technical expertise to design, develop, and implement Business Intelligence BI solutions, databases, data warehouses, data marts, interfaces, custom programming, complex reports, and analysis. Provides technical expertise in the architecture and development of integrated data and business process improvement solutions for functional areas through the use of technology in support of Sutter Health.

Experience with SQL, EPIC Clarity, Tableau, and Crystal Reports is highly desired

Utilizes a variety of software tools (e.g. SQL Server Management Studio, SQL Server Integration Services (SSIS), Tableau, Crystal Reports, SAP BI LaunchPad, MS Access, MS Excel).

This position is remote eligible for candidates in CA and TX.

Job Description:

EDUCATION:

• Bachelor's: Applied Statistics, Computer Analytics, Computer, or related field

TYPICAL EXPERIENCE:

• 8 years recent relevant experience:

SKILLS AND KNOWLEDGE:

• In-depth experience in architecting/solution design using technology experience in data management.
• In-depth experience in developing and implementing Business Intelligence solutions (reports, metrics, dashboards, and scorecards) as typically acquired in 6+ years.
• Advanced experience working with databases (e.g. SQL Server) and large datasets is required.
• Experience with (e.g. Finance, HR, Clinical) data is required, preferably in the healthcare industry.
• Experience with Microsoft Office – Word, Excel, PowerPoint, and Access is required.
• Demonstrated experience and/or expertise with SQL Server Reporting Services or other BI applications, and using advanced Excel features and techniques are required.
• Experience working with a variety of information systems and data files, including large and complex files; analyzing file structure, using and creating file layouts, transforming raw data into finished products, e.g. trending and reports is required.
• Problem and issue resolution experience.
• Project Management experience.
• Familiarity with various types of sources of health care information, including coding & billing, reimbursement and finance data files.
• Knowledge in the development of business intelligence and reporting solutions.
• Solid understanding of Data Warehouse methodology, Dimensional modeling in data analysis, including preparing reports, and data presentation.
• Knowledge and experience with VISIO or other flowcharting tools.
• Background in advanced web analytics.
• Advanced skill in the principles of data management including logical and physical data modeling, relational database design, and design and development of System-wide metadata.
• Ability to learn new applications/software systems effectively and efficiently.
• Ability to translate data into Management reports and presentations.
• Ability to take a problem, requirement, or strategy; research solution and take from concept to implementation for desired outcomes.
• Comfortable interacting with individuals/groups at various organizational levels.
• Collaboration and communication skills, both written and verbal.
• The ability to effectively establish priorities and meet deadlines when receiving work from more than one person.
• The incumbent must be able to work with minimal supervision.
• Ability to work with, train, and coach other team members and colleagues.
• Demonstrated leadership skills and the ability to provide constructive feedback to team members to support continuous improvement.
• Organization skills; ability to prioritize multiple activities and objectives in a rapidly changing environment, and deliver quality service.
• Knowledge of health care operations and structure, general requirements in an integrated delivery system, and use of information system applications in a health insurance or health care environment.
• Prior demonstrated success in progressively responsible positions in health care or managed care industry with results-oriented skills.
• Ability to be involved in multiple projects at the same time.
• Ability to lead, communicate and interact with all levels of the organization, including senior management, to provide recommendations and influence decision-making.
• Required skills include ability to build collaborative working relationships with diverse individuals and organizations; analytical and problem solving skills; ability to operate independently, confidentially, and to garner confidence from leadership, entities, vendors and consultant staff.
• Experience in managing multiple, simultaneous, complex projects

Job Shift:

Days

Schedule:

Full Time

Shift Hours:

8

Days of the Week:

Monday - Friday

Weekend Requirements:

As Needed

Benefits:

Yes

Unions:

No

This position is work from home eligible.

Position Status:

Non-Exempt

Weekly Hours:

40

Employee Status:

Regular

Number of Openings:

1

Pay Range is $59.82 to $89.73 / hour

The salary range for this role may vary above or below the posted range as determined by location. This range has not been adjusted for any specific geographic differential applicable by area where the position may be filled. Compensation takes into account several factors including but not limited to a candidate’s experience, education, skills, licensure and certifications, department equity, training and organizational needs. Base pay is just one piece of the total rewards program offered by Sutter Health. Eligible roles also qualify for a comprehensive benefits package.