Data Architect

Data Architect
Remote
 

Description:
Diversified Systems is searching for a Data Architect responsible for designing, implementing, and maintaining the organization''s data architecture to ensure data integrity, scalability, and accessibility. This role defines how data is stored, consumed, integrated, and managed across systems, aligning with business objectives and technology standards. The architect will also leverage modern cloud data platforms, including Snowflake, to support advanced analytics and scalable data solutions.

Responsibilities:

• Data Architecture Design: Develop and maintain enterprise data models, schemas, and standards.
• Define data flows and integration patterns between systems, including cloud-native platforms such as Snowflake.
• Database Management: Oversee logical and physical database design for performance and scalability.
• Collaborate with DBAs on optimization, capacity planning, and Snowflake performance management.
• Data Governance: Establish data quality, security, and compliance standards.
• Implement metadata management and maintain a data dictionary.
• Integration & ETL: Design and optimize ETL/ELT processes for data warehousing and analytics, with hands-on experience using Snowflake''s ingestion and transformation capabilities.
• Ensure interoperability between on-prem and cloud systems.
• Collaboration: Work with business analysts, developers, and stakeholders to translate requirements into data solutions.
• Provide guidance on data modeling best practices.
• Performance & Security: Ensure data architecture meets performance SLAs and security requirements.
• Implement encryption, access controls, and audit mechanisms across both traditional DBMS and Snowflake environments.
• Innovation: Evaluate emerging technologies (cloud, big data, AI/ML) for adoption.
• Recommend improvements to existing data architecture, including Snowflake optimization and new cloud capabilities.

Requirements:

• 5 years of experience in data architecture, database design, and data modeling required.
• 5 years of experience in SQL Server/Oracle or similar RDBMS required.
• 5 years of experience with Cloud Platforms (Azure, AWS) required.
• 5 years of experience with ETL tools, APIs and integration framework required.
• 5 years of expertise with modern cloud data warehouses such as Snowflake required.

About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.