Data Architect

TEKsystems • New York, NY

22d • $170,000 - $200,000 • Remote

About The Position

Our client is a financial technology company that powers how investment research is created, distributed, consumed, and analyzed. Trusted by many of the world's leading financial institutions, they are building next-generation, AI-enabled platforms that sit at the intersection of capital markets, data, analytics, and research intelligence. They are 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.

Requirements

• 8+ years in data architecture, with deep experience in cloud-based data platforms.
• 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.

Nice To Haves

• Experience in platform modernization and cloud migration projects.
• Familiarity with tools like Airflow, Terraform, Great Expectations, or Monte Carlo.

Responsibilities

• Architect and evolve our data platform 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.

Benefits

• Medical - BCBS Anthem - EE, EE+Child & Family Coverage Options (7 different plans)
• Dental - Aetna
• VSP-Choice Vision Plan - 100% Employer Paid
• Retirement - Vanguard - employer match up to 5% after 6 months of employment
• Travel Assistance - Chubb
• LTD Basic 50% $1,000/mo-180
• Basic Life Insurance $50k
• HSA/FSA - Optum
• EAP - ADP

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed