Data Development Consultant

TransUnion LLC; New Jersey; Hybrid; USD 72,000 - 105,000; Full time

Benefits offered by this job

Medical, dental & vision coverage

HSA/FSA options

Company-paid life & AD&D

Disability insurance

Parental leave

401(k) with employer match

Employee Stock Purchase Plan (ESPP)

Tuition reimbursement

Commuter benefits

Paid holidays & volunteer time off

Job summary

TransUnion LLC is seeking a Data Development Consultant to support Marketing Services data pipelines and backend systems. You will fix code issues, analyze data-related problems, and develop data pipelines while coordinating with Architecture, Consulting, Product, and Engineering teams.

The role is hybrid, requiring in-person presence at an office location for at least two days per week and regular virtual work. Strong SQL, Hadoop, and Python/Java skills are essential.

Qualifications

• Bachelor's Degree with 5+ years IT experience in Big Data.
• Excellent SQL skills and in-depth understanding of relational databases.
• Experience on distributed systems like Hadoop with hands-on experience in HDFS, MapReduce, Google Cloud Platform.

Responsibilities

• Manages the day-to-day activities to facilitate and deliver team projects.
• Play a key role in end-to-end data onboarding and creating a data pipeline for the end application.
• In-depth analysis of source data for mapping and business rules setup.
• Develop, code & implement the data pipeline.
• Ensure data onboarding at client level is successful.
• Collaborate across Product Managers, Solution Architects, Data Modelers, Consultancy Services to align goals.
• Develop knowledge of in-house tools to suggest improvements.

Skills

SQL

UNIX environments

Python

Java

Hadoop

MapReduce

Google Cloud Platform

HDFS

Hive

OLAP/OLTP/ETL

Education

Bachelor's Degree in IT/related field

Tools

Big Data frameworks (Hadoop)

BigQuery

Hive

Job description

Team Overview

The Data Development Consultant will act as a key resource of the Data Operations and Engineering team and is responsible for supporting Marketing Services products like MTA and MMM. They will be responsible for day to day support activities like fixing code issues within the big data pipeline and backend, analyzing data related issues, take up development task for data pipeline. This role will partner and collaborate with stakeholders across solution Architecture, Consulting Services, Product and Engineering teams. You will report to the Director of Data Development.This is a hybrid position and involves regular performance of job responsibilities virtually as well as in-person at an assigned TU office location for a minimum of two days a week.

Role Overview and Core Responsibilities

• Manages the day-to-day activities and works on assigned tasks in order to facilitate and contribute to the successful completion and delivery of team projects and initiatives.
• Play a key role in end to end data onboarding and in creating a data pipeline for the end application.
• In depth analysis of source data to provide insights for data mapping & business rules setup.
• Develop, code & implement the data pipeline.
• Make sure data onboarding at a individual client level is done successfully.
• Works cross functionally with Product Managers, Solution Architect, Data Modeler, Consultancy Services to align and achieve team goals successfully.
• Develop deep knowledge of in-house tools and applications to suggest improvements and assist Advisory Services and Solution Architects.
• Determines how best to accomplish objectives, which are established at a higher level, working under limited supervision.
• Exercises independent judgment to solve problems.

Required Knowledge and Experiences

• Excellent SQL skills and in-depth understanding of relational databases.
• Experience on distributed systems frameworks like Hadoop including hands on experience on HDFS, MapReduce, Google Cloud Platform etc.
• Bachelor's Degree, with 5+ years related IT experience in Big Data.
• Good knowledge of UNIX environments and exposure to shell scripting.
• Working knowledge of large scale multi-node clusters with technologies like HDFS/ Big Query, Hive etc.
• Knowledge of database design principles like OLAP, OLTP and ETL.
• Experience in Python and Java will be an advantage.

Benefits that support every part of your life:

At TransUnion, we design benefits to help youfeel well, do well, and plan well-from day one.

