Sr. Data Architect

Fabick Cat•Fenton, MO

4d•Onsite

About The Position

Fabick Cat is seeking a highly skilled Senior Data Architect to oversee and support multiple business-critical applications and database platforms across the enterprise. The Senior Data Architect serves as the technical owner across a portfolio of third-party and in-house systems, managing the full project lifecycle from requirements through implementation. This position plays a critical role in Fabick Cat's data modernization effort, helping define, build, test, and implement a future-state, cloud-based data architecture. This future-state architecture is intended to lend itself heavily to enterprise AI adoption and to support an upcoming migration to Microsoft Dynamics 365. The Senior Data Architect works closely with IT leadership, business partners, and other IT teams to ensure database and data platform solutions are secure, scalable, and aligned with Fabick Cat's strategic objectives and Caterpillar's digital vision.

Requirements

Previous experience with Power Apps, Power BI, PowerShell, SSRS, and Snowflake.
Familiarity with agentic AI architectures, Retrieval-Augmented Generation (RAG) patterns, or AI-enabled data pipelines.
Extensive knowledge of Office 365 products, including SharePoint Online and Excel.
Familiarity with Caterpillar technologies, enterprise standards, and the Cat® Digital ecosystem.
Excellent analytical skills with the ability to use data for effective presentation of information.
Proven leadership, results orientation, and self-motivation.
Superb written and verbal communication skills, with the ability to engage audiences across a broad range of technical expertise and business acumen.
Proficient knowledge of project management concepts, from planning and inception through implementation and support.
Must demonstrate flexibility and agility related to critical thinking and decision-making with complex business implications.

Responsibilities

Serve as technical owner of multiple third-party and in-house database platforms and applications, overseeing the full project lifecycle including requirements, development, testing, and implementation.
Design, build, and administer APIs and system integrations that connect databases, applications, and third-party platforms, ensuring secure, reliable, and well-documented data exchange.
Oversee data warehouse operations; troubleshoot and resolve issues across supported systems.
Conduct product research and evaluate new database and software products against business requirements.
Assist with project planning and provide technical database expertise to team members and vendors.
Collaborate with vendors on the direction of solution development and enhancements for supported platforms.
Actively incorporate AI tools into daily work -- beyond basic prompting -- to accelerate tasks such as query and script development, troubleshooting, documentation, code review, and data analysis; model and promote effective AI-assisted ways of working for the broader team.
Play a key role in Fabick Cat's data modernization effort; define, build, test, and implement a future-state cloud-based data architecture.
Design and support data architecture patterns that enable enterprise AI adoption, including data pipelines, integration points, and governance structures that support AI and agentic workloads.
Support the technical planning and execution of the organization's migration to Microsoft Dynamics 365, ensuring database and data platform readiness.
Evaluate, recommend, and help implement cloud database tools and platforms, preferably on Microsoft Azure, in alignment with enterprise standards.
Maintain knowledge of emerging architectural methods and technologies, including cloud and AI-enabling data patterns, and apply them to the environment.
Define, develop, communicate, and implement data standards, processes, and procedures for the team and department.
Ensure database and data platform solutions adhere to data security, compliance, and governance frameworks, including appropriate data cataloging and access controls.
Understand and translate business requirements into database and data architecture designs that align with overall business and technology vision.
Establish, maintain, and foster relationships within and outside the team, department, and vendors.
Provide instruction and guidance to less senior team members on new tasks and assignments; ensure deadlines are met.
Listen to and evaluate customer and business needs to determine, provide, and identify high-quality solutions that align with expectations.
Perform other duties as assigned by management.