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 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.
- 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.
-
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
Preferred
- Bachelor’s degree in computer science, information science, or a related field
WORK EXPERIENCE
Required
- 2 years of data management, engineering, or a 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
-
Demonstrated 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
- 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 deduplication 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.
Work Location
The Campus of IUPUI, Indianapolis, Indiana
Advertised Salary:
$63,000 – $75,000
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.
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.