Senior Data Architect – AWS Cloud & Enterprise Data Platforms

Delta Computer Consulting, Inc.; Marysville (OH); On-site; USD 102,000 - 112,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life Insurance

401k

Continuing & On-Demand Education

Job summary

Delta Computer Consulting, Inc. is seeking a Senior Data Architect to design, govern, and optimize enterprise data architectures for large-scale data warehousing and cloud data lakes.

The role focuses on Erwin-based modeling, AWS cloud data architecture, and modern platforms like Snowflake, Databricks, and Redshift. The ideal candidate has 10+ years building scalable data models, collaborating with stakeholders, data engineers, and enterprise architects to enforce governance and standards across

Qualifications

• 10+ years of enterprise data architecture, modeling, and warehouse design.
• Extensive experience with Erwin Data Modeler for warehouse initiatives.
• Proven ability to design logical, conceptual, and physical data models for complex environments.
• Strong experience with cloud data lakes, warehouses, and large-scale platforms.
• Deep knowledge of AWS cloud services and modern data architecture.
• Experience with Redshift, Snowflake, Databricks.
• Knowledge of real-time processing with Kafka, Kinesis, Dataflow.
• Experience with multiple databases (DB2, MS SQL, PostgreSQL, MongoDB).
• Ability to define data governance, quality, security, and privacy standards.

Responsibilities

• Design and implement architectures for data warehouses and cloud data lakes.
• Translate business requirements into logical and physical data models and metadata structures.
• Develop enterprise data models using Erwin and established methodologies.
• Design data storage and processing across AWS, Redshift, Snowflake, Databricks, and databases.
• Architect data solutions involving real-time streaming technologies (Kafka, Kinesis, Dataflow).
• Define schemas, optimize storage, and enforce access controls.
• Implement data protection, security and privacy controls at multiple levels.
• Establish governance frameworks, standards, and quality processes.
• Collaborate with data engineers, analysts, and executives to meet data needs.
• Lead architecture reviews and evaluate emerging data technologies.

Skills

Data modeling

AWS cloud

Erwin Data Modeler

Data governance

Snowflake

Kafka & streaming

Education

Bachelor's degree in Computer Science or related field

Tools

Erwin Data Modeler

Snowflake

Databricks

Amazon Redshift

Kinesis

Kafka

Power BI

Tableau

Job description

Pay Range: $74.00 – $81.00 per hour (based on experience & internal equity)

Benefits: Health, Dental, Vision, Life Insurance, 401k, Continuing & On-Demand Education

Must be able to work in Raymond, OH, according to the required onsite schedule

Sponsorship is available for this role

Position Summary

We are seeking a highly experienced Senior Data Architect to design, develop, and govern enterprise data architectures supporting large-scale data warehousing, cloud data lakes, analytics, and data integration initiatives.

This role requires deep expertise in enterprise data modeling, Erwin, AWS cloud data architecture, data warehousing, and modern data platforms such as Snowflake, Databricks, and Amazon Redshift.

The ideal candidate has 10+ years of experience designing and implementing enterprise data models and data architecture solutions, with the ability to translate complex business requirements into scalable, secure, high-performance data platforms.

This position involves close collaboration with senior business stakeholders, data engineers, analytics teams, and enterprise architects to establish data architecture standards, strengthen data governance, and deliver solutions aligned with business objectives.

What This Person Will Be Working On

• Design and implement enterprise data architectures supporting data warehouses, cloud data lakes, and modern analytics platforms.


• Translate business requirements into logical and physical data models, metadata structures, data quality standards, and technical architecture specifications.


• Develop and maintain enterprise data models using Erwin and established data modeling methodologies.


• Design data storage and processing solutions across AWS, Redshift, Snowflake, Databricks, and relational/non-relational databases.


• Architect data solutions involving real-time streaming and data distribution technologies, including Kafka, Kinesis, and Dataflow.


• Define database schemas, optimize data storage structures, and establish appropriate data access controls.


• Design and implement data protection and security controls at the database, table, column, and API levels.


• Apply data confidentiality, privacy, compliance, filtering, and access restrictions across storage, compute, and consumption layers.


• Establish and maintain data governance frameworks, architectural standards, guidelines, and data quality processes.


• Partner with data engineers and analytics teams to improve data pipeline performance, orchestration, reliability, and efficiency.


• Lead architectural design reviews, peer reviews, and quality assurance of technical architecture deliverables.


• Evaluate and recommend emerging technologies for enterprise data management, storage, and analytics.


• Collaborate with business analysts, data scientists, IT teams, and stakeholders to understand data consumption requirements.


• Guide technical teams and vendor partners to ensure solutions follow enterprise architecture and security standards.


• Communicate architectural recommendations, technical designs, and strategic roadmaps to senior leadership.

Required Skills & Experience

• 10+ years of relevant experience in enterprise data architecture, data modeling, and data warehouse design and implementation.


• Extensive hands-on experience with Erwin Data Modeler for enterprise data warehouse initiatives.


• Proven experience designing logical, conceptual, and physical data models for complex enterprise environments.


• Strong experience architecting cloud data lakes, enterprise data warehouses, and large-scale data platforms.


• Deep understanding of AWS cloud services and modern cloud data architecture.


• Experience with modern data warehouse and analytics technologies such as Amazon Redshift, Snowflake, and Databricks.


• Knowledge of real-time data processing and streaming technologies, including Amazon Kinesis, Apache Kafka, and Dataflow.


• Experience working with multiple database platforms, including DB2, Microsoft SQL Server, PostgreSQL, Couchbase, and MongoDB.


• Strong understanding of relational databases, entity-relationship modeling, metadata management, and big data architecture.


• Experience defining and implementing data governance, data quality, data security, and data privacy standards.


• Ability to design secure data architectures with appropriate database, table, column, and API-level access controls.


• Experience with data integration, pipeline optimization, and orchestration.


• Familiarity with Informatica, Power BI, and Tableau for enterprise data integration and business intelligence.


• Experience translating business requirements into technical architecture solutions and design specifications.


• Strong experience conducting architecture reviews and establishing enterprise data architecture standards.


• Ability to collaborate with data engineers, data scientists, business analysts, enterprise architects, and executive stakeholders.


• Excellent communication, presentation, analytical, and problem-solving skills.


• Bachelor's degree in Computer Science, Data Science, Engineering, or a related field.

Desired Skills

• Experience supporting large enterprise data modernization and cloud migration initiatives.


• Experience designing enterprise-scale AWS data lake and lakehouse architectures.


• Strong understanding of data lakehouse, data mesh, and modern enterprise data architecture patterns.


• Experience implementing data governance frameworks, metadata management, and data cataloging solutions.


• Familiarity with data lineage, master data management, and enterprise data quality frameworks.


• Experience with real-time and event-driven data architectures.


• Experience implementing data encryption, role-based access controls, data masking, and fine-grained access policies.


• Experience optimizing data pipelines and improving large-scale data processing performance.


• Experience guiding technical teams and external vendors on architectural standards and implementation.


• Background supporting enterprise analytics, business intelligence, or advanced data science initiatives.


• Experience working in automotive, manufacturing, or other large enterprise environments.