Job Application for Data Engineer at WellPower

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:

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.
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.
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.
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.
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.
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

First Name

Last Name

Phone

Location (City)

Resume/CV*

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

Cover Letter

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

School

Select...

Degree

Select...

Discipline

Select...

Start date year

End date year

LinkedIn Profile

Website

Your Current Address:

I have reviewed the hiring salary range for this position I am applying for, and would be willing to accept a salary offer within this posted range.

Select...

If you have a preferred first name, please provide it.

Is any additional information related to a change of names, use of a surname, or nickname necessary to enable us to check your work record?

Select...

If yes, please explain?

Are you 18 years of age or older?

Select...

Have you ever been employed at the Mental Health Center of Denver or by WellPower?

Select...

If yes, when?

Can you provide proof of eligibility to work in the United States?

Select...

Did you graduate from high school or hold a GED?

Select...

Provide your high school's Name and Address:

List the name and addresses for all Colleges and/or Universities you have attended:

List any languages that you are fluent in other than English:

List any business machines or equipment which you have experience operating:

Do you have any other skills that you wish to mention (typing speed, MS Office, software, other special skills or training.)

Do you hold a Professional License?

Select...

If yes, list the license name and license number:

List any professional certifications you hold:

Driving Positions: Do you have a valid Colorado driver's license?

Select...

Driving Positions: Provide your Driver's License Number:

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

Class R

Class A

Class B

Class C

Driving Positions: What state issued your driver's license?

Select...

Driving Positions: Have you ever had your driver's license suspended or revoked in the last 3 years?

Select...

Driving Positions: If yes, give details:

Have you ever been fired from a job or asked to resign?

Select...

If yes, please explain:

Applicant's Certification & Acknowledgement

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.

To promote equity in hiring practices, WellPower posts a set hiring salary range for every position. I understand the hiring range for this role and would be willing to accept an offer within that range.

Select...

Please read carefully. I understand that this role is only open to candidates CURRENTLY living in Colorado and confirm that I CURRENTLY live in Colorado.

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.

Gender and Sexual Orientation: Which of the following best describes you? If you identify as more than one gender you may select multiple options. If your gender is not listed, please use the self-describe box.

Select...

Do you identify as transgender?

Select...

Do you consider yourself a member of the Lesbian, Gay, Bisexual, Transgender, Queer, Intersex, Asexual, and/or Two-Spirit, Plus (LGBTQIA2S+) community?

Select...

Race and Ethnicity: Which of the following best describes you? Select as many options as apply or use the self-describe box if needed.

Select...

Describe your disability status? This could include physical, auditory, visual, cognitive and developmental disabilities as well as mental health disorders, learning disabilities, health conditions, and others that may be considered “invisible"

Select...

Data Engineer

Apply for this job

Self-ID Questions