Data Architect

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.

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.

DataArchitect Data Modeling Tool, Analysis Skills, Artificial Intelligence (AI), Capital Markets, Data Analysis, Finance, DataArchitect Data Modeling Tool, Ecosystems, Cloud Computing, Information/Data Security (InfoSec), * 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.

Preferred

• Experience in platform modernization and cloud migration projects.

• Familiarity with tools like Airflow, Terraform, Great Expectations, or Monte Carlo.

Skills

Data, Python, Sql, Aws, Cloud, Data modeling

Top Skills Details

Data,Python,Sql,Aws,Cloud,Data modeling

Additional Skills & Qualifications

1. Modern Data Architecture & Pipeline Engineering

What that includes:

Designing scalable data platforms

Building and optimizing ETL/ELT pipelines

Kafka and streaming architectures

AWS data services (S3, Lambda, Glue, Redshift, etc.)

Data modeling and warehousing

This is a Permanent position based out of New York, NY. Pay and Benefits

The pay range for this position is $170000.00 - $200000.00/yr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

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 Workplace Type

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., We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.