Capital Technology Alliance · 10 hours ago
Data Architect
Capital Technology Alliance is focused on supporting clients' Enterprise Data and Analytics Platform initiatives. The Data Architect will design and engineer a modern cloud-based data ecosystem while collaborating with stakeholders to ensure alignment with business and regulatory requirements.
Information Technology & Services
Responsibilities
Provide architectural leadership and hands-on engineering support for the Enterprise Data and Analytics Platform (EDAP)
Collaborate with business, technical, and executive stakeholders to translate business needs into scalable data and analytics solutions
Design, document, and implement cloud-based data lake, data warehouse, and Lakehouse architectures in AWS and Snowflake
Develop current-state and future-state conceptual, logical, and physical data models, including reverse engineering existing systems
Design and optimize data pipelines supporting batch, CDC, and streaming integrations using industry-standard tools
Implement data quality rules, standards, profiling, lineage, and observability across the data ecosystem
Architect and enforce data governance, metadata management, cataloging, and master data management (MDM) solutions
Design secure data access using RBAC, ABAC, PBAC, row-level, and column-level security controls
Ensure compliance with HIPAA and other regulatory requirements through encryption, masking, anonymization, and privacy controls
Support analytics, business intelligence, and data science platforms, including BI, ML, and AI capabilities
Collaborate with infrastructure and security teams to design secure, cost-optimized AWS cloud environments
Support DevOps/DataOps processes, including CI/CD, testing, monitoring, and performance optimization
Review and validate system integrator deliverables, architecture artifacts, and test plans
Participate in project meetings, documentation, status reporting, and stakeholder communications
Qualification
Required
Current data and/or analytics certification (e.g., CDMP) OR 18+ hours of relevant data and analytics training/webinars within the last three years
5+ years of experience interfacing directly with business stakeholders and explaining technical architectures and data models to non-technical audiences
6+ years of experience architecting, engineering, implementing, and supporting enterprise data warehouses, including 2+ years using Snowflake
3+ years of experience architecting and supporting cloud-based data lakes using AWS S3 and Apache-based technologies (e.g., Parquet)
2+ years of experience designing and implementing cloud-based data Lakehouse platforms such as Databricks, Snowflake, Delta Lake, Hudi, or Iceberg
10+ years of experience in data modeling (conceptual, logical, physical, ER models) and data profiling/reverse engineering; proficiency with Erwin preferred
6+ years of experience designing and engineering data pipelines using ETL, CDC, and streaming approaches with tools such as Informatica, AWS Glue, Spark, Kafka, Kinesis, or MuleSoft
6+ years of experience with SQL programming; 3+ years with Python or similar object-oriented languages; 1+ year developing AWS Lambda functions
5+ years of experience architecting and engineering relational and NoSQL databases (document, graph, key-value, columnar, vector)
3+ years of experience designing and implementing AWS cloud infrastructure for enterprise data and analytics platforms
3+ years of experience architecting data security and privacy solutions, including DLP, encryption, masking, RBAC/ABAC, and HIPAA compliance
3+ years of experience designing internal and external data sharing hubs and API-based data exchange solutions
2+ years of experience using DevOps or DataOps practices
5+ years of experience in data and analytics testing, quality assurance, and acceptance processes
3+ years of experience implementing data governance and management tools such as data quality, metadata/catalog, and lineage solutions (e.g., Collibra, Informatica, Precisely)
2+ years of experience implementing Master Data Management (MDM) solutions using tools such as Informatica MDM, Semarchy, or Reltio
4+ years of experience implementing analytics and business intelligence platforms such as Power BI, Tableau, or Qlik
2+ years of experience implementing cloud-based data science and machine learning platforms such as AWS SageMaker, SAS Viya, or Dataiku
Preferred
Experience working in healthcare, public health, or government environments
Experience supporting large-scale data modernization or enterprise analytics programs
Experience incorporating AI-assisted data engineering, monitoring, or governance capabilities
Strong documentation, presentation, and stakeholder communication skills
Experience in healthcare or public-sector data environments
Experience with Databricks, Delta Lake, Hudi, or Iceberg
Experience implementing AI/ML platforms such as AWS SageMaker or Dataiku
Knowledge of DevOps or DataOps practices
Company
Capital Technology Alliance
At Capital Technology Alliance, we are committed to pioneering the future of technology consulting.
H1B Sponsorship
Capital Technology Alliance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
Funding
Current Stage
Early StageCompany data provided by crunchbase