Cummins

Data Modeler

Cummins$123K — $150K *
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a technical field or equivalent experience required.
  • 6-8 years of relevant experience in data architecture or data engineering.
  • Intermediate knowledge of data regulations and complex business systems.
  • Familiarity with processing and managing large datasets and Big Data platforms.
  • Experience with programming languages such as SQL, Scala, Java, and frameworks like SPARK.

Responsibilities

  • Design and automate scalable data ingestion and transformation pipelines.
  • Build frameworks for monitoring and resolving data quality issues.
  • Architect and guide development of scalable ETL/ELT pipelines.
  • Optimize physical data models and database structures for performance.
  • Develop and manage large-scale data storage solutions using cloud platforms.
  • Drive automation of data infrastructure to support agile analytics initiatives.

Benefits

  • Remote work flexibility as part of the team's structure.
  • Opportunities for continuous learning and professional development.
  • Participation in innovative projects influencing company analytics.
  • Supportive work culture promoting collaboration and team success.
  • Access to advanced technologies and tools for data processing.
Full Job Description
Job Description

We are looking for a talented Data Modeler/Data Architect to join our team specializing in Systems/Information Technology for Cummins, Inc. as part of DBU Data & Analytics, Remote.

In this role, you will make an impact in the following ways:
  • Design and automate scalable data ingestion and transformation pipelines across relational, event-based, and unstructured sources.
  • Build and maintain frameworks to monitor, detect, and resolve data quality and integrity issues. Implement data governance practices, including metadata management, data access, and retention policies.
  • Architect and guide development of reliable, efficient, and scalable ETL/ELT data pipelines with monitoring and alerting.
  • Design physical data models and optimize database structures, indexing, and relationships for performance.
  • Test, optimize, and troubleshoot data pipelines to ensure stability and performance.
  • Develop and manage large-scale data storage solutions using distributed and cloud platforms (e.g., data lakes, Hadoop, NoSQL databases).
  • Drive automation and modernization of data infrastructure and integration processes to support agile analytics initiatives.


Responsibilities

To be successful in this role you will need the following:
  • Data Extraction - Build scalable, automated ETL pipelines that deliver accurate, timely data. Choose the right tools and optimize transformations for performance and usability.
  • Programming - Write clean, well-documented, and testable code using best practices. Leverage version control and automation to ensure reliability and efficiency
  • Solution Validation Testing - Follow SDLC standards to thoroughly test and validate all solutions. Ensure outputs meet business requirements and perform correctly in production.
  • Data Quality - Proactively monitor and resolve data issues. Establish strong governance practices to maintain data accuracy and trust across the organization.


Qualifications

Education/Experience:
  • College, university, or equivalent degree in relevant technical discipline, or relevant equivalent experience required.
  • This position may require licensing for compliance with export controls or sanctions regulations.
  • Intermediate experience in a relevant discipline area is required. Knowledge of the latest technologies and trends in data engineering are highly preferred and includes:
    - Familiarity analyzing complex business systems, industry requirements, and/or data regulations
    - Background in processing and managing large data sets
    - Design and development for a Big Data platform using open source and third-party tools
    - SPARK, Scala/Java, Map-Reduce, Hive, Hbase, and Kafka or equivalent college coursework
    - SQL query language
    - Clustered compute cloud-based implementation experience
    - Experience developing applications requiring large file movement for a Cloud-based environment and other data extraction tools and methods from a variety of sources
    - Experience in building analytical solutions
    Intermediate experiences in the following are preferred:
    - Experience with IoT technology
    - Experience in Agile software development
  • 6-8 years of experience required.

Additional Responsibilities:

Preferred Job Specific Skills - Data Architect
  • Dimensional Modeling Mastery - Deep expertise in designing enterprise-scale dimensional models (star, snowflake, constellation) with strong command of fact table grain definition, surrogate key strategies, slowly changing dimensions (Types 1-6), bridge tables, and late-arriving data handling.
  • Advanced SQL Engineering - Highly proficient in writing complex, high-performance SQL, including window functions, CTE-driven transformations, query plan analysis, cost-based optimization, partitioning strategies, and performance tuning across large, distributed datasets.
  • Snowflake Architecture & Engineering - Hands-on experience with Snowflake internals including micro-partitioning, clustering keys, result-set caching layers, warehouse sizing/auto-suspend tuning, Snowpipe/Streams/Tasks orchestration, Time Travel, Zero-Copy Cloning, and secure data sharing patterns.
  • Graph Database & Cypher Proficiency - Strong experience with Neo4j or equivalent graph platforms, including graph schema design, Cypher query optimization, graph algorithms (PageRank, community detection, pathfinding), and integration of graph workloads with analytical and relational systems.
  • Microsoft Fabric Ecosystem - Practical experience with Fabric Lakehouse architecture, Delta Lake optimization, Data Engineering pipelines, Data Factory orchestration, KQL-based Real-Time Analytics, semantic model creation, and integration with Power BI and OneLake governance.
  • SAP S/4HANA Data Structures -Familiarity of SAP S/4HANA data models (FI/CO, MM, SD, PP), CDS views, OData services, SLT/SDI/ODP-based extraction patterns, and harmonization of SAP transactional data into cloud-based analytical platforms.
  • Cloud Data Architecture - Strong understanding of distributed data processing, ELT/ETL orchestration, event-driven ingestion (Kafka/Event Hub), metadata-driven frameworks, schema evolution, and data lifecycle management across cloud environments (Azure preferred).
  • Data Governance & Metadata Management - Experience implementing enterprise data catalogs, lineage tracking, data quality rules, master data integration, and security models (RBAC/ABAC, row-level and column-level security).
  • Performance Engineering & Optimization - Ability to diagnose bottlenecks across compute, storage, and network layers; optimize workloads for cost and performance; and design scalable, fault-tolerant data architectures.
  • Cross-Platform Integration - Experience integrating heterogeneous systems (SAP, Snowflake, Fabric, graph DBs, APIs, streaming platforms) into unified analytical ecosystems with strong focus on interoperability and data consistency.

