Data Architect

Description 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. 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. Required Skills & Qualifications • 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 Managing data movement across multiple disparate systems 2. Product Mindset & Business Partnership What that includes: Translating business requirements into solutions Working directly with product leaders and founders Making tooling and platform decisions Balancing speed, usability, and scalability Contributing to roadmap decisions 3. Adaptability, Ownership & Stakeholder Management What that includes: Operating with minimal structure Working with outsourced vendors Navigating competing stakeholder priorities High autonomy and accountability Comfort in ambiguity and rapid change Experience Level Intermediate Level Job Type & Location 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 This is a fully remote position. Application Deadline This position is anticipated to close on Sep 7, 2026. About TEKsystems 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. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. About TEKsystems and TEKsystems Global Services 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. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records. Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.