Enterprise Data Architect

Commerce Bank; St. Louis (MO); Hybrid; USD 105,000 - 123,500; Full time

Benefits offered by this job

Health, dental, and vision insurance

401(k)

Paid vacation

Career development assistance

Job summary

Commerce Bank is seeking a Data Architect in St. Louis, MO to collaborate on enhancing the technical architecture and data ecosystem. This role involves optimizing data models, analyzing business data needs, and ensuring the effective use of data assets.

Candidates should possess a strong understanding of data management, modeling, and warehousing techniques, with a required Bachelor's degree and relevant experience in IT. The position offers a competitive salary and a range of benefits, including employer-sponsored health insurance.

Qualifications

• 6+ years of experience in IT or a related field.
• At least 5 years in information system design required.
• 4+ years in data management and data modeling required.
• 2+ years in cloud and hybrid analytics environments required.

Responsibilities

• Collaborate with stakeholders to ensure technical architecture aligns with business outcomes.
• Analyze and optimize data models for performance and cost-effectiveness.
• Document data and analytics requirements for various uses.
• Facilitate design sessions with business and technology stakeholders.

Skills

System integration

Data modeling

Information architecture frameworks

Data science concepts

Microsoft Office suite

Data access and analytics approaches

Education

Bachelor’s degree in Information Technology or equivalent

Master’s degree preferred

Tools

PySpark

SQL

Python

Databricks

Job description

About This Job

The main purpose of this job is to collaborate with the Enterprise Architecture program and business data stakeholders to ensure that the technical architecture and information ecosystem would enable the organization to achieve business outcomes and generate meaningful value from its data assets. The Data Architect is responsible for discovering and documenting the data and analytics requirements for information for all uses and requires a deep understanding of data management, data modeling, data warehousing, and emerging data integration technologies.

Work Schedule

• Monday - Friday 8:00 AM - 5:00 PM

Essential Functions

• Partner with business and technical leadership to provide strategic recommendations that maximize the value of data assets via their creation, access and use.
• Analyze and optimize data models for performance, scalability and cost effectiveness in the cloud. Collaborate with IT Architecture, Information Security, and Data Governance stakeholders to define standards and policies for data lifecycle management, data keying strategy, and data obfuscation strategy.
• Monitor and assess the benefits and risks of change impacting the data ecosystem (e.g. new system implementations, deployment of new tools and utilities) and actively work to mitigate negative impact.
• Provide the organization with a future‑state view of the business data landscape that minimizes restrictions imposed by proprietary solutions or technologies; collaborate in the process of architectural planning and influence decisions on data architectural design.
• Assist data, analytic, business and IT leaders in developing data governance processes and structures.
• Facilitate design sessions with business and technology stakeholders to understand business needs and requirements. Develop and manage data blueprints and information models (conceptual, logical, physical, relational database designs, dimensional modeling, data vault, message models and others).
• Proactively manage the classification and zoning of data assets sourced from systems, applications, and external third‑party information providers to increase time to value.
• Aid efforts to improve business performance through enterprise information solutions and capabilities, such as master data management, metadata management, analytics, content management, data integration, and related information management or information infrastructure components.
• Analyze data and analytics security requirements and solutions, and partner with leadership to ensure that enterprise business data and analytics assets are protected.
• Perform other duties as assigned.

Knowledge, Skills & Abilities Required

• Strong understanding of system integration, including interface design, and familiarity with web‑oriented architecture techniques.
• Strong understanding of data modeling and information classification expertise at the enterprise level and industry‑specific knowledge of data security protocols, policies and regulations.
• Strong understanding of common information architecture frameworks and information models.
• Strong understanding of metamodels, taxonomies and ontologies, and of the challenges of applying structured techniques to less‑structured sources.
• Strong understanding of data science concepts and of MDM, business intelligence, and data warehouse design and implementation techniques.
• Strong understanding of a variety of data access and analytics approaches (e.g., microservices and event‑based architectures).
• Strong understanding with enterprise architecture modeling languages or frameworks such as TOGAF, ArchiMate, Zachman or UML.
• Ability to develop positive relationships across business and technical domains to facilitate activity that produces mutually beneficial outcomes.
• Ability to assess rapidly changing technological trends and developments and apply them to business needs.
• Ability to understand problems from a broad perspective leveraging business and technical knowledge to anticipate the impact of issues and potential solutions.
• Strong business and technological acumen. Possesses the ability to communicate with executives, business domain stakeholders and technical partners alike.
• Motivated and organized self‑starter with strong attention to detail and the ability to manage multiple priorities.
• Inquisitive, agile, and strong team player with excellent written, verbal, and interpersonal communication skills.
• Ability to remain adaptable and resilient to all situations with an optimistic outlook and cast a positive shadow aligned with our culture and Core Values.
• Strong proficiency with Microsoft Office suite, Microsoft Project and Teams.

Education & Experience

• Bachelor’s degree in Information Technology, Computer Information Systems, Data Management, Data Science or equivalent combination of education and experience required. Master’s degree preferred.
• 6+ years of experience in IT or a related field, with at least 5 years in information system design required.
• 4+ years of experience in data management, data modeling, data warehousing and emerging data integration technologies required.
• 2+ years of experience with distributed management and analytics in cloud and hybrid environments, with hands‑on experience building and designing Databricks Lakehouse Architecture and Delta Lake using tools such as Erwin or SqlDBM required.
• Experience in data analysis using PySpark, SQL, Python preferred.
• Professional training/industry certifications in PaaS cloud providers or specifically in Databricks preferred.
• Remote options available.

Compensation Range

Annual Salary: $105,000.00 – $123,500.00 (Amount based on relevant experience, skills, and competencies). This position will be eligible for additional compensation through performance‑based incentive plan(s) that will correspond to meeting performance goals.

Benefits

The candidate selected for this position may be eligible for employer‑sponsored health, dental, and vision insurance; 401(k); life insurance; paid vacation; and paid personal time. In addition, we offer career development, education assistance, and voluntary supplemental benefits.

Location: 8000 Forsyth Blvd, Clayton, Missouri 63105

Time Type: Full time