Designs and leads modern, scalable data platforms using Snowflake, dbt, and AWS. Responsibilities include data modeling, batch and streaming pipelines, governance, security, privacy, migration from legacy systems, deployment automation, observability, testing, and enterprise reporting. The role collaborates with technical and business stakeholders, establishes architectural standards, mentors data engineers, and guides platform modernization while balancing performance, maintainability, scalability, and cost.
About the Role: We're seeking a strategic and hands-on Data Architect to design and implement scalable, secure, and modern data solutions across our organization. You'll play a critical role in leading the modernization of our data ecosystem using dbt, building a foundation for real-time analytics and enterprise-scale reporting in the cloud.
Responsibilities
- Architect and evolve our data platform using Snowflake as the central data warehouse and dbt for transformation logic.
- Design and implement batch and streaming pipelines, ensuring scalability and cost-efficiency in AWS.
- Establish best practices for data modeling, warehouse schema design, and semantic layer standardization using dbt.
- Define and enforce data governance, security, and privacy policies in alignment with compliance frameworks.
- Lead data migration from legacy sources to AWS; work closely with DevOps to automate and secure deployment processes.
- Collaborate with engineering, product, and business stakeholders to understand data needs and align solutions with business goals.
- Mentor and guide data engineers; support code reviews, architectural reviews, and team upskilling.
Qualifications:
- 8+ years in data architecture, with deep experience owning a modern data platform end to end: pipelines, storage, modelling, governance, monitoring.
- Expertise in data modeling (3NF, star/snowflake schemas), ELT/ETL design, and performance tuning.
- Solid understanding of AWS services (S3, Glue, Lambda, Redshift, Kinesis, etc.).
- Strong programming in SQL and Python; experience with CI/CD and data testing in dbt.
- Knowledge of data governance, lineage, metadata management, and data quality frameworks.
- Experience working with streaming technologies (Kafka, Kinesis) and large-scale datasets.
- Has modernised platforms and run migrations while keeping live systems running.
- Brings documentation, data quality, observability and testing as a default while balancing scalability, performance, maintainability and cost.
- Designs architecture and makes the technology calls, not just implements them. Sets common patterns and standards across application teams.
- Works comfortably across both engineering and business.
- Experience in platform modernization and cloud migration projects.
- Familiarity with tools like Airflow, Terraform, Great Expectations, or Monte Carlo.
Preferred Skills:
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning
Leads the architecture, design, and implementation of scalable GCP and Databricks data lakehouse platforms. Designs real-time and batch pipelines, data models, governance, cataloging, security, and performance optimization. Advises clients, translates business requirements into technical solutions, leads project teams, mentors engineers, reviews architectures, and balances strategic planning with hands-on proof-of-concept and troubleshooting work.
Top Skills:
Apache AirflowBiglakeBigQueryData CatalogDatabricksDataplexDelta LakeGoogle Cloud Platform (Gcp)Google Cloud Storage (Gcs)IamPub/SubUnity Catalog
Information Technology
Lead the architecture and implementation of enterprise-scale Azure data and AI platforms, including data lakes, lakehouses, warehouses, integrations, machine learning, and generative AI solutions. Establish governance, security, MLOps, and AI frameworks; guide cloud modernization, migration, performance, and cost optimization. Translate business needs into technical architectures, present recommendations to executives, lead architecture reviews, support client pursuits, and mentor engineering teams.
Top Skills:
Arm TemplatesAzure Ai FoundryAzure Ai ServicesAzure Data FactoryAzure Data Lake Storage Gen2Azure DatabricksAzure Kubernetes ServiceAzure Machine LearningAzure Openai ServiceAzure SqlAzure Synapse AnalyticsBicepCi/CdContainerizationDevOpsLarge Language ModelsMicroservicesAzureMicrosoft FabricMicrosoft PurviewMlopsPrompt EngineeringPysparkPythonRetrieval Augmented GenerationSparkSQLTerraformVector Databases
Information Technology • Software
Lead enterprise data architecture across multiple SaaS products by unifying reporting platforms, data models, and analytics capabilities. Assess current systems, define target-state architecture, establish data governance and quality standards, separate analytical workloads from transactional systems, and develop phased migration roadmaps. Guide database, engineering, and BI teams on cloud platforms, integration, modeling, performance, security, and reliability. Enable trusted cross-product reporting, governed self-service analytics, and data foundations for AI and advanced analytics.
Top Skills:
APIsAWSAzureBusiness IntelligenceChange Data CaptureData LakesData WarehousesEltETLGCPLakehousesMicrosoft Sql ServerPostgresSemantic ModelsSnowflakeSQL
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
