"Alerted.org

You’ll want to join Billings Clinic for our outstanding quality of care, exciting environment, interesting cases from a vast geography, advanced technology and educational opportunities. We are in the top 1% of hospitals internationally for receiving Magnet® Recognition consecutively since 2006.

And you’ll want to stay at Billings Clinic for the amazing teamwork, caring atmosphere, and a culture that values kindness, safety and courage. This is an incredible place to learn and grow. Billings, Montana, is a friendly, college community in the Rocky Mountains with great schools and abundant family activities. Amazing outdoor recreation is just minutes from home. Four seasons of sunshine!

You can make a difference here.

About Us

Billings Clinic is a community-owned, not-for-profit, Physician-led health system based in Billings with more than 4,700 employees, including over 550 physicians and non-physician providers. Our integrated organization consists of a multi-specialty group practice and a 304-bed hospital.Learn more (https://www.billingsclinic.com/about-us/) about Billings Clinic (our organization, history, mission, leadership and regional locations) and how we are recognized nationally for our exceptional quality.

Your Benefits

We provide a comprehensive and competitive benefits package to all full- and part-time employees (minimum of 20 hours/week), including Medical, Dental, Vision, 403(b) Retirement Plan with employer matching, Defined Contribution Pension Plan, Paid Time Off, employee wellness program, and much more.Click here (https://www.billingsclinic.com/careers/employee-benefits/) for more information ordownload the Employee Benefits Guide (https://ncstoragemlbillings.blob.core.windows.net/public/2021%20Billings%20Clinic%20Staff%20Benefits%20Guide.pdf) .

Magnet: Commitment to Nursing Excellence

Billings Clinic is proud to be recognized for nursing excellence as a Magnet®-designated organization, joining only 97 other organizations worldwide that have achieved this honor four times. The re-designation process happens every four years. Click here (https://www.billingsclinic.com/campaign-landing-pages/magnet/) to learn more!

Pre-Employment Requirements

All new employees must complete several pre-employment requirements prior to starting. Click here (https://billingsclinic.csod.com/ats/careersite/search.aspx?site=15&c=billingsclinic) to learn more!

Principal Data Engineer (.5 FTE)

PMO / OPERATIONS - 100.8732 (BILLINGS CLINIC N 27TH ST BUILDING)

req9790

Shift: Day

Employment Status: Part-Time (.5 - .74)

Hours per Pay Period: 0.50 = 40 hours every two weeks (Exempt)

Starting Wage DOE: $93,828 - $117,270

The Data Engineer acts as subject matter experts of the data repositories available within the organization by obtaining an in-depth understanding of each source system. These engineers are primarily focused on the creation, management, and availability of data pipelines to support structured analytics.

Essential Job Functions

• Develops data pipelines using extract, transform, and load (ETL/ELT) processing routines for enterprise level data warehousing initiatives.

• Writes advanced queries using data scripting language including T-SQL, CCL, Python, Scala.

• Create and maintain data structures and data models to support data at all stages of the data pipeline development lifecycle.

• Maintain, tune, and scale big data infrastructure platforms (Snowflake, AWS, Azure) to appropriately handle workloads.

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, data acquisition, data enrichment, re-designing infrastructure for greater scalability, etc.

• Perform database performance tuning methods to ensure uptime and data refresh rate SLAs are met.

• Participate in data engineering team code reviews and offer recommendations regarding data architecture.

• Supports department BI Analysts in translating business requirements into Azure DevOps development tasks to properly track and implement solutions that meet the needs of stakeholders by way of agile development lifecycles.

• Align with Billings Clinic data engineering development standards to deliver uniform results providing a consistent and supportable view of data across the organization.

• Duties may require 24 hour, seven days per week on-call responsibility for project support or for escalated support issues.

Supports and models behaviors consistent with Billings Clinic’s mission, vision, values, code of business conduct and service expectations. Meets all mandatory organizational and departmental requirements. Maintains competency in all organizational, departmental and outside agency standards as it relates to the environment, employee, patient safety or job performance.

Performs all other duties as assigned or as needed to meet the needs of the department/organization.

Department or Level Specific Duties and Responsibilities

• The principal data engineer is a supporting lead technical role on the development of data structures, processes and algorithms using advanced technologies to support Billings Clinic data initiatives.

• Provides insight and guidance on industry best practices, development standards, and leading technologies.

• Assists on defining the sprint backlog, assigning of tasks to engineering team, and leads development meetings as required.

• Drives end-to-end development effort for on-time delivery of high-quality solutions that conform to requirements and comply with all applicable standards.

• Guide our efforts in all areas of database design, performance, and reliability.

• Investigate and troubleshoot complicated database applications and stability issues.

• Ensure SQL databases are operational and provide valid and relevant data.

• Actively participate and/or lead code reviews to ensure adherence to data engineering standards.

• Integrate new products and software packages and ensure data produced is accurate.

• Optimize code for maximum scalability and maintainability.

• Incorporate unit testing and regression testing to ensure defect-free builds and releases.

Minimum Qualifications

Education

• B.S or equivalent degree in Computer Science, Information Systems, or related field

Experience

• Minimum of 8 years related work experience

• Minimum of 3 years data architecture experience, including data ingestion, processing, storage and reporting in a big data environment.

• Demonstrated ability in mentoring other data engineers on best practices and assisting on setting architectural direction.

• Demonstrated ability in taking lead on large scale data engineering initiatives.

• Advanced expertise in DBMS platforms (e.g., Oracle, MSSQL, Snowflake etc.)

• Advanced proficiency in more than one data programming languages (e.g., T-SQL, CCL, Python, Scala, etc.)

• Advanced expertise in large-scale data warehouse implementation, ETL/ELT development, data modeling, and database tuning.

• Demonstrated strength and proficiency in database utilities and IDEs (e.g., SSMS, AQT, Visual Studio, etc.)

• Advanced experience with coordinating code deployments from development, test, and production environments.

• Advanced experience of source/version control processes in tools such as (Azure DevOps, Github, etc.)

• Demonstrated strength in software development best practices and methodologies for Agile product delivery

• Strong verbal and written communication skills, ability to perform under pressure, attention to detail and appreciation for rigorous release management process is important.

• 3 years’ experience in Vendor management

Or an equivalent combination of education and experience relating to the above tasks, knowledge, skills and abilities will be considered. Employees that require a licensed or certification must be properly licensed/certified and the licensure/certification must be in good standing.

Billings Clinic is Montana’s largest health system serving Montana, Wyoming and the western Dakotas. A not-for-profit organization led by a physician CEO, the health system is governed by a board of community members, nurses and physicians. Billings Clinic includes an integrated multi-specialty group practice, tertiary care hospital and trauma center, based in Billings, Montana. Learn more atwww.billingsclinic.com/aboutus (https://www.billingsclinic.com/about-us/)

Billings Clinic is committed to being an inclusive and welcoming employer, that strives to be kind, safe, and courageous in all we do. As an equal opportunity employer, our policies and processes are designed to achieve fair and equitable treatment of all employees and job applicants. All employees and job applicants will be provided the same treatment in all aspects of the employment relationship, regardless of race, color, religion, sex, gender identity, sexual orientation, pregnancy, marital status, national origin, age, genetic information, military status, and/or disability. To ensure we provide an accessible candidate experience for prospective employees, please let us know if you need any accommodations during the recruitment process.