Data Architect

BlueMatrix; United States; On-site; USD 140,000 - 180,000; Full time

Job summary

BlueMatrix in the United States is seeking a strategic and hands-on Data Architect to design scalable data solutions in the cloud. You will modernize our data ecosystem using dbt, build real-time analytics foundations, and enable enterprise-scale reporting across the organization.

You will lead data platform evolution on AWS (S3, Glue, Redshift, Kinesis), set data governance standards, mentor engineers, and collaborate with product and engineering teams to align data with business goals.

Qualifications

• 8+ years in data architecture with end-to-end ownership of a modern data platform.
• Expertise in data modeling (3NF, star), ELT/ETL design, and performance tuning.
• Solid understanding of AWS services (S3, Glue, Lambda, Redshift, Kinesis).
• Strong SQL and Python; CI/CD and data testing in dbt.
• Knowledge of governance, lineage, metadata management, and data quality.
• Experience with streaming technologies (Kafka, Kinesis) and large datasets.
• Experience modernising platforms and migrations while keeping live systems.
• Documentation, observability, data quality and testing as default.
• Sets patterns and standards across application teams.
• Works across engineering and business.

Responsibilities

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

Skills

SQL

Python

ELT/ETL design

dbt

Data modeling

Data governance

Streaming tech

Kinesis/Kafka

CI/CD

Tools

Airflow

Terraform

Great Expectations

Monte Carlo

AWS services

Job description

About the Role:

We're 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.
• 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.

Qualifications

• 8+ years in data architecture, with deep experience owning a modern data platform end to end: pipelines, storage, modelling, governance, monitoring.
• Expertise in data modeling (3NF, star), 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.
• Has modernised platforms and run migrations while keeping live systems running.
• Brings documentation, data quality, observability and testing as a default while balancing scalability, performance, maintainability and cost.
• Designs architecture and makes the technology calls, not just implements them. Sets common patterns and standards across application teams.
• Works comfortably across both engineering and business.

Preferred Skills

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

About the Company:

The BlueMatrix team is made up of ambitious and passionate people who have turned technology development and client service into an art. Many have dedicated the majority of their career to growing the BlueMatrix brand and helping shape the investment research marketplace.

With locations in Toronto, New York City, Durham, London, Edinburgh, and Timisoara, Romania, we collaborate across the globe for a unique perspective on the impact of technology in our industry.

BlueMatrix develops one-of-a-kind web applications for the authoring, distribution, and analysis of investment research, and for internal knowledge management and digital communications. Our mission is to streamline the publishing process on a global scale.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.