Data Architect

DescriptionOur 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.SkillsData, Python, Sql, Aws, Cloud, Data modelingTop Skills DetailsData,Python,Sql,Aws,Cloud,Data modelingAdditional Skills & Qualifications1. Modern Data Architecture & Pipeline EngineeringWhat that includes:Designing scalable data platformsBuilding and optimizing ETL/ELT pipelinesKafka and streaming architecturesAWS data services (S3, Lambda, Glue, Redshift, etc.)Data modeling and warehousingManaging data movement across multiple disparate systems2. Product Mindset & Business PartnershipWhat that includes:Translating business requirements into solutionsWorking directly with product leaders and foundersMaking tooling and platform decisionsBalancing speed, usability, and scalabilityContributing to roadmap decisions3. Adaptability, Ownership & Stakeholder ManagementWhat that includes:Operating with minimal structureWorking with outsourced vendorsNavigating competing stakeholder prioritiesHigh autonomy and accountabilityComfort in ambiguity and rapid changeExperience LevelIntermediate LevelJob Type & LocationThis is a Permanent position based out of New York, NY.Pay and BenefitsThe 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 - ADPWorkplace TypeThis is a fully remote position.Application DeadlineThis position is anticipated to close on Sep 7, 2026.About TEKsystemsWe'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.Job SummaryJob number: JP-006261735Profession: Architect