Job Location: Evanston, IL
Data Engineer, University Enrollment
Job ID: 42496
Location: Evanston, Illinois
Department: Univ Enrollment Analytics
Salary/Grade: ITS/79
Job Summary:
As part of the team in University Enrollment Analytics, the Data Engineer (DE) will provide both analytical and technical support to the division. The DE is responsible for managing and organizing data; this includes data collection, transformation, and ingestion efforts for University Enrollment systems. The Data Engineer establishes ETL procedures to support projects across the division, identifying and evaluating data sources for quality, reliability, and appropriateness, and migrating and integrating datasets as needed for use and analysis. The DE will assist in the design of data collection and analysis efforts with a focus on preventing redundancies, improving quality, and developing systems to support data collection, ingestion, and analysis. In addition, the DE designs and implements technical solutions ensuring that business needs and requirements are met, as well as provides estimation for assigned projects and tasks. Finally, the DE will assist in development, configuration and ongoing maintenance and support of the systems, (primarily Technolutions Slate and Perceptive Content) used in University Enrollment.
Specific Responsibilities:
Strategic Planning
- Understands user objectives and goals and can translate those goals and objectives into actionable plans.
- Performs data management tasks, including organizing, 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 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.
- Researches and stays up-to-date with data engineering best practices and approaches.
- Participates in the development of new goals and strategies based on interactions with users.
- Partners with Student Enterprise Systems team on interface development.
Administration
- Development, testing, and integration of ETL routines using ETL tools and external programming/scripting languages as necessary.
- Automating analysis tasks using R, Python, Orange, and/or SSIS.
- Creating and maintaining technical documentation for source-to-target mapping as well as the data dictionary where needed.
- Assisting in production support by resolving source data issues and refining transformation rules to align with department objectives.
- Ensure accuracy & integrity of data and data processes.
- Evaluates feature/upgrade/change requests and recommends action.
- Identifies database and software performance issues and executes adjustments.
Development
- Prepare data for predictive and prescriptive modeling.
- Use data to discover tasks that can be automated.
- Develop reports in tools such as R, Tableau, and other reporting software.
- Researches and develops new algorithms and statistical techniques designed for analyzing data, based on department needs.
- Opens tickets with vendors as needed.
Other duties as assigned.
Minimum Qualifications:
- Successful completion of a full 4-year course of study in an accredited college or university leading to a bachelor’s or higher degree in a major such as data science, computer science, information technology, or related field; OR appropriate combination of education and experience.
- 2 years of data management, engineering, or related experience.
Minimum Competencies: (Skills, knowledge, and abilities)
- Excellent verbal and written communication skills.
- Strong analytical, troubleshooting and problem-solving experience.
- Demonstrated experience with analyzing problems and offering solutions.
- Demonstrated ability to learn about new information technology tools as required.
- Ability to effectively communicate analytic/technical concepts to end users, business stakeholders and management both verbally and in writing.
- Ability to independently seek out and utilize information resources, such as books, web sites, other electronic resources, and professional colleagues to assess and solve problems.
- Demonstrated time management and priority setting skills.
- Demonstrated a high commitment to quality and level of accuracy, even under pressure.
- Possess a high level of detail, is extremely thorough and dependable.
- Highly motivated, demonstrates initiative and able to work independently and collaboratively as part of a team.
Preferred Qualifications:
- Strong qualitative and quantitative data manipulation skills.
- Experience with Technolutions Slate CRM.
- Experience with Perceptive Content or other ECM product.
- Experience with PeopleSoft Campus Solutions.
- Experience with R, Python, Tableau.
- Knowledge of relational databases such as SQL Server, Oracle, Access, etc.
Preferred Competencies: (Skills, knowledge, and abilities)
- Experience in higher education environment, particularly in the enrollment area
Please apply online at https://careers.northwestern.edu/psp/hr857prd_er/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=1&JobOpeningId=42496&PostingSeq=1
Northwestern requires all staff and faculty to be vaccinated against COVID-19, subject to limited exceptions. For more information, please visit our COVID-19 and Campus Updates website.
The Northwestern campus sits on the traditional homelands of the people of the Council of Three Fires, the Ojibwe, Potawatomi, and Odawa as well as the Menominee, Miami and Ho-Chunk nations. We acknowledge and honor the original people of the land upon which Northwestern University stands, and the Native people who remain on this land today.
Northwestern University is an Equal Opportunity, Affirmative Action Employer of all protected classes, including veterans and individuals with disabilities. Women, racial and ethnic minorities, individuals with disabilities, and veterans are encouraged to apply. Click for information on EEO is the Law.
Job Types: Full-time, Contract
Pay: $83,704.00 – $190,963.00 per year
Benefits:
- Health insurance
Schedule:
- Monday to Friday
Work Location: One location
Submit CV To All Data Science Job Consultants Across India For Free