Caterpillar
Cat Digital uses digital technologies to help Caterpillar Inc. customers build a better world.
Chicago, IL
Remote

Senior Data Specialist at Caterpillar

| Chicago | Remote
Sorry, this job was removed at 6:07 a.m. (CST) on Saturday, February 5, 2022
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Career Area:
Digital
Job Description:
The Senior Data Specialist is a technical resource involved in data quality, data design, metadata management and data governance of Caterpillar's digital offerings.
Job Duties:
• Competent to perform all necessary data related task which could include data design, data quality, metadata management, data governance or data architecture. • Work directly on complex problems and provide solutions aligned with overall objectives of Cat Digital. • Understand and evaluate business requirements that impact the Caterpillar enterprise, dealership partners, and other internal and external customers. • Liaises with data creators to support project planning, training, guidance on standards, and the efficient creation/maintenance of high-quality data • Contributes to policies, procedures, and standards as well as technical requirements • Create the data management strategy and define continuous improvement goals of data quality, governance and processes. • Lead communication across various lines of businesses and technology partners to constantly monitor, collect, review, and roadmap business data requirements, and related technology solutions. • Ensure compliance with the latest data standards supported by the company, and brand, legal, information security (data security and privacy compliance). • Maintain knowledge of functional technology of the data management systems as they change with upgrades and new releases. • Maintain existing data quality scorecard measurements, executing of scorecards, resolving exceptions with data owners and source systems • Accountable to design robust, scalable database and data extraction, transformation and loading (ETL) solutions • Document data models for domains to be deployed including a logical data model, candidate source lists, and canonical formats. • Develop data ingestion store specifications identifying source systems and the tables and fields to ingest. • Develop data object pipeline specifications including detailed field level mapping, business rules, data quality rules, etc. • Creates, updates, and enhances metadata policies, processes and catalogs • Drives alignment and coordination of data governance efforts
Employee is also responsible for performing other job duties as assigned by Caterpillar management from time to time.
Basic Requirements:
• A 4-year degree from an accredited college or university or equivalent experience • 5 years or more of experience in data management (data design, data quality, metadata, governance, etc.)
Top candidates will also have:
• Understanding of information management concepts such as controlled vocabularies, authority control, data modeling, and schema design. • Strong knowledge of end-to-end data lifecycle across traditional data warehouses, relational databases, operational data stores, business intelligence reporting, and big data analytics. • Strong understanding of data governance, metadata management, data quality, data modeling, and data architecture concepts • Experience in Metadata Management role within a large corporation preferably high tech or technology manufacturing • Experience creating conceptual and logical data models • Experience with metadata managers like Erwin's Mapping Manager • Experience with data profiling tools such as Alteryx • Experience with data cataloging tools such as Collibra • Extract, Transformation, Load (ETL) development skills • Knowledge of data technology products and components for Big Data and Cloud (AWS, Data Lakes, and similar). • XML and JSON file format knowledge • Strong SAS programming skills with proficiency in using SAS-PC with data step, macro processing, and PROC SQL • Software development experience with object-oriented/object function scripting languages: Python, Java, Javascript, C++, Scala, etc • Experience with Object Oriented Concepts/Development/Modeling • Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment. • Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience • Comfortable working in a dynamic environment where digital is still evolving as a core offering
Visa sponsorship available for eligible applicants.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
Not ready to apply? Submit your information to our Talent Network here .
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

In the heart of Chicago's lively West Loop area, we have easy access to public transport, great bars and restaurants, and an awesome office roof deck.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • Google CloudFrameworks
    • AWS (Amazon Web Services)Frameworks
    • Amazon Web ServicesFrameworks
    • AWS ElasticSearchFrameworks
    • AWS Code PipelineFrameworks
    • DockerFrameworks
    • ApigeeFrameworks
    • FlinkFrameworks
    • AkkaFrameworks
    • Amazon ECSFrameworks
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • DynamoDBDatabases
    • RDSDatabases
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • Google OptimizeAnalytics
    • Google Data StudioAnalytics
    • Google Tag ManagerAnalytics
    • Google Search ConsoleAnalytics
    • Microsoft ProjectManagement
    • SalesforceCRM
    • Google Campaign Manager 360Lead Gen
    • Google Display & Video 360Lead Gen
    • Google Search Ads 360Lead Gen
Previous
Next

What are Caterpillar Perks + Benefits

Culture
Volunteer in local community
Caterpillar Inc. participates in local volunteer activities such as the Chase Corporate Challenge
Partners with Nonprofits
Friends outside of work
Eat lunch together
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Open office floor plan
Diversity
Documented equal pay policy
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Recreational Clubs
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available
Customized development tracks
Paid industry certifications

An Insider's view of Caterpillar

What are some social events your company does?

Whether we’re working virtually or in-person, we are always looking for ways to have fun and grow as a team. Team dinners, coffee chats, ax throwing, chess club, and virtual happy hours are just a few of the activities we do to make work more fun and connect with colleagues around the world.

Madison

Recruiter

What kinds of technical challenges do you and your team face?

It’s amazing to be able to work in an architectural framework where we can negotiate between speed to market and a solid application – software that is well-built, well-designed, well-tested. I find this negotiation both challenging and exhilarating.

MacGregor

Lead Software Engineer

How does the company support your career growth?

I’ve been with Caterpillar for 20 years now, and I’ve been lucky to work on teams that have different focuses. I’ve worked on everything from engineering applications to the latest and greatest digital technology applications.

Rakshan

Digital Product Manager

How do you empower your team to be more creative?

I believe innovative solutions require experimenting, even if not all ideas are successful. My role is to help my team understand a business challenge, promote idea exchange, and encourage exploration of different approaches in search of the solution. Throughout this, we see setbacks as part of the journey to exceptional solutions

Daniela

Analytics Manager

What projects are you most excited about?

Deep learning algorithms, popularized in the past five years, allow us to scan huge volumes of data from Caterpillar's fleet of connected engines and machines for unusual patterns. We're now able to make sophisticated predictions that wouldn’t have been possible 20 years ago.

Dan

Analytics Director

More Jobs at Caterpillar