Data Architect Snowflake Medallion Architecture
Role details
Job location
Tech stack
Job description
We are seeking an experienced Data Architect to lead the design and implementation of enterprisescale data platforms on Snowflake with strong expertise in data modeling and medallion architecture Bronze Silver Gold layers
The role will drive endtoend data architecture governance and solution design ensuring scalable secure and businessaligned data products across domains
Key Responsibilities
1 Enterprise Data Architecture
Define and implement endtoend data architecture strategy aligned to business objectives
Design scalable secure and costefficient Snowflakebased architectures AI upskillion Status Meeting
Establish reference architecture standards and best practices for data platforms
2 Data Modeling Semantic Layer
Lead design of enterprise data models conceptual logical physical
Define dimensional models starsnowflake schema conformed dimensions and KPIs
Build and govern semantic layers for analytics BI and AI consumption
3 Medallion Architecture Ownership
Architect and define Bronze Silver and Gold layers for multiple data domains
Design data transformation frameworks STTM and reusable data products
Establish standards for
Data ingestion Bronze
Data cleansing harmonization Silver
Businessready curated datasets Gold
4 Snowflake Platform Architecture
Architect Snowflake solutions leveraging
Virtual Warehouses RBAC data sharing
Data governance and security features masking rowlevel access AI upskillion Status Meeting
Define performance scalability and cost optimization strategies
5 Data Engineering ETLELT Strategy Mandatory Tools
Define architecture for scalable ETLELT pipelines using IICS and DBT mandatory
Establish DBTbased transformation frameworks across Bronze Silver Gold layers
Design integration patterns using Informatica Intelligent Cloud Services IICS for ingestion and orchestration
Drive standardization of
Reusable pipelines
Data transformation templates
Deployment and CICD practices
6 Data Governance Security Quality
Design and implement
Enterprise data governance frameworks
Access control and approval workflows RBAC policies Data Anae Line ERR Meeting
Data lineage metadata management and data quality controls Data Anae Line ERR Meeting
Ensure compliance with data security and privacy standards
7 Stakeholder Engagement Leadership
Conduct architecture workshops requirement discovery and solution design sessions AI upskillion Status Meeting
Translate business requirements into technical architecture and implementation roadmap
Provide technical leadership and governance across multiple teams
Mentor data engineers and modelers drive architectural reviews and standards
Requirements
Do you have experience in Virtualization?, Do you have a Master's degree?, Core Experience
1015 years in Data Engineering Data Architecture
Proven experience designing largescale enterprise data platforms
Strong expertise in
Snowflake architecture and ecosystem
Data modeling dimensional semantic design
Medallion architecture implementation
Mandatory Technical Skills
Strong handson expertise in
Snowflake architecture performance tuning security
IICS Informatica Intelligent Cloud Services Data integration orchestration
DBT Data Build Tool Transformation across medallion layers
Proficiency in
SQL and advanced data transformations
Cloud platforms AWS Azure GCP
Nice to Have
Experience in enterprise data marketplace data product architecture
Exposure to
AIML enablement and Snowflake Cortex integrations Data Anae Line ERR Meeting
Metadata catalog tools Alation Collibra
Experience in largescale migration and modernization programs AI upskillion Status Meeting
Educational Qualification
Bachelors or Masters degree in Computer Science Data Engineering or related discipline
Preferred Profile Proposal Positioning
Experience designing domaindriven data products with medallion architecture
Strong exposure to enterprise governance models and operating frameworks
Proven leadership in multidomain multiteam delivery environments
Benefits & conditions
(part of Larsen and Toubro (L&T)) 3.73.7 out of 5 stars Tampa, FL $110,000 - $150,000 a year, Pulled from the full job description
- Paid parental leave
- Parental leave
- Health insurance
- 401(k) matching
- Vision insurance
- Dental insurance
- Life insurance, Variable Compensation: This position includes a bonus or variable payout component based on individual and organizational performance. Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree ("LTIM"):
Benefits and Perks:
- Comprehensive Medical Plan Covering Medical, Dental, Vision
- Short Term and Long-Term Disability Coverage
- 401(k) Plan with Company match
- Life Insurance
- Vacation Time, Sick Leave, Paid Holidays
- Paid Paternity and Maternity Leave
The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation., Compensation range: $110,000.00 to $150,000.00 per year