Consultant

Socket.dev; City of Niagara Falls (NY); Hybrid; USD 72,000 - 105,000; Full time

Benefits offered by this job

Health coverage

401(k) with match

Employee stock purchase plan

Job summary

TransUnion is seeking a Data Development Consultant to support Marketing Services products and manage data onboarding and pipeline development. The role blends backend data work with cross-functional collaboration across solution architecture, product, and engineering teams.

The position is hybrid, with in-person work at a TU office location for a minimum of two days per week. Candidates will leverage SQL, Big Data tools, and scripting skills to fix issues and deliver data solutions.

Qualifications

• 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.
• 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.
• Knowledge of database design principles like OLAP, OLTP and ETL.
• Experience in Python and Java will be an advantage.

Responsibilities

• Manage day-to-day activities and contribute to project delivery.
• Play a key role in end-to-end data onboarding and create a data pipeline for the end application.
• Analyze source data to provide insights for data mapping and business rules.
• Develop, code and implement the data pipeline.
• Ensure data onboarding at individual client level is completed successfully.
• Collaborate with Product Managers, Solution Architects, Data Modeler, Consultancy Services and Engineering teams.
• Develop deep knowledge of in-house tools and suggest improvements.
• Exercise independent judgment to solve problems.

Skills

SQL

Hadoop ecosystem

Google Cloud Platform

UNIX shell scripting

HDFS/BigQuery/Hive

OLAP/OLTP/ETL

Python

Java

Education

Bachelor's degree in IT / Computer Science

Tools

HDFS

BigQuery

Hive

Job description

TransUnion's Job Applicant Privacy Notice

Personal Information We Collect

Your Privacy Choices

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:

• 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 tax‑advantagedHSAandFSAaccounts to make everyday care more affordable.
• For Your Protection: We’ve got your back withcompany‑paid basic life and AD&D, optionalvoluntary life and AD&Dfor you and your family, andshort‑ and long‑term 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 optionallong‑term 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 well‑being 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 Affimative 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.The application window for this job posting is estimated to close on 09/25/2026. Job postings may come down early or be extended due to business need or volume of applicants.

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