Business Intelligence Developer 4

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

Organization:

SHSO-Sutter Health System Office-Valley

Position Overview:

Senior level developer on our technical analytics team. Develops end to end solutions in the Microsoft stack, creating pipelines in python and SSIS, modeling data according to Kimball methodologies, generating complex TSQL queries, producing paginated reports, creating highly interactive Power BI dashboards with an App Like experience, building complex SSAS Tabular Models/Semantic Models with advanced Dax code.

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.

**This is a highly technical position applying in-depth knowledge and experience of one or more areas of the Microsoft Data stack.**

Job Description:

EDUCATION:
Equivalent experience will be accepted in lieu of the required degree or diploma.

• Bachelor's in 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 t