Data Architect

Job Type: Contract (w2 only)
Experience: 10+ Years

Job Description

We are seeking an experienced Data Architect to design, develop, and implement scalable enterprise data architectures supporting modern analytics, reporting, cloud, and data-driven applications. The ideal candidate will have strong experience with data modeling, cloud data platforms, data integration, governance, and enterprise data architecture.

Key Responsibilities

• Design and implement scalable enterprise data architectures across on-premises and cloud environments.
• Develop conceptual, logical, and physical data models for enterprise applications and analytics platforms.
• Define data architecture standards, patterns, principles, and best practices.
• Design modern data warehouses, data lakes, and lakehouse architectures.
• Develop and optimize data pipelines and ETL/ELT processes.
• Work with cloud data platforms such as AWS, Azure, or Google Cloud Platform.
• Design solutions using platforms such as Snowflake, Databricks, Redshift, BigQuery, or Azure Synapse.
• Develop data integration strategies using APIs, batch processing, streaming, and event-driven architectures.
• Implement data governance, data quality, metadata management, lineage, security, and compliance frameworks.
• Design highly available, scalable, secure, and cost-effective data solutions.
• Collaborate with Data Engineers, Data Scientists, Business Analysts, Application Architects, Cloud Architects, and DevOps teams.
• Analyze existing data environments and develop modernization and migration strategies.
• Optimize database performance, query performance, storage, and data processing.
• Create architecture diagrams, technical documentation, data models, and design specifications.
• Provide technical leadership and mentor data engineering and development teams.

Required Skills

• 10+ years of experience in data architecture, data engineering, database development, or related roles.
• Strong experience with enterprise data architecture and data modeling.
• Expertise in SQL and relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
• Strong knowledge of ETL/ELT and data integration.
• Experience designing Data Warehouse, Data Lake, and Lakehouse architectures.
• Strong experience with at least one major cloud platform: AWS, Azure, or Google Cloud Platform.
• Hands-on experience with modern cloud data platforms such as Snowflake, Databricks, Redshift, BigQuery, or Azure Synapse.
• Experience with Python, Spark, or similar data processing technologies.
• Strong understanding of data governance, data security, metadata, data quality, and data lineage.
• Experience with enterprise-scale data migration and modernization projects.
• Strong knowledge of dimensional modeling, star/snowflake schemas, and normalization/denormalization.
• Excellent troubleshooting, analytical, communication, and problem-solving skills.

Preferred Qualifications

• Experience with Snowflake and Databricks.
• Experience with Apache Spark / PySpark.
• Experience with real-time/streaming technologies such as Kafka.
• Experience with AWS, Azure, and Google Cloud Platform multi-cloud environments.
• Experience with Data Governance and Master Data Management (MDM).
• Experience with tools such as Collibra, Alation, Informatica, or Microsoft Purview.
• Knowledge of Data Mesh and Data Fabric architectures.
• Experience with CI/CD, DevOps, and Infrastructure as Code.
• Experience with AI/ML data platforms and analytics environments.