Back to jobs

Data Engineer

WellPower provides you with the support you need to help you develop a career in helping others succeed. We innovate, adapt, and leverage the diverse perspectives of the people on our team and the people we serve in everything we do.

WellPower values and is strengthened by diversity. We are committed to ending bias and discrimination in our community and ensuring equity within all aspects of our organization. We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment, transfer, or promotion opportunities without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

The Data Engineer is responsible for maintaining and expanding our data applications and data infrastructure, primarily with Azure Data Factory, Azure SQL, Azure Logic Applications, PowerBI Data Gateways and on-premise SQL Servers. This role reports to the Software Engineering Manager.

Please note that this position is only open to candidates currently residing in Colorado.

Learn more about WellPower:

Pay Range & Benefits:

  • $90,000 - $105,000/year                

WellPower is committed to fair and equitable hiring with salaries based on relevant factors, such as work experience, education, and certification/licensure (rather than wage history). Toward the principle of equal pay for equal work, we post and hire within defined hiring salary ranges.  We ask all applicants to carefully review the hiring salary range for each posted job opportunity, as we will not hire outside the predetermined range.

All full-time, benefits eligible employees will be eligible for WellPower’s benefits plan. For a full description of benefit offerings, please visit: https://wellpower.org/workplace-of-choice/.

ESSENTIAL JOB FUNCTIONS:

  1. On a daily basis
    • Maintain and monitor the existing data warehouse architected based on broad relational tables and simple joins. Entire system is SQL Server 2022 centric using stored procedures, SQL jobs and Integration Server (SSIS).
    • Maintain and enhance the new Enterprise Data Warehouse architected based on Data Vault concepts. This is a hybrid system leveraging both Azure and on-premise SQL Server 2022 tooling.
    • Maintain and monitor the existing ETL processes based on SQL Jobs running SSIS, Python, Powershell and C# tasks.
    • Maintain and enhance the new ETL processes based in Azure using Data Factory (ADF) calling Logic Apps, Function Apps and on-premise code as needed.
  2. Data Architecture Development – Design, build, and maintain organization’s data architectures. This involves creating blueprints for data management systems that are scalable and efficient. Anticipate future data needs and ensure that the systems can grow and adapt as requirements evolve.
  3. Data Pipeline Construction and Maintenance – Constructs and maintain data pipelines, for automating the flow of data from various sources. This involves coding, testing, and continuously optimizing these pipelines to ensure smooth, error-free data flow. Within these pipelines, implement ETL (Extract, Transform, Load) processes to facilitate the preparation and transformation of data for analytical or operational uses.
  4. Database Management and Optimization –Responsible for the setup, management, and fine-tuning of databases. Ensure that databases are structured effectively, run smoothly, and are optimized for quick queries. This includes both SQLand NoSQL databases, depending on the organization’s needs.
  5. Analytics Support including for Machine Learning –Build and maintain the infrastructure required for existing and new Machine Learning and Advanced Analytics efforts. Prepare and provide the necessary data and contribute to model development and deployment.
  6. Other cross functional tasks
    • Closely support the Business Intelligence Team creation of reports.
    • Develop new database objects, processes, packages, exports, and reports that meet provided specifications.
    • Monitor and improve performance of key reports and processes.
    • Perform quality assurance checks and design automated tests to ensure high levels of product quality and reliability.
    • Administer the data and reporting servers; installing updates, configuration, error resolution, server security and monitoring server health and reliability.
    • Actively contribute to successful team project accountability using Agile/Scrum methodologies.
    • Provide data and reports required for enterprise applications, self-service reporting and analytics for users throughout the organization and our external partners.
    • Create and maintain documentation for all projects.
    • Consult with other staff members regarding database design and development, application integration, and other data and reporting infrastructure needs.
    • Support other software projects with code reviews, development

EDUCATION: Minimum of High School Diploma required, Bachelor’s degree highly preferred in Computer Science, Analytics, Information Systems, or another related field. Some college or technical school education and experience equivalent accepted with certifications preferred.

EXPERIENCE: Minimum of four years’ experience providing meaningful SQL development and data engineering work. Experience within a healthcare environment highly valued.

SKILLS AND COMPETENCIES:

