Data Architect

CESO, Inc.; Akron (OH); On-site; USD 86,000 - 167,000; Full time

Benefits offered by this job

Flexible and Hybrid Work Schedule

401K with a Company Match

Paid Time Off

Job summary

CESO, Inc. is seeking a Data Architect to design, implement, and maintain enterprise data architecture supporting reporting, analytics, and AI initiatives.

You will translate business requirements into scalable data solutions, establish architecture standards, and ensure data reliability and governance across platforms. The role involves collaborating with Data Engineers, stakeholders, and IT teams to create scalable lakehouse/warehouse architectures on Microsoft Fabric and Azure, while ensuring

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Management, Engineering, or equivalent experience.
• Master’s degree is preferred.
• 5+ years of experience in data architecture, data engineering, analytics engineering, or related disciplines.
• Experience documenting and communicating technical architecture decisions and recommendations.
• Experience with cloud modernization and enterprise data platform initiatives is preferred.
• Experience with Microsoft Fabric, SQL Server, Azure SQL, data warehouses, data lakes, Data Factory or lakehouse architectures is required.
• Proficiency in SQL and relational/analytical data structures is required.
• Knowledge of DAMA-DMBOK, data governance frameworks, and enterprise data management best practices.
• Understanding of security, access controls, privacy requirements, and compliance related to enterprise data is required.
• Experience designing data models for BI and KPI frameworks is preferred.
• Experience supporting AI, machine learning, or advanced analytics initiatives is preferred.

Responsibilities

• Develop, implement, and maintain enterprise data architecture standards, frameworks, design patterns, and best practices.
• Maintain logical, physical, dimensional, and semantic data models and scalable schema designs.
• Design and oversee enterprise data integration solutions, including APIs, ELT/ETL, cloud platforms, and reporting environments.
• Collaborate with Data Engineers to design lakehouse, warehouse, and data pipelines using Microsoft Fabric, SQL, and Azure technologies.
• Translate business requirements into technical designs and architecture standards.
• Establish and maintain enterprise data governance, data quality, ownership, stewardship, classification, and retention standards.
• Provide architectural guidance for database optimization, indexing, partitioning, and performance tuning.
• Review data solutions for alignment with standards, security, and business objectives; maintain data catalogs and lineage.
• Design data platform architectures for disaster recovery, business continuity, and high availability.
• Support AI-ready data platforms enabling analytics, ML, automation, and future AI initiatives.
• Communicate data opportunities and decisions to stakeholders; collaborate with technical and non-technical teams.
• Perform other duties as assigned.

Skills

SQL

Data modeling

Data governance

ETL/ELT design

Cloud platforms

Stakeholder management

Architecture standards

Security & compliance

Education

Bachelor's degree

Master's degree

Tools

SQL Server

Azure SQL

Data Factory

Microsoft Fabric

Azure Data Engineer

Job description

Are you seeking purpose, challenge, and talented colleagues? We develop leaders and empower our associates to use their skills and talents to positively impact the world through service – to our coworkers, clients, and communities. We subscribe to the mission of “empowering our people to impact communities by bringing clients’ visions to life,” so if this speaks to you, let’s connect!

At CESO, a Data Architect is responsible for designing, implementing, and maintaining the company’s enterprise data architecture. This position develops scalable, secure, and governed data solutions that support reporting, analytics, operational excellence, and AI initiatives. The Data Architect translates business requirements into technical data solutions, establishes architecture standards, and ensures enterprise data is reliable, accessible, and positioned to support future growth.

Primary Responsibilities

