SR Data Engineer

Summary

Reports to the Manager, Business Intelligence. The Data Engineer delivers insights and supports data driven decision making at Beacon. On a daily basis, the Lead Data Engineer will lead efforts to grow and maintain the business intelligence platform and collaborate with team members on designing and implementing platform enhancements. The Lead Data Engineer will provide technical insight to the organization, mentor and coach data engineers, and use business intelligence tools to build custom queries, integrate new data and data sources, and ensure accurate data. The Lead Data Engineer is expected to work independently and as part of a team.

MISSION, VALUES and SERVICE GOALS

• 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:

• Providing technical guidance and recommendations for organizational data needs.
• Leading data architecture maintenance activities and develops supporting project plans.
• Leading projects to design, build, and maintain ETL feeds for new and existing data sources.
• Ensuring ongoing accuracy of data ETL feeds, monitoring for changes in the source systems which may alter inbound and outbound data.
• Serving as a subject matter expert on data sources, structure, or definitions.
• Building appropriate linkages and relationships between data fields within EDW.
• Creating and maintaining source-of-truth relationship tables for key fields to be referenced throughout the EDW.
• Implementing a standard practices and nomenclature for use within the EDW, in accordance with established Business Intelligence policies.
• Collaborate with members of Business Intelligence, Clinical, Finance, and Information Systems teams to optimize data and information usage.
• Partner with Information Systems teams and other departments in the organization to optimize the data warehouse through hardware or software upgrades or enhancements.
• Structuring data in a way that is easy to understand, query, and display.

Provides information necessary to the financial and clinical success of Beacon organizations by:

• Collecting, organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy.
• Creating 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 accurate reports and dashboards and on a timely basis.
• Designing and building ad-hoc reports that provide actionable and meaningful information.
• Responding to analytics inquiries from various departments of Beacon Health System by identifying data that will provide appropriate and actionable answers.
• Identifying, analyzing, and interpreting trends or patterns in complex data sets and connecting those trends to actionable insights and business needs.
• Communication of strategic priorities to Beacon departments based on insights gleaned from data analytics.

Leads Business Intelligence Team data engineering activities that deliver future state data architecture and develops organizational technical competency:

• Providing technical guidance and advice throughout the organization.
• Mentoring, training, and coaching data engineers and junior team members.
• Leading projects using sound project management methodologies and practices to facilitate activities associated to data platform enhancements and maintenance, including documenting requirements, data integration processes, and data flows.
• Researching and implementing new data management techniques or best practices to ensure accurate data and a sustainable data architecture.
• Developing documentation to support team knowledge base.
• Actively promote and support a culture of data-driven decision making within various departments of Beacon Health System. This may include innovative data visualization and data science methodologies. Completing all other duties as assigned.

ORGANIZATIONAL RESPONSIBILITIES

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

• Requires the ability to lead major projects or multiple smaller projects at the same time.
• Lead initiatives to develop and maintain database platforms with superior data quality.
• Requires ability to lead research, design, and data platform enhancement implementation.
• Requires the ability to provide technical guidance and advice throughout the organization.
• Requires the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail, urgency, and accuracy.
• Requires deep understanding relational database structures and concepts.
• 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 prioritization, organization, and time management.
• Requires mentoring, training, and coaching data engineers and junior team members.
• Demonstrates 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, organizational leaders, and third-party technical resources.

Preferred Skills

• Experience integrating data from multiple source systems into warehouse technologies.
• Experience leading technical projects including: requirements gathering, designing and developing technical solutions, writing and executing test plans, and maintenance activities.
• Experience leading ETL design, development, and support activities.
• Experience writing and supporting Structured Query Language (i.e. SQL) statements.
• Experience learning and using a programming language (i.e. CCL).
• Experience designing and developing data models and data analysis.
• Experience writing and supporting VBA in Excel.
• Hands on experience using database technology such as Dimensional Insight’s Diver, SQL Server, Oracle, or other database and ETL software.
• Experience with financial and patient medical record systems commonly found in a healthcare setting, such as: Cerner, Meditech, McKesson STAR, Allscripts, or Epic.
• Experience working with data in a healthcare setting, including Clinical (Hospital, Ambulatory, EMR, etc.), Claims, and Survey Data (Patient satisfaction, employee satisfaction).
• Knowledge of Cerner CCL a plus.

Working Conditions

• Works in an office, hybrid, or remote work environment.
• May be required to vary hours and days, and work on holidays, weekends, etc., depending upon the needs of the department.

Physical Demands

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