Senior Data Architect ( 4809 - Ohio )

Data Architect

Location: Raymond, OH

Work Arrangement: Onsite - 4 days per week

Employment Type: W2 Only

Job Description

We are seeking an experienced Data Architect to design, develop, and implement enterprise data architecture solutions. The ideal candidate will have extensive experience in data modeling, enterprise data warehousing, cloud data platforms, data governance, and data security. This role will involve translating business requirements into scalable data architectures, establishing data quality standards, and collaborating with business stakeholders and technical teams to deliver effective data solutions.

Job Responsibilities

• Translate high-level business requirements into data models and appropriate metadata, test data, and data quality standards.
• Manage senior business stakeholders to secure strong engagement and ensure project delivery aligns with long-term strategic roadmaps.
• Lead and participate in peer reviews and quality assurance of project architectural artifacts.
• Define and manage standards, guidelines, and processes to ensure data quality.
• Work with IT teams, business analysts, and data analytics teams to understand data consumers' needs and develop solutions.
• Evaluate and recommend emerging technologies for data management, storage, and analytics.
• Establish and maintain governance frameworks for internal teams and vendor partners to ensure the effectiveness of architecture services.

Key Responsibilities & Projects

• Understand data confidentiality, security, and compliance requirements, and apply data protection rules, including data sharing, filtering, and fencing at storage, compute, and consumption layers.
• Design data protection solutions at the database, table, and column levels, as well as APIs, based on enterprise data security standards, privacy requirements, architecture principles, and reference architectures.
• Design the structure and layout of data systems, including databases, data warehouses, and data lakes.
• Select and implement database management systems that meet organizational needs by defining data schemas, optimizing data storage, and establishing data access controls and security measures.
• Enhance data pipeline performance, ensure timely orchestration, and uphold data governance to deliver exceptional business value.

Required Skills & Qualifications

• Bachelor's degree in Computer Science, Data Science, Engineering, or a related field.
• At least 10 years of relevant experience in designing and implementing data models using Erwin for enterprise data warehouse initiatives.
• Experience leading projects involving cloud data lakes, data warehousing, data modeling, and data analysis.
• Proficiency in designing and implementing modern data architectures and concepts, including AWS cloud services, real-time data distribution technologies such as Kinesis, Kafka, and Dataflow, and modern data warehouse tools such as Redshift, Snowflake, and Databricks.
• Experience with various database platforms, including DB2, MS SQL Server, PostgreSQL, Couchbase, and MongoDB.
• Understanding of entity-relationship modeling, metadata systems, data security, and data quality tools and techniques.
• Ability to design traditional relational and modern big-data architectures based on business needs.
• Experience with business intelligence tools and technologies such as Informatica, Power BI, and Tableau.
• Exceptional communication and presentation skills.
• Strong analytical and problem-solving abilities.
• Ability to collaborate effectively in complex, cross-functional teams involving data scientists, business analysts, and business stakeholders.
• Ability to guide solution design and architecture to meet business requirements.

#LI-JS2