• Develop, implement, and maintain enterprise data architecture standards, frameworks, design patterns, and best practices to ensure consistency, scalability, security, and maintainability across the company's data platforms and solutions.
• Develop and maintain logical, physical, dimensional, and semantic data models. Design enterprise database architectures, backend data structures, and scalable schema designs that support business applications, integrations, analytics, and AI initiatives.
• Design and oversee enterprise data integration solutions, including APIs, ELT/ETL processes, cloud platforms, and reporting environments, ensuring scalable, secure, and reliable data movement
• Partner with Data Engineers to design scalable lakehouse, warehouse, and data pipeline solutions using Microsoft Fabric, SQL, and Azure technologies.
• Work with business stakeholders to understand data requirements and translate them into technical designs.
• Assist in establishing and maintaining enterprise data governance and compliance practices, including data quality, data ownership, stewardship, classification, and retention standards.
• Provide architectural guidance for databases optimization, indexing strategies, partitioning, and performance tuning to support enterprise-scale workloads
• Review data solutions for alignment with architecture standards, security requirements, and business objectives while maintaining documentation, data catalogs and lineage information.
• Design enterprise data platform architectures that support disaster recovery, backup, business continuity, and high availability requirements.
• Support the development of AI-ready data platforms that enable advanced analytics, machine learning, automation, and future AI initiatives.
• Provide analytical and problem-solving expertise to evaluate data-related opportunities, and decisions and communication them to relevant parties within the organization.
• Collaborate effectively with technical and non-technical stakeholders to gather requirements, align priorities, and deliver enterprise data solutions.
• Perform other duties as assigned.

Position Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or equivalent experience is required.
  • Master’s degree is preferred.
• Minimum of 5 years of experience in data architecture, data engineering, database administration, analytics engineering, enterprise data architecture or related disciplines is required.
• Experience documenting and communicating technical architecture decisions and recommendations is required.
• Experience supporting cloud modernization, digital transformation, or enterprise data platform initiatives is preferred.
• Microsoft Fabric, Azure Data Engineer, Azure Data Fundamentals, or related certifications, are preferred.
• Relevant certifications such as Certified Data Management Professional, Microsoft data certifications, or similar, are preferred.
• Experience working with Microsoft Fabric, SQL Server, Azure SQL, data warehouses, data lakes, Data Factory or lakehouse architectures is required.
• Proficiency in SQL and working with relational and analytical data structures is required.
• Strong understanding of data architecture principles, data modeling, database design, and integration patterns is required.
• Knowledge of DAMA-DMBOK principles, data governance frameworks, and enterprise data management best practices is required.
• Understanding of security, access controls, privacy requirements, and compliance considerations related to enterprise data is required.
• Experience designing data models for operational reporting, business intelligence, and KPI Frameworks and analytics solutions is preferred.
• Experience supporting AI, machine learning, Copilot, or advanced analytics initiatives is preferred.

Benefits and Perks

• Flexible and Hybrid Work Schedule
• Paid Time Off – Credited to You 100% Upfront
• 401K with a Company Match
• Rewards and Recognition Program
• Training and Development to Foster Professional Growth
• Paid Holidays
• Medical / Dental / Vision Coverage
• Welcome Box
• Casual Dress Code
• Reimbursement for Professional Licenses
• Paid Time Off for Community Team Service Events
• Voluntary or Supplemental Short-Term / Long-Term Disability
• Employee Assistance Program
• Company Paid Bonding and Recovery
• Employee Events such as Lunches and Outings to Foster a Positive Work Environment

$85,897 - $167,023 a year

CESO Compensation Transparency:

The pay band shown reflects the minimum and maximum base salary for this position at CESO. Actual pay is determined by several factors, including location, experience, education, skills, and internal equity. Our pay structures are benchmarked against industry and market data to stay competitive. Each offer is based on a full review of a candidate’s background, qualifications, and fit for the role.

Below are the typical new hire pay ranges for this position based on location:

• Akron, OH: $85,897 - $108,803
• Columbus, OH: $90,669 - $114,848
• Dayton, OH: $90,669 - $114,848

CESO is a principle-centered organization that aligns with strong service values, integrity, and authenticity. We develop and inspire through training and coaching on the job. At CESO, we believe that work should be more rewarding than just a paycheck. In addition to a comprehensive benefit and compensation program, we create memories and friendships through our employee and service events.

CESO, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, genetics, disability, age, veteran status, or any other characteristic protected by law. This organization participates in E-Verify and is a drug-free workplace. Criminal background checks and drug/alcohol checks are required.