Data Integration Consultants

TransUnion; United States; Remote; USD 139,000; Full time

Job summary

An established industry player is seeking Data Integration Consultants to enhance data quality and integration processes. This role offers a unique opportunity to work remotely while contributing to significant projects that support insurance underwriting. You will leverage your expertise in data transformation, SQL, and various data engineering tools to resolve complex data issues and ensure high-quality datasets. Join a forward-thinking company that values diversity and offers comprehensive benefits, including flexible time off and health plans, while you make a meaningful impact in the field of data analytics.

Benefits

Flexible Time Off

Paid Holidays

Health Plans

Mental Health Support

Disability Benefits

Parental Leave

Tuition Reimbursement

Employee Stock Purchase Plan

401(k)

Commuter Benefits

Qualifications

• Master’s degree plus 2 years or Bachelor’s degree plus 5 years in Data Analytics.
• Experience in data transformation and SQL required.

Responsibilities

• Analyze raw data and define integration processes as a subject matter expert.
• Collaborate on large-scale projects to maintain data integrity.

Skills

Data Transformation

Data Mining

SQL

ETL Processes

Data Quality Resolution

Large Dataset Analysis

Visualization

Reporting

Education

Master’s Degree in Computer Science

Bachelor’s Degree in Computer Science

Tools

Power BI

Tableau

Linux/Unix

AbInitio

Dremio

Informatica ETL

Filezilla

AWS

Job description

Job Description

Data Integration Consultants are needed for various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL). The role involves identifying and defining data integration processes and quality improvements as a subject matter expert on public record data used to support insurance underwriting. Responsibilities include analyzing raw data, developing transformation logic, testing on newly acquired data sources, and collaborating with functional groups on large-scale projects. The goal is to maintain clean, consistent, and complete data, recognize relational impacts, and mitigate integrity issues.

The role also involves contributing to documentation of data definitions, business rules, data standardization best practices, and data quality requirements. You will resolve data quality or loading issues for large, complex datasets that impact customer transactions, prioritize issue severity, and resolve issues efficiently to minimize customer impact.

Technical Environment

• Data transformation, mining, reconciliation, reporting, maintenance, and visualization
• Data engineering, SQL queries (aggregates, conditional statements, subqueries)
• Analysis of large datasets, writing test plans, ETL processes
• Data quality/loading issue resolution
• Tools: Power BI, Tableau, Linux/Unix, AbInitio, Dremio, Informatica ETL, Filezilla, AWS

Job Requirements

• Master’s degree in Computer Science, Information Systems, or related field plus 2 years of experience in Data Analytics; or Bachelor’s degree plus 5 years of experience
• Required skills include data transformation, mining, reconciliation, reporting, maintenance, visualization, engineering, SQL, large dataset analysis, test plan development, ETL, data quality resolution, Power BI, Tableau, Linux/Unix, AbInitio, Dremio, Informatica, Filezilla, AWS

This position offers 100% telecommuting flexibility.

Benefits & Compensation

TransUnion provides comprehensive benefits including flexible time off, paid holidays, health plans, mental health support, disability benefits, parental leave, adoption assistance, fertility coverage, legal benefits, long-term care insurance, commuter benefits, tuition reimbursement, employee stock purchase plan, 401(k), and Employee Resource Groups. The U.S. base salary is $138,715 annually. Eligibility for bonuses, incentives, and other payments varies by position.

Equal Opportunity & Additional Information

TransUnion is committed to diversity and equal opportunity employment. Qualified applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, marital status, citizenship, sexual orientation, gender identity, or other protected characteristics. Applicants with arrest or conviction records will be considered per applicable laws. Adherence to company policies, sound judgment, trustworthiness, safety, respectful communication, and safeguarding confidential information are essential expectations.