Data Architect

DESCRIPTION

We are looking for a talented DBU Data Architect to join our team in Systems/Information Technology working remotely from your home office.

*In this role, you will make an impact in the following ways:*

• Enhance Data Integration : By designing and automating the deployment of distributed systems, you'll streamline the ingestion and transformation of diverse data sources, ensuring seamless data integration.
• Improve Data Quality : Implementing frameworks to continuously monitor and troubleshoot data quality and integrity issues will ensure that the data remains accurate and reliable.
• Strengthen Data Governance : Establishing robust data governance processes will help manage metadata, access, and retention, ensuring compliance and security for both internal and external users.
• Optimize Data Pipelines : Your guidance on building efficient, scalable, and quality data pipelines with monitoring and alert mechanisms will enhance the reliability and performance of data processing.
• Boost Database Performance : Designing and implementing physical data models and optimizing database performance through efficient indexing and table relationships will ensure fast and reliable data access.
• Drive Automation : Utilizing innovative tools and techniques to automate repetitive data preparation and integration tasks will reduce manual errors and improve overall productivity.
• Lead and Mentor : By coaching and developing less experienced team members, you'll foster a culture of continuous learning and improvement within the team.
• Collaborate for Success : Working with key stakeholders to plan, design, and deliver optimal analytics and data science solutions will ensure that critical analytics initiatives are timely and successful.

RESPONSIBILITIES

To be successful in this role you will need the following:

• Master System Requirements Engineering : Utilize appropriate methods and tools to translate stakeholder needs into verifiable requirements. Establish acceptance criteria, track requirements throughout the system lifecycle, and assess the impact of changes on project scope, schedule, and resources.
• Collaborate Effectively : Build strong partnerships and work collaboratively with others to achieve shared objectives. Your ability to work well in a team will be crucial.
• Communicate Clearly : Develop and deliver communications that convey a clear understanding of the unique needs of different audiences. Effective communication will ensure that everyone is on the same page.
• Focus on the Customer : Build strong relationships with customers and deliver solutions that meet their needs. A customer-centric approach will help you create value and satisfaction.
• Make Quality Decisions : Make good and timely decisions to keep the organization moving forward. Your decision-making skills will be key to navigating complex situations.
• Excel in Data Extraction : Perform ETL activities from various sources and transform data for downstream applications and users using appropriate tools and technologies.
• Develop Strong Programming Skills : Create, write, and test computer code, test scripts, and build scripts using industry standards and tools. Ensure compliance with business, technical, security, governance, and compliance requirements.
• Apply Quality Assurance Metrics : Use the IT Operating Model (ITOM) and SDLC standards, tools, metrics, and key performance indicators to assess whether solutions meet their intended outcomes.
• Document Solutions : Document information and solutions based on knowledge gained during product development. Communicate effectively to enable improved productivity and knowledge transfer.
• Validate Solutions : Validate configuration item changes or solutions using best practices and SDLC standards to ensure they work as designed and meet customer requirements.
• Ensure Data Quality : Identify, understand, and correct flaws in data to support effective information governance and decision-making.
• Solve Problems Systematically : Use systematic analysis processes and industry-standard methodologies to solve problems. Mentor others on effective problem-solving techniques.

QUALIFICATIONS

Education, Licenses, Certifications:

• 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.

Experience:

• Intermediate experience in a relevant discipline area is required.
• 5-7 years of experience in data modeling 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

Additional Responsibilities:

• Work closely with business Product Owner to understand product vision.
• Accountable for conducting comprehensive analyses to identify deficiencies in the current data architecture and redesigning the data framework to optimize the overall DBU Data & Analytics.
• Play a key role across DBU Data & Analytics Power Cells to define, develop data architecture for respective functional areas under limited guidance.
• Collaborate closely with CMI Enterprise Data Architecture and AAI Solutions Architecture to ensure alignment of DBU projects data design and modeling standards.
• Play the role of Federated Data Architect and represent DBU Data & Analytics projects in CMI Architecture forums.
• Design, develop Conceptual, Logical and Physical Data Models for the DBU Data & Analytics projects with limited guidance.
• Participate in and contribute to the data architecture strategy, and the execution of critical programs such as Quantum, Unified Data Model, BI Simplification, Product Lifecycle Management, and Customer + Product data quality and governance.
• Responsible for creation, maintenance and management of DBU Data & Analytics data architecture documentation.
• Take part in evaluation of new data tools, POCs and provide suggestions.
• Support the maintenance of developed data models, assist with enhancements, performance optimization, and address issues related to data models to ensure data accuracy and usability.

• Strong SQL skills
• Expertise in Dimensional Modeling
• Working knowledge of at least one data platform (Snowflake, Databricks Delta Lake)
• Expertise in RDBMS, Ability to write complex joins
• Professional certifications in Data Architecture is a plus
• SAP knowledge and experience is nice to have

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 candidates qualifications and experience, where appropriate.

Min Salary $76800

Max Salary $115200

• Apply
• Join Our Talent Community
• Employees Refer a Friend
• Request an Accommodation

As Cummins continues to grow, you'll be provided with continuous learning opportunities, supportive benefits and a culture that values your wellbeing, safety and work-life balance. Here, you'll have the power to determine your future with innovative technology, a focus on sustainability and with a company positioned for long-term growth.