Data Architect

BrothersTech; United States; On-site; USD 130,000 - 180,000; Full time

Job summary

BrothersTech is seeking a Senior Data Architect to design and oversee enterprise data architecture across data warehouses, data lakes, and lakehouse platforms. You will define standards, models, and governance to support scalable, compliant data solutions for the organization.

The role collaborates with data engineers, DBAs, data scientists, BI developers, and business stakeholders to ensure scalable data flows, secure access, and cost-efficient analytics infrastructure.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field; a master's degree is preferred.
• 7–10 years of experience in data engineering, database architecture, data warehousing, or enterprise data architecture.
• Strong experience designing enterprise data models and data integration solutions.
• Expertise in SQL, relational databases, and database performance optimization.
• Experience with data warehouse and data lake architectures.
• Hands-on knowledge of cloud data platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics.
• Understanding of ETL/ELT pipelines, distributed processing, and data orchestration.
• Knowledge of data governance, data quality, metadata, and data lineage.
• Experience with data security, encryption, access controls, and regulatory compliance requirements.
• Strong communication, technical leadership, documentation, and stakeholder management skills.

Skills

SQL

Data modeling

Data governance

Leadership

Stakeholder management

Communication

Cloud data strategy

Education

Bachelor's degree in CS/IT/Data Eng

Master's degree preferred

Tools

Snowflake

Amazon Redshift

Google BigQuery

Azure Synapse Analytics

Databricks

Apache Spark

Delta Lake

dbt

Informatica

Talend

Azure Data Factory

Kafka

Job description

• Design and maintain enterprise data architecture, including data warehouses, data lakes, and lakehouse platforms.
• Define data architecture standards, principles, patterns, and best practices across the organization.
• Develop conceptual, logical, and physical data models to support business and technical requirements.
• Design scalable data integration and ETL/ELT architectures.
• Evaluate and recommend data platforms, databases, cloud services, and integration technologies.
• Define data flow, data lineage, metadata management, and master data management strategies.
• Develop data governance frameworks covering data quality, privacy, security, and compliance.
• Design architectures for batch processing, real-time streaming, and large-scale analytics.
• Collaborate with data engineers, database administrators, data scientists, BI developers, and business stakeholders.
• Establish standards for database design, data access, storage, performance, and lifecycle management.
• Guide engineering teams in implementing architecture designs and resolving complex technical challenges.
• Review existing data environments and recommend modernization, migration, and optimization strategies.
• Ensure data architectures meet scalability, availability, disaster recovery, and cost-efficiency requirements.
• Document architecture decisions, technical specifications, reference architectures, and implementation roadmaps.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field; a master's degree is preferred.
• 7–10 years of experience in data engineering, database architecture, data warehousing, or enterprise data architecture.
• Strong experience designing enterprise data models and data integration solutions.
• Expertise in SQL, relational databases, and database performance optimization.
• Experience with data warehouse and data lake architectures.
• Hands-on knowledge of cloud data platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse Analytics.
• Understanding of ETL/ELT pipelines, distributed processing, and data orchestration.
• Knowledge of data governance, data quality, metadata, and data lineage.
• Experience with data security, encryption, access controls, and regulatory compliance requirements.
• Strong communication, technical leadership, documentation, and stakeholder management skills.

Preferred Qualifications

• Experience designing cloud-native data architectures on AWS, Azure, or Google Cloud.
• Familiarity with Databricks, Apache Spark, Delta Lake, and modern lakehouse architectures.
• Experience with streaming technologies such as Apache Kafka.
• Knowledge of data modeling tools such as ERwin, ER/Studio, or equivalent platforms.
• Experience with dbt, Informatica, Talend, or Azure Data Factory.
• Familiarity with data mesh, data fabric, and domain-oriented data architecture.
• Experience with enterprise architecture frameworks and architecture review processes.
• Relevant cloud, data architecture, or data management certifications.