Minimum:

  • Microsoft SQL Server development, including SSIS package development, SQL Jobs, and schema or table design. Or other ETL tooling experience
  • Database administration including security and maintenance best practices
  • Write creative, sophisticated, and maintainable SQL
  • Ability to effectively communicate orally and in writing with both technical and non-technical staff
  • Ability to organize and prioritize work, handle multiple assignments, and meet deadlines
  • Experience writing complex SQL stored procedures
  • Experience with some type of programming or scripting language

Highly Desired:

  • Experience with Azure Data Factory creating new ETL processes in ADF.
  • Experience with other Azure tools such as Logic Apps, Key Vault, Function Apps, Storage Accounts, DevOps, and Azure SQL.
  • Interest and commitment to good development practices, including source control, test driven development, continuous integration and deployment
  • Experience with one or more of the other languages and technologies used at WellPower (e.g., Java, C#, Python, R, REST APIs) highly desirable for our SSIS job scripts.
  • Power BI experience creating and maintaining dashboards
  • Experience with R, machine learning and other advanced analytics tools

MACHINES AND EQUIPMENT TO BE USED: Linux, PC Computer, MS Office software, MS SQL Server Management Studio, Azure, Tableau

WORKING CONDITIONS: May require occasional evening or weekend hours. This hybrid position is based in Denver, Colorado and requires regular on-site time.

 

#LI-TM1

 

 

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf


Education

Select...
Select...
Select...

Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Driving Positions: What driver's license class do you hold?
Select...
Select...
Select...
Select...

I certify that all of the information I have provided in this application is true and complete, without omissions of any kind. I understand and agree that if at any time, it is discovered that any information provided by me in this application is false, misleading or incomplete, this application will be void, and WellPower, may, in its sole discretion and without liability to me immediately terminate my employment.

I authorize all employers, educational institutions and persons named in this application to give any information regarding my previous employment, my character, and my qualifications to MHCD or its authorized representatives. I hereby release these employers, educational institutions and persons from all liability to me for providing this information.

I understand and agree that this application is not a contract nor an offer by WellPower to form a contract. I acknowledge and agree if hired, my employment with WellPower will be “at will,” meaning that either I or WellPower may terminate the employment relationship at any time for any reason or no reason, with or without cause, with or without notice, and with WellPower’s only obligation to me being to pay salary or wages owed for work performed prior to termination.

Except as stated in the following paragraph, I understand and agree that no manager or employee of WellPower has authority to enter into any agreement for employment for a definite period of time or to make any agreement with me that would alter the employment “at will” relationship. Therefore, I agree that it would be unreasonable for me to believe that any statements from WellPower, whether oral or written (including any policies or procedures that I may be provided), create a contract between WellPower and me or alter the employment at-will relationship.

I understand and agree that if hired, my status as an at-will employee could be changed only if (1) enter into a written agreement with WellPower entitled “(Contract of Employment for (my name)” and signed by WellPower’s Chief Executive Officer, Human Resources Director and me; or (2) I become a member of the Collective Bargaining Unit under the Collective Bargaining Agreement between WellPower and Service Employees International Union, Local 105 AFL-CIO, and the employment at-will relationship is altered by that Collective Bargaining Agreement.

7.701.8 PERJURY STATEMENT—APPLICATION FORMS FOR EMPLOYMENT WITH A CHLD CARE PROVIDER [EFF. 9/3/99]

Any applicant who knowingly or willfully makes a false statement of any material fact of thing in the application is guilty of perjury in the second degree as defined in Section 18-8-503, C.R.S., and upon conviction thereof, shall be punished accordingly.

Select...
Select...

Self-ID Questions

We recognize that people’s identities are complex. The Equal Opportunity Employment Office options do not usually capture how people identify.  To work toward a better solution, we are providing these Self-ID options in the Voluntary Demographics section below. You may choose: "I prefer not to answer" any or all of the self-ID questions. 

At WellPower we embrace diversity, equity, inclusion, & belonging and your self-ID will only be used for operational purposes, in aggregate form and has no impact on your application. 

We know that these lists are still incomplete and we encourage you to use the self-describe boxes if you want to identify in a way that is not represented on these lists.

Select...
Select...
Select...
Select...
Select...