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 using Snowflake 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.
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/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.
- 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.
- Experience in platform modernization and cloud migration projects.
- Familiarity with tools like Airflow, Terraform, Great Expectations, or Monte Carlo.
Preferred Skills:
Skills Required
- 8+ years of experience in data architecture
- Deep experience owning a modern data platform end to end, including pipelines, storage, modeling, governance, and monitoring
- Expertise in data modeling, including 3NF and star/snowflake schemas
- Experience designing ELT/ETL processes and performance tuning
- Solid understanding of AWS services, including S3, Glue, Lambda, Redshift, and Kinesis
- Strong programming skills 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 with streaming technologies such as Kafka and Kinesis
- Experience working with large-scale datasets
- Experience modernizing platforms and running migrations while maintaining live systems
- Experience establishing documentation, data quality, observability, and testing practices
- Ability to define architecture, make technology decisions, and establish common patterns and standards
- Ability to work across engineering and business stakeholders
- Experience with platform modernization and cloud migration projects
- Familiarity with Airflow, Terraform, Great Expectations, or Monte Carlo
What We Do
At BlueMatrix, we empower investment professionals with unique technology solutions to seamlessly author, distribute, consume, and evaluate investment research. Our clients range from leading international investment banks and wealth-management firms to independent research boutiques. BlueMatrix applications offer research productivity and compliance solutions for both sell-side and buy-side companies. The benefits of our systems include compliance oversight, company profiles, entitlements and internal readership statistics. At the company, we believe our success is contingent on maintaining close relationships with clients, allowing us to provide individually tailored solutions, and we place a premium on accountability, neutrality, and transparency. BlueMatrix is headquartered in New York City with offices located in Durham, NC; London; Edinburgh; and Timișoara, Romania. Follow BlueMatrix on Linkedin for an inside look at the company and what its like to work here.
