Salesforce Developer

Terraform Pipelines Operations Innovation Warehousing Code Review Scalability Star Schema AWS Kinesis Data Quality Apache Kafka Data Analysis Data Modeling Data Migration Apache Airflow Decision Making Data Governance Cloud Migration Amazon Redshift Logic Synthesis Data Warehousing Snowflake Schema Data Architecture Third Normal Form Advanced Analytics Performance Tuning Business Valuation Financial Services Amazon Web Services Metadata Management Technology Solutions Full Stack Development Artificial Intelligence Business Transformation SQL (Programming Language) Employee Assistance Programs Extract Transform Load (ETL) Python (Programming Language) Financial Technology (FinTech), They are seeking a strategic and hands-on Data Architect to design and implement scalable, secure, and modern data solutions across the organization. This individual will play a critical role in modernizing the data ecosystem, establishing best practices for data architecture, and building a foundation for advanced analytics, AI, and enterprise 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., 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. Related Jobs Data Architect TEKsystems

New York, NY*Remote

CI/CD DevOps Terraform Pipelines Operations Innovation Warehousing Code Review Scalability Star Schema AWS Kinesis Data Quality Apache Kafka Data Analysis Data Modeling Data Migration Apache Airflow Decision Making Data Governance Cloud Migration Amazon Redshift Logic Synthesis Data Warehousing Snowflake Schema Data Architecture Third Normal Form Advanced Analytics Performance Tuning Business Valuation Financial Services Amazon Web Services Metadata Management Technology Solutions Full Stack Development Artificial Intelligence Business Transformation SQL (Programming Language) Employee Assistance Programs Extract Transform Load (ETL) Python (Programming Language) Financial Technology (FinTech)

• 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.

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 growing financial technology (FinTech) organization focused on delivering innovative data, analytics, and technology solutions that support decision-making across the financial services industry. They are investing heavily in modern cloud-based data capabilities and AI-driven initiatives to enhance their products and internal operations., 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.