11.07.2022

ETL Data Engineer

The Polis Center–a unit in the IU School of Informatics and Computing-IUPUI—works with community partners in Indiana and beyond to develop innovative place-based policies and practices for healthier and more resilient communities. It supports disaster mitigation, population health management, community development, and quality-of-life efforts.

Polis experts use geospatial technologies to integrate, manage, and visualize the rapidly growing information on the places where we live and work. The center helps organizations understand gaps in service, trends, assets, and ways to build capacity. Its four areas of emphasis tackle specific problems that impact daily lives and influence actions and developments in each other.

The Polis Center is nationally recognized as a dynamic urban-centered, learning environment with highly professional staff who excel in partnerships, real-world application, and winning solutions for the communities. From inception, The Polis Center has been guided by core values that include: making a difference, collaboration, developing creative solutions to real-world problems, accountability, integrity, respect, and stewardship.

Job Summary

The ETL Data Engineer supports data collection, transformation, and loading efforts across the center, including data deriving from and transferred to statistical as well as geographic information system workflows. This involves establishing Extract, Transform, and Load (ETL) workflows to support projects across the center; identifying and evaluating data sources for quality, reliability, and appropriateness; and migrating and integrating datasets as needed for analysis.

Department Specific Responsibilities:

  • Develops, tests, and integrates ETL routines (including those for geospatial data) using ETL tools and external programming/scripting languages as necessary.
  • Automates GIS analysis tasks using Python, ModelBuilder, FME, T-SQL and/or SSIS.
  • Creates and maintains the organization data dictionary as well as technical documentation for source-to target mapping.
  • Assists in production support by resolving source data issues and refining transformation rules to align with center objectives.
  • Ensures accuracy and integrity of data through analysis of application coding deliverables, ensuring adequate documentation and problem resolution.
  • Reviews and approves analysis and translation of functional specifications and change requests into technical specifications.
  • Oversees project document management of ETL technical system specifications, processes flows, unit tests and results.
  • Ensures staff’s support of all ETL jobs for schedules and maintains compliance in development for effective project life cycle.
  • Manages internal resources to ensure that individuals assigned to projects have the specific skills necessary to run established workflows.
  • Assists in the design of data collection and analysis efforts with a focus on preventing redundancies, improving quality, and developing systems to support longitudinal data collection and analysis.

General Responsibilities:

  • Performs data management tasks, including experienced data modeling, conversion, de-duplication, migration, and identification and repair of data quality issues.
  • Designs, develops, and implements custom data systems and reconciliation tools, processes, rules, solutions etc. to validate data, match/merge, and upload batch lists.
  • Creates and tunes complex stored procedures and queries for data management and extraction.
  • Designs and builds out technical software mechanisms to accommodate multiple integrations accurately based on complex rules and custom solutions.
  • Ensures documentation and security standards/protocols are recognized and followed.
  • Provides experienced troubleshooting and problem analysis/resolution for data related issues; performs experienced scripting and modifications of application and products for corrective action.
  • Researches and stays up-to-date with data engineering best practices and approaches; stays abreast of latest security threats and risks to proactively address potential exposures.

Qualifications

EDUCATION

Required

  • Bachelor’s degree preferably in computer science, information science, or related field

WORK EXPERIENCE

Required

  • 2 years data management, engineering, or related experience

Preferred

  • 5 years of experience with Extract, Transform, and Load (ETL) development or data modeling

Combinations of related education and experience may be considered

SKILLS

Required

  • Proficient communication skills
  • Maintains a high degree of professionalism
  • Demonstrates time management and priority setting skills
  • Demonstrates a high commitment to quality
  • Possesses flexibility to work in a fast paced, dynamic environment
  • Seeks to acquire knowledge in area of specialty
  • Highly thorough and dependable
  • Demonstrates a high level of accuracy, even under pressure

Preferred

  • Strong quantitative and geospatial data manipulation skills
  • Advanced SQL coding skills for data transformations, profiling, and query tasks
  • Advanced working knowledge of Esri ArcGIS software
  • Advanced working knowledge of at least 2 of the following: Python, ModelBuilder, FME
  • Experience with SQL Server and SSIS (SQL Server Integration Services)
  • Data reduplication strategies and implementation skills
  • Experience with data warehousing
  • In-depth knowledge of relational databases such as SQL Server, Oracle, Access, and PostgreSQL
  • Ability to work independently and collaboratively as part of a project team and to demonstrate initiative
  • Experience with database management and working with large quantitative and geospatial datasets from disparate local, state, and federal sources, including census, American Community Survey, and other community-level data sets
  • Ability to manage and prioritize multiple assignments in a fast-paced environment
  • Ability to manage relationships with Polis staff members
  • Shows good judgment, and seeks out support or guidance where appropriate

Working Conditions / Demands

This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation.

Advertised Salary

The salary range for this position is $63,000 – $73,000.

Benefits Overview

For full-time staff employees, Indiana University offers a wide array of benefits including:

  • Multiple plan options for medical insurance
  • Dental insurance
  • Health Savings Account with generous IU contribution
  • Life insurance, LTD, and AD&D options
  • Base retirement plan contribution from IU, subject to vesting
  • Additional supplemental retirement plan options
  • Tuition benefit for IU classes
  • 10 paid holidays per year
  • Generous Paid Time Off
  • Paid Parental Leave
  • Employee Assistance Program (EAP)

Part-time staff employees are eligible for the following benefits:

  • Base retirement plan contribution from IU, subject to vesting
  • Paid Time Off
  • Employee Assistance Program (EAP)

Learn more about our benefits by reviewing our online Benefits Brochure.

Job Classification

Career Level: Career

FLSA: Exempt

Job Function: Information Technology

Job Family: Data Analysis & Engineering

Click here to learn more about Indiana University’s Job Framework.

Posting Disclaimer

Due to the COVID-19 pandemic, there may be differences in the working conditions as advertised in our standard job postings (e.g., the ability to travel from one campus to another, etc.).  If you are invited for an interview, please discuss your questions or concerns regarding the working conditions at that time.

This posting is scheduled to close at 11:59 pm EST on the advertised Close Date. This posting may be closed at any time at the discretion of the University, but will remain open for a minimum of 5 business days. To guarantee full consideration, please submit your application within 5 business days of the Posted Date.

If you wish to include a cover letter, you may include it with your resume when uploading attachments.

New employees will be provided with information regarding Indiana University’s COVID-19 vaccine policy, which includes the opportunity to request an exemption. To learn more, view our COVID-19 vaccine information page.

Equal Employment Opportunity

Indiana University is an equal employment and affirmative action employer and a provider of ADA services. All qualified applicants will receive consideration for employment based on individual qualifications. Indiana University prohibits discrimination based on age, ethnicity, color, race, religion, sex, sexual orientation, gender identity or expression, genetic information, marital status, national origin, disability status or protected veteran status. Indiana University does not discriminate on the basis of sex in its educational programs and activities, including employment and admission, as required by Title IX. Questions or complaints regarding Title IX may be referred to the U.S. Department of Education Office for Civil Rights or the university Title IX Coordinator. See Indiana University’s Notice of Non-Discrimination here which includes contact information.

APPLY HERE