Job detailsSalary$63,000 – $73,000 a yearJob TypeFull-timeLocation425 University Blvd, Indianapolis, IN 46202+ Leaflet | OpenStreetMap contributorsBenefitsPulled from the full job descriptionAD&D insuranceDental insuranceDisability insuranceEmployee assistance programHealth insuranceHealth savings accountShow 4 more benefitsFull Job Description

Department

POLIS (IN-POLI-IUINA)

Department Information

The Polis Center is a unit in the Luddy School of Informatics, Computing and Engineering at IUPUIworks 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-totarget 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 staffs 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.
Performs data management tasks, including experienced data modeling, conversion, de-duplication, migration, and identification and repair of data quality issues.

General Responsibilities

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 of 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)

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 Universitys Notice of Non-Discrimination here which includes contact information.

Campus Safety and Security

The Annual Security and Fire Safety Report, containing policy statements, crime and fire statistics for all Indiana University campuses, is available online. You may also request a physical copy by emailing IU Public Safety at iups@iu.edu or by visiting IUPD.

Contact Us

Request Support Telephone: 812-856-1234

Health insuranceHiring InsightsJob activityPosted 15 days ago

Tagged as: EDF