Data architect

Job Description

· Design and maintain the overall data platform architecture integrating Snowflake, AtScale, and dbt components

· Establish data quality frameworks and monitoring systems

· Define platform scalability and performance optimization strategies

· Design and implement Snowflake warehouse configurations and resource management policies

· Manage user access controls, roles, and security policies within Snowflake

· Optimize query performance through warehouse sizing, clustering, and partitioning strategies

· Implement data sharing and collaboration features across business units

· Monitor and control Snowflake costs through usage optimization and resource scheduling

· Design and maintain data pipeline architectures for ingestion and transformation

· Establish connection protocols between AtScale and various BI tools (Tableau, Power BI, etc.)

· Optimize query performance through aggregate tables and caching strategies

· Manage AtScale cluster configurations and scaling policies

· Implement security models that align with organizational data access requirements

dbt Development & Operations

· Design and maintain dbt project structures and development workflows

· Create and enforce dbt coding standards and documentation requirements

· Implement dbt testing frameworks for data quality validation

· Manage dbt deployment pipelines and environment promotion processes

· Design modular dbt models that support reusability and maintainability

· Establish version control and collaboration practices for dbt development teams

Integration & Data Flow Management

· Design end-to-end data pipelines connecting source systems to Snowflake via dbt transformations

· Implement data lineage tracking across all three platforms

· Create monitoring and alerting systems for data pipeline health and performance

· Establish disaster recovery and backup procedures for the integrated platform

· Design API integrations and data exchange protocols between platforms

Team Leadership & Collaboration

· Mentor and train data engineers and analysts on platform best practices

· Collaborate with data science teams to support ML/AI workload requirements

· Coordinate with DevOps teams on infrastructure automation and deployment practices

· Lead architectural review sessions and technical decision-making processes

Performance & Cost Optimization

· Monitor and optimize compute resource utilization across all platforms

· Implement cost allocation and chargeback models for different business units

· Analyze query patterns and usage metrics to identify optimization opportunities

· Design and implement automated scaling policies based on workload demands

· Establish SLA monitoring and reporting for platform availability and performance

Security & Compliance

· Implement data encryption, masking, and anonymization policies

· Ensure compliance with regulatory requirements (GDPR, HIPAA, SOX, etc.)

· Design and maintain audit trails and data access logging

· Coordinate security assessments and vulnerability management

· Establish data classification and handling procedures across all platforms

Pay Rate: $16.00-$22.00 depending on skills and experience

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

10+ years of experience in data engineering and data platform architecture, with ownership of enterprise-scale data platforms

Expert-level Snowflake experience, including backend architecture (warehouses, RBAC, resource monitors, cost controls), not just SQL development

Proven ownership of end-to-end data flow from source systems through transformation, semantic layer, and consumption in Snowflake

Deep experience designing and optimizing Snowflake performance and scalability, including warehouse sizing, clustering, concurrency, and query tuning

Demonstrated success managing Snowflake cost optimization, usage monitoring, and chargeback/showback models

Hands-on experience designing and maintaining semantic models using AtScale, including metrics, aggregates, caching, and BI integrations

Strong understanding of enterprise metric governance and hardening definitions for consistent analytical usage

Advanced experience with dbt, including project structure, modular modeling, testing, version control, and CI/CD pipelines

Ability to architect and manage complex data pipelines integrating multiple source systems into Snowflake via dbt transformations

Experience implementing data quality frameworks, monitoring, alerting, and data lineage across platforms

Strong background in platform security and governance, including access controls, data masking, encryption, and audit logging

Experience supporting AI/ML and advanced analytics workloads on Snowflake, including performance and scalability considerations

Proven architectural leadership-ability to see the big picture, design for the future, and guide platform evolution by quarter

Experience mentoring and collaborating with data engineers, analytics engineers, data science, and DevOps teams

Strong communication skills with experience working from Chennai while collaborating with US-based stakeholders during overlapping hours New architect role

Need someone from Chennai location

Architect will need to collaborate with all engineers here and work with Debbie and team with US hours

Architect responsible for entire platform

Data flow- how it moves from one source to another and ends in Snowflake

Cost optimization, performance, security

Someone who knows Snowflake and not just developing in snowflake, but someone who knows the backend of developing in snowflake too

Can look at big picture of things and think forward

Projects and goals are set by quarter

This quarter they are up to 22 different things they want to accomplish

Some are business related, and then some are platform related,

? Creating semantic models

? Hardening our metrics

? Automated anomaly detections

? Want to create a conversation AI agent for Snowflake

? Sunsetting systems

? Cost Control

L1 Interview: Sunil

L2: Debbie or someone she nominates

11am IST-12:30 IST for Sunil

Shift- 11am- 8pm ist but first 3 month may work in later shift 2pm-11pm

Targeting 30 days or less for notice

Here is intake code for Data Architect: When the REQ is ready for PZone, please copy the title: "Data Architect - INTL India"

When submitting the DEEL PPW request, please put "0fd7a3d7" as the code and EOR in the notes!