Department Information
The Polis Center is a unit in the Luddy School of Informatics, Computing and Engineering at 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-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 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.
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
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 consideredSKILLSRequired
- 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
Advertised Salary
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
Posting Disclaimer
Equal Employment Opportunity
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.