For Your Health: Enjoyday-one eligibilityfor medical, dental, and vision coverage, plus supplemental plan options. Spousal, domestic partner, and other eligible dependent coverage is available on select plans. Choose taxadvantagedHSAandFSAaccounts to make everyday care more affordable.

For Your Protection: We've got your back withcompanypaid basic life and AD&D, optionalvoluntary life and AD&Dfor you and your family, andshort and longterm disability. You can also opt into alegal plan,pet insurance, andtravel accident coverage.

For Your Family: Fromadoption assistance and fertility planning coveragetocaregiver support, we're here for every chapter. AccessDependent Care FSA for possibility of an employer match, a complimentaryCare@Workmembership, andup to 12 weeks of paid parental leavewith eligibility for a thoughtful, gradual return.

For Your Future: Build toward what's next with our401(k) with employer matchandEmployee Stock Purchase Plan (ESPP). Tapfinancial wellness resources,career coaching, and optionallongterm care insuranceto plan confidently.

For You: Grow and recharge withtuition reimbursement,flexible time off for exempt employees or paid time off for nonexempt employees, up to 12 paid holidays per year, commuter benefits, employeediscounts,charitable gift matching, andpaid volunteer time off, plus corporate volunteer events that make it easy to give back.

For Your Wellness: Access24/7 supportincluding professionaltherapy,coaching, and emotional wellbeing programs alongside guided meditation and resources that supportphysical, mental, social, and financial wellness.

We are committed to being a place where diversity is not only present, it is embraced. As an equal opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability status, veteran status, genetic information, marital status, citizenship status, sexual orientation, gender identity or any other characteristic protected by law. Additionally, in accordance with Section 503 of the Rehabilitation Act of 1973 and the Vietnam Era Veterans' Readjustment Assistance Act of 1974, TransUnion takes affirmative action to employ and advance in employment qualified individuals with a disability and protected veterans in all levels of employment and develops annual affirmative action plans. Components of TransUnion's affirmative action program for individuals with disabilities and protected veterans are available for review to any associate or applicant for employment upon request by contacting [e-mail].

Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers, the San Francisco Fair Chance Ordinance, Fair Chance Initiative for Hiring Ordinance, and the California Fair Chance Act.

TransUnion complies with all applicable immigration laws and regulations. The Company does not presently provide employer support or sponsorship for an immigration-related employment benefit for this position. Applicants must be authorized to work in the United States on a full-time basis without the need for employer support or sponsorship now or in the future.

Adherence to Company policies, sound judgment and trustworthiness, working safely, communicating respectfully, and safeguarding business operations, confidential and proprietary information, and the Company's reputation are also essential expectations of this position.

Pay Scale Information:

The U.S. base salary range for this position is $72,300.00 - $105,000.00 annually. *The salary range for this position reflects a reasonable estimate of the range of compensation for this job. At TransUnion, actual compensation is based on careful consideration of additional factors such as (but not limited to) an individual's education, training, work experience, job-related skill set, location, and industry knowledge, as well as the scope and responsibilities of the position and market considerations. Regular, fulltime non-sales positions may be eligible to participate in TransUnion's annual bonus plan. Certain positions may be also eligible for long-term incentives and other payments based on applicable company guidance and plan documents.

TransUnion Overview:

At TransUnion, we encourage and are committed to creating a real, positive impact and shared sense of purpose within our Workforce for Good, which empowers our people to grow, innovate and contribute to a better future for our communities and customers. We strive to build an environment where our associates are in the driver’s seat of their professional development- while having access to help along the way. We recognize that success comes when our associates thrive both professionally and personally; that's why we prioritize work/life flexibility and offer resources for our teams across the globe to collaborate and drive excellence.

Be a part of our Workforce for Good - you'll work with great people, pioneering products and cutting-edge technology.

TransUnion's Internal Job Title:

Consultant, Data Development

Company:

TransUnion LLC