12 days old

Data Engineer | Beacon Health System | Business Intelligence

Beacon Health Systems
South Bend, IN 46601
  • Job Code


Reports to the Manager, Business Intelligence. The Data Engineer will design, implement and maintain data warehousing and data management solutions to support business reporting and analytical requirements. This includes building source system data ETL processes, verifying data accuracy, and designing complex interactions between data fields within the data management solution. The Data Engineer will develop data set processes for data modeling, mining, and production, and create custom software components and analytics applications. Additionally, the Data Engineer designs, develops, and automates reports that communicate performance on value-based reimbursement contracts, strategic planning/market analysis, financial analysis, and a variety of other business needs. The Data Engineer is expected to anticipate business needs by designing and building custom queries and front-end reports that provide actionable insight to end-users.


Mission: To enhance the physical, mental and emotional well-being of the communities we serve as the community's provider of outstanding quality, superior value and comprehensive health care services.

Vision: Our vision is to achieve:

Innovative health care and well-being services of the highest quality at the greatest value

Easy access and convenience

Outstanding patient experiences

Ongoing education involving physicians, patients and the community


Education and Experience

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

Knowledge & Skills

  • Requires in-depth technical expertise regarding data models, data analysis and design, master data management, metadata management, data warehousing, business intelligence, and data quality improvement.
  • Requires proficiency in the use of Structured Query Languages (SQL) for building, maintaining and extracting data from relational databases.
  • Understands relational database structure and is able to design and maintain robust custom database schemas.
  • Requires ability to research and implement best-practice database management techniques.
  • 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.
  • Demonstrates well-developed communication skills necessary to effectively communicate both verbally and in writing, and work within the Business Intelligence Team, and with outside technical contacts.

Preferred Skills

  • Experience with financial and patient medical record systems commonly found in a healthcare setting, such as: Cerner, Meditech, McKesson STAR, Allscripts, or Epic.
  • Experience supporting backend databases and ETL that deliver front end user reports and dashboards.
  • Hands on experience using Dimensional Insight's Diver, SQL Server, Oracle, Talend, or other database and ETL software.
  • Knowledge of Cerner CCL a plus.

Working Conditions

  • Works in an office 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.


The below statements are intended to describe the essential job functions and level of work performed by individuals assigned to this classification. They are not to be construed as an exhaustive list of all job duties performed by the personnel occupying this position.

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

  • Designing, building and maintaining 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 data
  • 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 nomenclature for use within the EDW, in accordance with established Business Intelligence policies.
  • Serving as a subject matter expert on data sources, structure, or definitions.
  • Collaborate with members of Business Intelligence, Finance, and Information Systems teams to optimize data and information usage.
  • Partner with Information Systems teams 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.

2. 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.
  • Creating analyses of population health and value-based reimbursement contract performance to determine future contracting opportunities and opportunities for improvement in cost or quality performance.
  • Developing, designing, and automating regular reports accurately 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.
  • Interpreting reports or contractual language to analyze the impact on Beacon's overall operations and financials.
  • Communication of strategic priorities to Beacon departments based on insights gleaned from data analytics.

3. 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. Completing all other duties as assigned.

Posted: 2019-10-31 Expires: 2019-11-29
Sponsored by:
Farm Credit Services of America Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Engineer | Beacon Health System | Business Intelligence

Beacon Health Systems
South Bend, IN 46601

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast