Database Design Designer Jobs in Mossville, IL (NOW HIRING)

Career Area: Technology, Digital and Data

Cat Digital is the digital and technology arm of Caterpillar Inc., leveraging the latest technologies to build industry leading digital solutions for our customers and dealers. With over 1.5 million connected assets worldwide, our teams use data, technology, advanced analytics, telematics, and AI capabilities to help our customers build a better, more sustainable world. Caterpillar is investing in our digital future, and we’re looking for a Principal Data Architect within the Cat Digital Helios team to help maximize the value of Caterpillar’s digital platform. Cat Digital focuses on accelerating services and parts growth by providing digital solutions through data analytics, innovation and customer-focused solutions. This role is a technical resource leveraging business requirements to solution reusable business-ready datasets to support applications, analytics, and business intelligence use cases across Cat Digital and the enterprise.

• Act as team lead by providing technical leadership, guidance, and assistance to other team members across the organization.
• Lead complex projects spanning across multiple system components.
• Work directly on complex problems and provide solutions aligned with overall objectives of Cat Digital.
• Understand and evaluate business requirements that impact the data of Caterpillar enterprise, dealership partners, and other internal and external customers.
• Liaise with data creators to support project planning, training, guidance on standards, and the efficient creation/maintenance of high-quality data.
• Contribute to policies, procedures, and standards as well as technical requirements.
• Create 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, 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 scorecards, and resolving exceptions with data owners and source systems.
• Be accountable to design robust, scalable database and data solutions supporting applications, analytics, and business intelligence.
• Document data models for domains to be deployed including a logical data model, candidate source lists, and canonical formats.
• Provide guidance and expertise on identifying source systems, developing data object pipeline specifications, metadata policies, as well as alignment of data governance efforts.

• Value Realization: Knowledge of value realization methods; ability to plan, execute, monitor and manage business activities and resources to determine and achieve the actual value from a business initiative as estimated in an associated business case.
• Communicating Complex Concepts: Knowledge of effective presentation tools and techniques to ensure clear understanding; ability to use summarization and simplification techniques to explain complex technical concepts in simple, clear language appropriate to the audience.
• Agile Development: Knowledge of agile methodologies and the agile development lifecycle; ability to utilize formal agile methodologies, disciplines, practices and techniques for the delivery of new and enhanced applications.
• Cloud Computing: Knowledge of cloud-based solutions and their applications; ability to design, implement, and manage cloud-based solutions to meet business needs and improve operational efficiency.
• Database Design (Physical): Knowledge of database systems; ability to establish a data model for designing an organization's database that runs effectively and efficiently for better business outcome.
• ETL Process: Knowledge of the extraction, transformation and loading (ETL) process; ability to develop a database through the ETL process.
• Information Management: Knowledge of an organization's existing and planned Information Architecture and Information Management (IM) methodology; ability to collect and manage information from different sources, and distribute this information to enhance operational efficiency.
• Modeling: Data, Process, Events, Objects: Knowledge of data, process and events; ability to use tools and techniques for analyzing and documenting logical relationships among data, processes or events.

• A bachelor's degree or equivalent experience.
• Strong experience in data management (data design, data quality, metadata, governance, etc.).
• Proven demonstrated experience leading data management or software engineering projects.
• Understanding of information management concepts such as controlled vocabulary, authority control, data modeling, and schema design.
• Experience in creating conceptual and logical data models.
• Software development experience with object-oriented/object function scripting languages: Python, Java, JavaScript, C++, Scala, etc. is preferred.

• This position requires the candidate to be in Chicago, IL or Peoria, IL.
• Relocation assistance is NOT available for this position.
• Visa sponsorship is NOT available with this position.

Summary Pay Range: $147,760.00 - $221,640.00. Compensation and benefits offered may vary depending on multiple individualized factors, job level, market location, job-related knowledge, skills, individual performance and experience. This is a summary list of benefits: Medical, dental, and vision benefits; Paid time off; 401(k); Health Savings Account; Flexible Spending Accounts; Health Lifestyle Programs; Employee Assistance Program; Voluntary Benefits and Employee Discounts; Career Development; Incentive bonus; Disability benefits; Life Insurance; Parental leave; Adoption benefits; Tuition Reimbursement. Some benefits apply to part-time employees.

This position requires working onsite five days a week. Visa Sponsorship is not available for this position.

Posting Dates: Any offer of employment is conditioned upon the successful completion of a drug screen. Caterpillar is an Equal Opportunity Employer, Including Veterans and Individuals with Disabilities. Qualified applicants of any age are encouraged to apply.

Not ready to apply? Join our Talent Community. There’s more to work at Caterpillar than just the work itself. We hire smart, friendly people and it shows in our culture. We hold ourselves to high standards and make sure our values of integrity, excellence, teamwork, commitment and sustainability come to life in the way we work. We celebrate the diversity of our team, while also working together as one Caterpillar. Our culture, like everything at our company, is made possible by each employee’s contribution.