IT ETL Developer, Sr.



Job Details

IT ETL Developer, Sr.
Employer

Hennepin County

Salary

$70,821.92 - $109,963.36 Annually

Location

Downtown Minneapolis

Job Type

Full-time

Job Number

17HH498JRF068

Department

Hennepin Health

Opening Date

09/29/2017

Description

Hennepin County Hennepin Health is seeking an IT Extract, Transform and Load (ETL) Senior Developer to build an Enterprise Data Warehouse (EDW) allowing reports, analytics and applications to function and scale with the needs of the business. This position requires experience with data modeling and data management development in various platforms and tools, and will be adept at translating business requirements into data stores that can be used to support production reports, analytics and applications, plus have a strong understanding of data strategy and development, and handling administrator functions. This position will play a key role on the Data Strategy team and will consistently deliver high quality deliverables with careful attention to detail.

This posting will remain open until filled, and may be used to fill future vacancies.


Hennepin Health is a not-for-profit, state certified health maintenance organization (HMO) and an enterprise initiative of Hennepin County. Hennepin Health serves the county's diverse safety net population and publicly funded health care recipients. Its mission is to help people improve their health through personal service and its vision is to become the leader in eliminating health care disparities. Because of Hennepin Health's affiliation with Hennepin County, services for its members are enhanced through a close linkage with social services and other programs offered by the county.

Hennepin County offers an impressive benefits package that includes health, dental, vision, life, and short/long-term disability insurance, 11 paid holidays per year in addition to paid time off, paid parental leave, tuition reimbursement, a defined benefit pension plan (PERA), retirement savings programs, trade time for fitness, and many more.


The primary duties and responsibilities of this position includes:
 
  • Partner with other competency leads/developers and support project planning, technical design, development and solution deployment functions.
  • Write code to perform business logic/rules on source/target data to create expected output per business requirement documents.  
  • Develop automated routines capable of replacing existing manual data update processes.
  • Develop and document best practices for ETL related operations and processes. 
  • Build Visio diagrams for system and data process flows. 
  • Analyze data in source/target to look for data quality problems and write code to fix data quality issues; work with QA staff to develop, implement, and document tests plans for ETL and data integration processes. 
  • Identify opportunities in business processes, system capabilities and delivery methodologies for continuous improvement as applicable; define and implement relational structures, dimensional data marts/models and cubes for the needs of analytics, reporting and application usage. 
  • Monitor scheduled ETL jobs; help the production support team to resolve ETL batch failures.
  • Provide guidance in the creation, design and maintenance of the enterprise data warehouse.
  • Build employee knowledge and skills in specific areas of expertise.
     

Best Qualified Candidates will have:

  • One of the following:
    • A bachelor's degree or higher in computer science, management information systems (MIS), or closely related field, and five years or more at a technical IT level position.
    • An associate's degree in computer science, MIS, or closely related field, and seven years or more at a technical IT level position.
    • An approved certification in an IT program and seven years or more at a technical IT level position.
    • Nine or more years at a technical IT level position.
  • Five or more years of strong SQL development experience on data warehouse projects.
  • Five or more years of ETL experience working with Microsoft SSIS creating complex packages and expressions.
  • Four or more years of strong data warehouse data validation testing experience.
  • Three or more years as a strong technical writer developing standard operating procedures, solution design documents, data mapping documents, data models and technical diagrams.
  • Preferred experience:
    • In the healthcare industry or medical claims experience.
    • With business intelligence and reporting tools: Microsoft SSRS, Crystal Reports and Webby tools.
    • As a technical lead for a major technology implementation.
    • With Tivoli, Tumbleweed and SFTP.
 
Candidates must have a right to work in the U.S. that is not based solely on possession of a student visa or a visa sponsored by an employer.

Invitations to interview will be based upon an assessment of education and experience. Applications will be forwarded to the hiring supervisor on an on-going basis. Posting will remain open until filled. Final candidates will be required to complete a background check.

Hennepin County envisions an organization where our commitment to diversity is fundamental in providing excellent service to our community.

Visit our Benefits site for more information.

