Lead Data Engineer/Architect (Snowflake, DBT)- R01552192
Ashburn, Virginia, United States
AI & Data Engineering – AI & Data Engineering : Data Engineering /
Employee /
Hybrid
About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
BI Architect
Primary Skills
- ETL Fundamentals, Zero Copy Cloning, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures, DBT
Job requirements
- Architect and design end-to-end Snowflake solutions including landing zones, staging layers, DataMarts, and semantic layers based on Medallion architecture principles.
- Define and enforce data modeling best practices (dimensional, star, snowflake schemas) to ensure performance and scalability.
- Develop, test, and deploy Snowflake SQL scripts, stored procedures, tasks, streams, and materialized views to implement business requirements.
- Build robust, scalable ETL/ELT pipelines using Snowflake and transformation frameworks such as DBT.
- Create and maintain data ingestion workflows integrating sources like Fivetran, Azure Blob Storage, CRM, ERP, and Marketing systems.
- Perform performance tuning, query optimization, and troubleshoot data issues in Snowflake environments.
- Drive architectural standards for Snowflake development, data ingestion, transformation, and consumption.
- Collaborate with data engineering teams to implement the best practices and maintain data pipeline reliability.
- Provide technical guidance, mentorship, and code reviews for developers and engineers working on the platform.
- Define and implement data governance, security, and access control strategies leveraging Snowflake RBAC, masking policies, and data sharing capabilities.
- Ensure compliance with data privacy, lineage, and regulatory requirements.
- Continuously monitor Snowflake usage and recommend improvements for warehouse sizing, query performance, credit usage, and storage efficiency.
- Stay current with Snowflake features, cloud data trends, and marketplace offerings to drive innovation.
- Contribute to the overall data platform roadmap including AI/ML readiness and real-time analytics enablement.
- 8+ years in data architecture, engineering, or developer roles.
- 4+ years of hands-on experience architecting, developing, and optimizing Snowflake solutions.
- Strong SQL proficiency with experience writing complex queries, stored procedures, and performance tuning.
- Expertise in ELT/ETL frameworks (DBT) and data ingestion tools like Fivetran.
- Experience with orchestration tools such as Dagster, Airflow, or Prefect.
- Familiarity with Azure cloud services including Azure Blob Storage and Azure Data Factory.
- Deep understanding of modern data architecture principles (Medallion architecture, Data Vault, Data Mesh).
- Proven ability to implement data governance and security controls on Snowflake platforms.
- Snowflake Certification
- Experience with CI/CD for data platforms (Git, Terraform, dbt Cloud).
- Knowledge of Power BI integration with Snowflake.
- Exposure to AI/ML data pipelines and analytics enablement.
- Familiarity with metadata management and data lineage tools.
- Strong leadership, architectural thinking, and hands-on development skills.
- Excellent problem-solving and critical thinking abilities.
- Effective communicator capable of bridging business and technical teams.
- Ability to influence stakeholders and advocate for best practices.
- Proactive, adaptable, and results-driven mindset.
- #LI-AS1
Job Title: Snowflake Developer Lead/Architect
Location: Preferred Onsite – Virginia Beach, VA, TX, NJ (Hybrid)
Overview:
We are seeking an experienced and visionary Snowflake Lead/Architect who will also perform hands-on development to design, build, and implement our enterprise cloud data platform using Snowflake. This hybrid role combines strategic architectural leadership with active involvement in coding, data pipeline development, and platform optimization. You will help shape the foundation of our modern data architecture while directly contributing to scalable, secure, and high-performance data solutions across domains such as Marketing, Finance, and Supply Chain.
As a Snowflake Lead/Architect, you will collaborate closely with data engineers, BI developers, data governance teams, and business stakeholders to ensure architectural consistency, optimize platform performance, and maintain data integrity.
Key Responsibilities:
Architecture & Design:
Hands-On Development:
Platform Leadership & Collaboration:
Governance & Security:
Performance & Optimization:
Innovation & Roadmap:
Required Qualifications:
Preferred Qualifications:
Soft Skills:
$140,000 - $145,000 a year
Know what it’s like to work and grow at Brillio: Click here
