Data Platform Architect (Snowflake)

Data Platform Architect (Snowflake) We are looking for a Data Platform Architect to help us support our continued growth. The Solution Architect is responsible for owning the overall design of the technical solution as well as recommending best practice solutions based on client needs. They provide technical guidance to the development of Salesforce.com and other SaaS applications to support business and product strategies. A Data Platform Architect facilitates discovery sessions to understand client processes and challenges and translates findings into technical requirements supported by a documented solution design. They provide thoughtful leadership and communication to project and client team members in order to build the foundation as a trusted partner.Responsibilities Data Architecture Design:Develop and implement data architectures that align with business needs and leverage Snowflake’s capabilities for data warehousing, data lakes, and data engineering.Design and implement data solutions that address specific business needs, such as BI, ETL, and AI/ML.Assist with migration of data from legacy systems to Snowflake.Ensure data accessibility, security, and compliance with relevant regulations and industry standards.Data Modeling & Pipeline Design:Design and implement data pipelines for ingesting, transforming, and loading data into Snowflake from various sources.Design and implement data models within Snowflake, considering data relationships, data types, and storage requirements.Monitor and optimize query performance, data ingestion, and transformation processes within the Snowflake environment.Technical Leadership and Collaboration:Collaborate with stakeholders, including business users, data engineers, data scientists, and other IT teams, to understand requirements and deliver solutions.Evaluate and select appropriate tools and technologies for data integration, transformation, and analytics within the Snowflake ecosystem.Provide technical leadership and guidance to data engineering and data analytics teams.Required Skills, Education and Experience5+ years experience in solutions architecture/technical consulting for cloud data platforms with multiple workstreamsDeep understanding of Snowflake Architecture & CapabilitiesPassionate about Data Modernization Methods and PracticesStrong expertise in dbtBroad range of experience in large-scale database and data warehousing technology, like Snowflake or Databricks, as well as ETL processes, analytics and cloud technologies, Data Engineering, Data ScienceStrong verbal and presentation abilities, capable of effectively communicating ideas to clients and prospective clients at all levels of an organizationUnderstanding & ability to articulate the relationship between Data and Customer Relationship Management, aka the Customer360Demonstrable ability to shift clients to alternative solutions when initial solutions are not a fit, with examples to support this. Demonstrable experience leading strategy and digital roadmap projects in a complex business environmentExperience with Data Warehouses, Data Lakes, Cloud Technology, Business Intelligence and CRM productsExperience in programming languages such as Javascript, Python, and SQL or Salesforce App Development with LWCs, Apex, Flow etcDeep Understanding of Architecture Patterns and API management, including real-time streamingDimensional Data Modeling Bronze, Silver, Gold, Kimball or Related MethodsMust have full-time permanent US work authorizationAdditional RequirementsBachelor’s Degree preferred, or equivalent experienceImplementation or Sales Experience in Salesforce Data CloudHands on Experience on Salesforce CRM technology like Sales Cloud, Service Cloud or any Industry CloudsHands on Experience in AI/ML solutions like Einstein, Sagemaker, and Vertex. Solid Understanding of Generative AI.Hands on Experience designing data solutions on cloud platforms like Amazon Web Services, Microsoft Azure or Google Cloud Platform.Hands-on expertise with analytics tools like Tableau, PowerBI, Looker, etcExperience will be evaluated based on alignment to the core competencies for the role (e.g. extracurricular leadership roles, military experience, volunteer work, etc.)Why Coastal, and what we offer:Flexible working hours with an emphasis on a life-work balance (in that order!)Remote flexible work; plus company office locations in Palm Coast, FL; Atlanta, GA; Tysons, VA & Lexington, KY; travel as required to client locations Unlimited Paid Time Off (RTO), 401K with Company Match, and Medical, Vision, & Dental coverage Competitive quarterly bonus opportunitiesContinuing education and certification reimbursements, specifically within the Salesforce and Snowflake ecosystems; plus occasional in-house competitions with spot bonusesA flexible and fun team culture! We value transparency, support, flexibility, growth, teamwork, fun, and so much moreFrequent team and culture activities, virtual & in-person, including Lunch and Learns, Happy Hours, team-building eventsMonthly All-Hands calls to bring the company together, and an open-door leadership policy with access to mentorship and guidanceOpportunities for accelerated growth, networking, and career guidance and supportTrust, transparency and respect across all levels of the companyCoastal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Data Platform Architect (Snowflake)

