Data Platform Architect (Snowflake)

Responsibilities

• 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.
• Aid in the 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.
• Bronze, Silver, Gold, Kimball or Related Methods Dimensional Data Modeling.

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 expertise with analytics tools like Tableau, PowerBI, Looker, etc.

Why Coastal, and what we offer

• Flexible working hours with an emphasis on a life-work balance (in that order!)
• Remote flexible work; “Live by the beach, work in the Cloud,” 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.