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 Experience

• 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.)

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 opportunities
• Continuing education and certification reimbursements, specifically within the Salesforce and Snowflake ecosystems; plus occasional in-house competitions with spot bonuses
• A flexible and fun team culture! We value transparency, support, flexibility, growth, teamwork, fun, and so much more
• Frequent team and culture activities, virtual & in-person, including Lunch and Learns, Happy Hours, team-building events
• Monthly All-Hands calls to bring the company together, and an open-door leadership policy with access to mentorship and guidance
• Opportunities for accelerated growth, networking, and career guidance and support
• Trust, transparency and respect across all levels of the company

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.