We are looking for a Data Platform Architect to help us support our continued growth. The Solution Architect is responsible for owning the overall design of the technical solution as well as recommending best practice solutions based on client needs. They provide technical guidance to the development of Salesforce.com and other SaaS applications to support business and product strategies. A Data Platform Architect facilitates discovery sessions to understand client processes and challenges and translates findings into technical requirements supported by a documented solution design. They provide thoughtful leadership and communication to project and client team members in order to build the foundation as a trusted partner.Responsibilities Data Architecture Design: Data Modeling & Pipeline Design: Technical Leadership and Collaboration: Required Skills, Education and Experience Additional Requirements Why Coastal, and what we offer:Flexible working hours with an emphasis on a life-work balance (in that order!)Remote flexible work; plus company office locations in Palm Coast, FL; Atlanta, GA; Tysons, VA & Lexington, KY; travel as required to client locations Unlimited Paid Time Off (RTO), 401K with Company Match, and Medical, Vision, & Dental coverage Competitive quarterly bonus opportunitiesContinuing education and certification reimbursements, specifically within the Salesforce and Snowflake ecosystems; plus occasional in-house competitions with spot bonusesA flexible and fun team culture! We value transparency, support, flexibility, growth, teamwork, fun, and so much moreFrequent team and culture activities, virtual & in-person, including Lunch and Learns, Happy Hours, team-building eventsMonthly All-Hands calls to bring the company together, and an open-door leadership policy with access to mentorship and guidanceOpportunities for accelerated growth, networking, and career guidance and supportTrust, transparency and respect across all levels of the companyCoastal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Why Coastal, and what we offer:Flexible working hours with an emphasis on a life-work balance (in that order!)Remote flexible work; plus company office locations in Palm Coast, FL; Atlanta, GA; Tysons, VA & Lexington, KY; travel as required to client locations Unlimited Paid Time Off (RTO), 401K with Company Match, and Medical, Vision, & Dental coverage Competitive quarterly bonus opportunitiesContinuing education and certification reimbursements, specifically within the Salesforce and Snowflake ecosystems; plus occasional in-house competitions with spot bonusesA flexible and fun team culture! We value transparency, support, flexibility, growth, teamwork, fun, and so much moreFrequent team and culture activities, virtual & in-person, including Lunch and Learns, Happy Hours, team-building eventsMonthly All-Hands calls to bring the company together, and an open-door leadership policy with access to mentorship and guidanceOpportunities for accelerated growth, networking, and career guidance and supportTrust, transparency and respect across all levels of the companyCoastal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Why Coastal, and what we offer: Coastal provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

• 5+ years experience in solutions architecture/technical consulting for cloud data platforms with multiple workstreams
• Deep understanding of Snowflake Architecture & Capabilities
• Passionate about Data Modernization Methods and Practices
• Strong expertise in dbt
• Broad range of experience in large-scale database and data warehousing technology, like Snowflake or Databricks, as well as ETL processes, analytics and cloud technologies, Data Engineering, Data Science
• Strong verbal and presentation abilities, capable of effectively communicating ideas to clients and prospective clients at all levels of an organization
• Understanding & ability to articulate the relationship between Data and Customer Relationship Management, aka the Customer360
• Demonstrable ability to shift clients to alternative solutions when initial solutions are not a fit, with examples to support this. Demonstrable experience leading strategy and digital roadmap projects in a complex business environment
• Experience with Data Warehouses, Data Lakes, Cloud Technology, Business Intelligence and CRM products
• Experience in programming languages such as Javascript, Python, and SQL or Salesforce App Development with LWCs, Apex, Flow etc
• Deep Understanding of Architecture Patterns and API management, including real-time streaming
• Dimensional Data Modeling Bronze, Silver, Gold, Kimball or Related Methods
• Must have full-time permanent US work authorization

Additional Requirements

• Bachelor’s Degree preferred, or equivalent experience
• Implementation or Sales Experience in Salesforce Data Cloud
• Hands on Experience on Salesforce CRM technology like Sales Cloud, Service Cloud or any Industry Clouds
• Hands on Experience in AI/ML solutions like Einstein, Sagemaker, and Vertex. Solid Understanding of Generative AI.
• Hands on Experience designing data solutions on cloud platforms like Amazon Web Services, Microsoft Azure or Google Cloud Platform.
• Hands-on expertise with analytics tools like Tableau, PowerBI, Looker, etc
• Experience will be evaluated based on alignment to the core competencies for the role (e.g. extracurricular leadership roles, military experience, volunteer work, etc.)