Compensation:

Please note that the salary range provided is a good faith estimate on the applicable range. The final salary offer will be determined after considering relevant factors, including a candidate's qualifications and experience, where appropriate.

Premium Range:

Minimum: $123,030

Maximum: $150,370

About Cummins

Cummins Power Generation is a world leader in the design and manufacture of power generation equipment, including PowerCommand standby and prime power systems. They also provide single-source warranty, planned maintenance, and round-the-clock emergency service 24 hours a day, seven days a week including back-up power rental through their network of distributors. Part of the world-wide power systems business which has annual sales of more than $1.2 billion, Cummins Power Generation's strength comes from being a division of Cummins Inc. Cummins Power Generation has unique expertise in that all aspects of generator set design, manufacture and service have been brought together in one company. All the major components - the engine, alternator and control systems - are manufactured by divisions of Cummins. This integral approach means each element of a generating set is matched to work in harmony from the start. Providing what the customer wants is at the core of Cummins' manufacturing philosophy. For generating set customers this means a choice of mobile, stationary, open or sound attenuated versions is available for all models.

Cummins Careers

Join the dynamic world of Cummins, a global leader in power solutions, where innovation and leadership drive our mission to power a more prosperous world. At Cummins, we offer unparalleled job opportunities in engineering, technology, and business management, making it an ideal place for professionals seeking meaningful and impactful careers. Work You’ll Do At Cummins, you’ll be part of a team that values diversity and is committed to creating inclusive growth opportunities for all employees. Our culture thrives on intellectual curiosity, cognitive diversity, and bringing your whole self to work. We believe in your potential and encourage every team member to reach their personal and professional goals. Join our industry-leading team to help develop groundbreaking solutions and technologies that impact markets and communities across the globe. Your work at Cummins will not only contribute to global innovation but also ensure sustainable practices that benefit future generations. Professional Growth and Development Cummins is dedicated to the professional growth of its employees. We offer a variety of leadership and diversity training programs designed to enhance your skills and advance your career. From hands-on internships for emerging talents to leadership programs for seasoned professionals, Cummins provides resources and global opportunities to learn, thrive, and lead in your respective field. Innovative Work Environment Our commitment to innovation is at the core of what we do. At Cummins, you will collaborate with skilled colleagues who are eager to share knowledge and ideas. We foster an environment where creative thinking and proactive leadership are encouraged, driving us forward in the areas of clean energy and environmental sustainability. Benefits and Culture Cummins employees enjoy a range of benefits designed to support their physical, financial, and emotional well-being. Among these are comprehensive health care options, competitive retirement plans, and flexible work arrangements. Our supportive culture champions community involvement and a work-life balance that accommodates the diverse needs of our team members. Join Our Team Explore the numerous job opportunities at Cummins where your skills and interests can be matched with the right position, helping you to excel. We are continuously hiring and looking for ambitious, curious, and innovative individuals ready to make a significant impact. Stay Connected Keep up to date with the latest at Cummins by following our careers blog. Gain insights from insiders, learn about our employment practices, and discover how our team is leading the charge in global power solutions. Job Alert Emails Customize your experience by subscribing to Cummins job alerts. Receive updates on new postings, company news, and insider tips directly tailored to your career interests. See what exciting and rewarding opportunities await at Cummins. At Cummins, your career is just beginning. Join us, and power your potential on a global stage.
Learn more about Cummins
Size
59,900 employees
Market Cap
$34.3 billion
Industry
Net Income
$1.7 billion
Founded
1919
5 Year Trend
+6.5%
Revenue
$19.8 billion
NASDAQ

Similar Jobs

More Jobs at Cummins

More Enterprise Technology Jobs

Find similar Data Modeler jobs: