Data Engineer at Beacon Health System – Granger, Indiana

Reports to the Manager, Business Intelligence. The Data Engineer delivers insights and supports data driven decision making at Beacon. On a daily basis, the Data Engineer will assist in maintaining the existing business intelligence platform and collaborate with team members on designing and implementing platform enhancements. The Data Engineer will use the business intelligence tools to build custom queries, integrate new data and data sources, and ensure accurate data. The Data Engineer is expected to work independently and as part of a team.

• MISSION: We deliver outstanding care, inspire health, and connect with heart.
• VALUES: Trust. Respect. Integrity. Compassion.
• SERVICE GOALS: Personally connect. Keep everyone informed. Be on their team.

Supports the development and maintenance of a system-wide data analytics platform by:

• Designing, building, and maintaining the integrity and efficiency of ETL feeds for new and existing data sources.
• Structuring data in a way that is easy to understand, query, and display.
• Building appropriate linkages, relationships, and calculations between data fields within EDW.
• Serving as a subject matter expert on data sources, structure, and definitions.
• Collaborate with end users to field data requests to integrate data into the EDW and build dashboards to support their needs.
• Troubleshoots issues related to EDW, dashboards, and reports
• Partner with internal and external teams to enhance the data warehouse through hardware and software upgrades and expansions.

Provides information necessary to the support the strategy and decision making of Beacon organizations by:

• Collecting, organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy.
• Collaborate with the Analysts to develop tool for analyses of strategic planning and market research data to provide insight to business development and growth opportunities for Beacon Health System.
• Developing, designing, and automating regular reports accurately and on a timely basis.
• Designing and building ad-hoc reports that provide actionable and meaningful information.
• Identifying, analyzing, and interpreting trends or patterns in complex data sets and connecting those trends to actionable insights and business needs.

Assists the Business Intelligence Team in planning for the evolution of Beacon's data management initiative by:

• Providing input into strategic direction and decisions for the Business Intelligence Department researching new data management techniques or best practices
• Documenting data integration processes and data flows.
• Documenting metadata regarding data source, field type, definition, etc. for each field and table created.
• Actively promoting and supporting a culture of data-driven decision making within various departments of Beacon Health System. This may include innovative data visualization and data science methodologies.
• Remaining attentive to the potential process improvement opportunities and implementing solutions to improve the efficiency of department and data processes.
• Completing all other duties as assigned.

Associate complies with the following organizational requirements:

• Attends and participates in department meetings and is accountable for all information shared.
• Completes mandatory education, annual competencies and department specific education within established timeframes.
• Completes annual employee health requirements within established timeframes.
• Maintains license/certification, registration in good standing throughout fiscal year.
• Direct patient care providers are required to maintain current BCLS (CPR) and other certifications as required by position/department.
• Consistently utilizes appropriate universal precautions, protective equipment, and ergonomic techniques to protect patient and self.
• Adheres to regulatory agency requirements, survey process and compliance.
• Complies with established organization and department policies.
• Available to work overtime in addition to working additional or other shifts and schedules when required.

Commitment to Beacon's six-point Operating System, referred to as The Beacon Way:

• Leverage innovation everywhere.
• Cultivate human talent.
• Embrace performance improvement.
• Build greatness through accountability.
• Use information to improve and advance.
• Communicate clearly and continuously.

Education and Experience

• The knowledge, skills and abilities as indicated below are normally acquired through the successful completion of a Bachelor's Degree in Business, Data Analytics, Engineering, Information Systems, Informatics, or a related field. Experience in application support, data management, programming, or database management, preferably in a healthcare setting, is preferred.

Knowledge & Skills

• Demonstrates flexibility, determination, and perseverance through challenging or ambiguous work.
• Demonstrates well-developed communication skills necessary to effectively communicate both verbally and in writing, and work within the Business Intelligence Team, organization, and third-party technical contacts.
• Requires the ability to troubleshoot issues and propose solutions.
• Requires understanding relational database structures and concepts.
• Requires ability to research, design, and implement data platform enhancements.
• Requires the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail, urgency, and accuracy.
• Requires basic knowledge of the healthcare business needs, including a basic knowledge and understanding of the healthcare revenue cycle and healthcare delivery systems.
• Requires strong skills in organization and time management.
• Preferred experience includes supporting ETL and databases, Excel VBA, SQL, Cerner CCL, or other programming or analytical software
• Preferred knowledge of designing and developing data models, using database technology such as Dimensional Insight's Diver, SQL Server, or Oracle.
• Experience with financial and patient medical record systems commonly found in a healthcare setting, such as Cerner is a plus.

Working Conditions

• Works in a hybrid office environment with remote flexibility
• May be occasionally required to work outside of normal business hours according to the needs of the department.

Physical Demands

• Requires the physical ability and stamina to perform the essential functions of the position.