01
If you would like to include a cover letter, you may copy or type it here.
02
In which of the following field(s) have you earned a certificate/degree? Check all that apply.
  • Computer science
  • Information technology
  • Management information systems
  • Another related degree
  • Other
  • None of the above
03
What is the highest level of certificate/degree you have earned in the field(s) you selected above?
  • Technical certificate
  • Associate's degree
  • Bachelor's degree
  • Master's degree or higher
  • None of the above
04
List your relevant completed education making reference to school(s) attended, area(s) of study, certificate(s) and/or degree(s) earned. If you do not have any completed education, type "None" in the space provided.
05
How many full-time equivalent years of experience do you have at a technical IT level position?
  • I do not have this experience
  • Less than 1 year
  • 1 year or more, but less than 2 years
  • 2 years or more, but less than 3 years
  • 3 years or more, but less than 4 years
  • 4 years or more, but less than 5 years
  • 5 years or more, but less than 6 years
  • 6 years or more, but less than 7 years
  • 7 years or more, but less than 8 years
  • 8 years or more, but less than 9 years
  • 9 years or more
06
Describe your technical IT experience, referencing jobs listed in your application/resume. If you do not have this experience, type "None" in the space provided.
07
How many years of experience do you have with SQL development on data warehouse projects?
  • I do not have this experience
  • Less than 1 year
  • 1 year or more, but less than 2 years
  • 2 years or more, but less than 3 years
  • 3 years or more, but less than 4 years
  • 4 years or more, but less than 5 years
  • 5 years or more
08
Briefly describe your SQL development experience on data warehouse projects, referencing jobs listed in your application/resume. If you do not have this experience, type "None" in the space provided.
09
How many years of experience do you have working directly with Microsoft SSIS creating complex packages and expressions?
  • I do not have this experience
  • Less than 1 year
  • 1 year or more, but less than 2 years
  • 2 years or more, but less than 3 years
  • 3 years or more, but less than 4 years
  • 4 years or more, but less than 5 years
  • 5 years or more
10
Briefly describe your experience working directly with Microsoft SSIS creating complex packages and expressions, referencing jobs listed in your application/resume. If you do not have this experience, type "None" in the space provided.
11
How many years or experience do you have with data warehouse data validation testing?
  • I do not have this experience
  • Less than 1 year
  • 1 year or more, but less than 2 years
  • 2 years or more, but less than 3 years
  • 3 years or more, but less than 4 years
  • 4 years or more, but less than 5 years
  • 5 years or more
12
Briefly describe your experience with data warehouse data validation testing, referencing jobs listed in your application/resume. If you do not have this experience, type "None" in the space provided.
13
How many years of experience do you have with developing standard operating procedures, solution design documents, data mapping documents and technical diagrams?
  • I do not have this experience
  • Less than 1 year
  • 1 year or more, but less than 2 years
  • 2 years or more, but less than 3 years
  • 3 years or more, but less than 4 years
  • 4 years or more, but less than 5 years
  • 5 years or more
14
Briefly describe your experience with developing standard operating procedures, solution design documents, data mapping documents and technical diagrams, referencing jobs listed in your application/resume. If you do not have this experience, type "None" in the space provided.
15
Please choose the one recruitment source that best describes how you first learned about this job opening. Please review all possible choices before making your selection. Your response to this question helps us evaluate the effectiveness of our recruitment methods.
  • College or university (job board, career services, or instructor)
  • Community or nonprofit organization (counselor, job board, etc.)
  • Hennepin County employee or recruiter
  • Hennepin County job notification emails
  • Indeed.com
  • Job fair or networking event
  • LinkedIn
  • Print advertisement (flyer, postcard, billboard, transit ad, etc.)
  • Professional association (job board or email)
  • Radio
  • Social media (Twitter, Facebook, Glassdoor, etc.)
  • www.hennepin.jobs
  • Other
16
For the recruitment source selected above, please provide the specific name of the person, website or media source.

* Required Question

Employer
Hennepin County
Department
Hennepin Health
Address
1104, Applewood acres

Scranton, Pennsylvania, 18411

Apply

OnlineApplication

Warning! You are using Internet Explorer 8. Some features of the Online Application are not fully supported in this version. Please upgrade to a later version of Internet Explorer for optimal performance.

Loading ...