Jobs
>
Charles City

    Snowflake Data Architect - Charles City, United States - Bounteous

    Bounteous
    Bounteous Charles City, United States

    3 weeks ago

    Default job background
    Description


    We are looking for a Snowflake Data Architect who will perform mission-critical duties in our data engineering strategy, contributing to and leading the development of our Enterprise Data and Analytics Platforms.

    A passionate professional who can blend the ever-evolving technology landscape of Cloud and Advanced Analytics with responsibilities to provide input on implementation and administration methodologies to management.

    The Snowflake Architect will mainly be responsible for developing, optimizing, and overseeing the company's logical, conceptual, and physical data model and providing recommendations.

    This role will be responsible for expanding, optimizing, and monitoring our expanding data pipelines through meticulous architecting, intelligent business logic, consistent data governance, testing, and continuous delivery.

    Please note this is a consulting role and has 50% travel expectations and a preference for residing in CST or EST for ease of syncing with the offshore team.

    Responsibilities
    Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling).
    Experience with data security and data access controls and design in Snowflake.
    Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning and database optimization techniques.
    Must have expertise in AWS Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.

    Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.

    Make necessary ongoing updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with the business needs of the environment.

    Act as Data domain expert for Snowflake in a collaborative environment to provide a demonstrated understanding of data management best practices and patterns.

    Experience in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS

    5+ years of experience building Snowflake Data Warehouse solutions from scratch by leading discovery, analysis, architecture, design, and development of Snowflake Data Warehouse and Business Intelligence solutions to meet business requirements.

    Collaborate with stakeholders to gather requirements and translate them into technical specifications.
    Implement data modeling and schema designs optimized for Snowflake.
    Configure and optimize Snowflake performance, including data loading, querying, and storage optimization.
    Ensure data quality and consistency across the data warehouse.
    Provide guidance and support to developers and analysts on Snowflake usage and best practices.
    Stay current with Snowflake updates, features, and industry trends to continuously improve our data warehouse solutions.
    Participate in troubleshooting and resolution of issues related to the Snowflake data warehouse.
    Build Data Flows mapping Source systems and Process flows
    Build Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layers
    Build a denormalized Data Model with Dimensional modeling to meet customer analytics and performance criteria
    Build an optimal data pipeline approach to extract data to Snowflake
    Experience in delivering ELT solutions using tools like Matillion, Fivetran, and Informatica and understanding the competitive ETL space in cloud data warehousing
    Understanding of reporting systems such as Tableau, PowerBi, and Qlik.

    Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero-copy clone, time travel, and automating them.

    Experience in handling semi-structured data (JSON, XML), and columnar PARQUET using the VARIANT attribute in Snowflake.
    Experience in re-clustering the data in Snowflake with a good understanding of Micro-Partitions.
    Experience in Migration processes to Snowflake from an on-premises database environment.
    Design and Develop automated monitoring processes on Snowflake using a combination of Python, PySpark, and Bash with SnowSQL.
    Experience with data security and data access controls and design in Snowflake.
    Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modeling).

    Act as Data domain expert for Snowflake in a collaborative environment to provide a demonstrated understanding of data management best practices and patterns.

    Give coaching and guidance to team members and data analysts across the Business Unit.
    Excellent written and verbal communication skills
    Strong understanding of business KPIs and go-to-market engines.
    Nice to have.
    Certified Snowflake cloud data warehouse Architect.
    I have flexibility to create happiness and harmony.

    Our working environment, plus the ability to work remotely, has eliminated the Sunday Scaries that plagued me for decades in my career.

    I actually say "Happy Monday" on my calls.
    Brooke Rye
    Project Manager
    I have flexibility to create happiness and harmony.

    Our working environment, plus the ability to work remotely, has eliminated the Sunday Scaries that plagued me for decades in my career.

    I actually say "Happy Monday" on my calls.
    Brooke Rye
    Project Manager
    "
    Join our fast-growing company and take advantage of our competitive benefits and career development opportunities. Stay balanced with our health & wellness perks, collaborative culture, and take-what-you-need vacation.
    Award-Winning Culture

    Cemented in core values that fuel our creativity, ideas, collaboration, and benefits
    World-Class, Fortune 500 Engagements

    Improving experiences and business outcomes for interesting clients and well-known brands.
    Professional Growth Opportunities

    Offering time and support for ongoing learning, courses, certification, and conference opportunities.
    Flexible Working Hours

    Coordinating with clients and teams across time zones that can work around personal commitments and schedules.
    Supporting team members with benefit choices to match you or your family's needs
    Take-What-You-Need Vacation

    Empowering team members with encouraged time away from work for rest and relaxation

    #J-18808-Ljbffr
  • Databricks

    Specialist Solutions Architect

    3 weeks ago

    Databricks Charles City, United States

    As a Specialist Solutions Architect (SSA) - Data Scientist / ML Engineer, you will be the trusted technical ML expert to both Databricks customers and the Field Engineering organization. You will work with Solution Architects to guide customers in architecting production-grade ML ...

  • Databricks

    Specialist Solutions Architect

    2 weeks ago

    Databricks Charles City, United States

    As a Specialist Solutions Architect (SSA) - ML Engineering, you will be the trusted technical ML expert to both Databricks customers and the Field Engineering organization. You will work with Solution Architects to guide customers in architecting production-grade ML applications ...

  • Databricks

    Sr. Manager, Solutions Architect

    3 weeks ago

    Databricks Charles City, United States

    As a Sr. Manager, Solutions Architect, you will build and lead a team of pre-sales Solutions Architects focusing on Key Enterprise accounts. Your experience partnering with the sales organisation will help close revenue with the right approach whilst coaching new sales and pre-sa ...

  • Peloton Group

    Oracle Cloud SCM Solution Architect

    3 weeks ago

    Peloton Group Charles City, United States

    Recognized on the Inc. 5000 fastest growing companies in the US, Peloton is one of the largest and fastest growing professional services firms specializing in Integrated Cloud Solutions for Enterprise Resource Planning, Enterprise Performance Management, Supply Chain Management, ...

  • Pearson

    Solution Architect

    3 weeks ago

    Pearson Charles City, United States

    umer. Learn more at We are Pearson. · We value the power · force, navigate to: Diversity, Equity & Inclusion at Pearson. · If you are an indi · dations by emailing · Note that the info · Job Information · Workforce Skills · Solution Architect · in · United States · As a Sol ...

  • Databricks

    Adoption Architect

    2 weeks ago

    Databricks Charles City, United States

    The Product Adoption Architect for Unity Catalog will drive adoption performance and field effectiveness for Databricks Unity Catalog. They will work closely with cross-functional teams to lay out the requirements to execute on product priorities. They will also partner with the ...

  • AVEVA

    Salesforce Experience Cloud

    2 weeks ago

    AVEVA Charles City, United States

    AVEVA · Salesforce Experience Cloud - Solutions Architect · in · United States · AVEVA is a global leader in industrial software. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals and ...

  • Databricks

    Director, Field Engineering, Financial Services

    3 weeks ago

    Databricks Charles City, United States

    Director of Field Engineering, Financial Services, US · Location: NYC or East Coast · We seek a seasoned leader for the Director of Field Engineering position within the Financial Services vertical. In this role, you will lead first-line Managers and teams of pre-sales Solutions ...

  • Cardlytics

    Senior Director, Solutions Architect

    1 week ago

    Cardlytics Charles City, United States

    About Cardlytics + Bridg · About Cardlytics + Bridg · Cardlytics (NASDAQ: CDLX) is the industry-leading purchase intelligence and incentives platform. We make commerce smarter and more rewarding for everyone by helping businesses attract, understand, and incentivize consumers t ...

  • Trianz

    Oracle Net-Suite ERP Architect

    3 weeks ago

    Trianz Charles City, United States

    About Trianz · Trianz is a leading-edge technology platforms and services company that accelerates digital transformations at Fortune 100 and emerging companies worldwide in data & analytics, digital experiences, cloud infrastructure, and security. The company's "IP Led Transfor ...

  • Peloton Group

    Oracle Cloud Financials Lead

    1 week ago

    Peloton Group Charles City, United States

    Recognized on the Inc. 5000 fastest growing companies in the US, Peloton is one of the largest and fastest growing professional services firms specializing in Integrated Cloud Solutions for Enterprise Resource Planning, Enterprise Performance Management, Supply Chain Management, ...

  • Peloton Group

    Oracle ERP Cloud Financials Lead

    3 weeks ago

    Peloton Group Charles City, United States

    Recognized on the Inc. 5000 fastest growing companies in the US, Peloton is one of the largest and fastest growing professional services firms specializing in Integrated Cloud Solutions for Enterprise Resource Planning, Enterprise Performance Management, Supply Chain Management, ...

  • AtScale

    Software Engineering Manager

    2 weeks ago

    AtScale Charles City, United States

    AtScale enables smarter decision-making by unlocking data-driven insights. The company's semantic layer platform simplifies, accelerates, and extends business intelligence and data science capabilities for enterprise customers across all industries. AtScale empowers customers to ...

  • SAIC

    Senior Software Engineer

    3 weeks ago

    SAIC Charles City, United States

    SAIC · is seeking a · Senior Software Engineer . This position has the ability to be worked fully remote in the candidate's home office. · Job Duties: · Provide services for systems engineering and integration, operational engineering, software design and development, and dat ...

  • CAI

    Data Engineer

    3 weeks ago

    CAI Charles City, United States

    CAI is on the hunt for a dedicated and proficient Data Engineer to enrich our technologyefforts. As a pivotal part of our data team, you will construct and maintain the backbone of our data platform, creating the channels through which data flows seamlessly into our system. This ...

  • Databricks

    Delivery Solutions Architect

    3 weeks ago

    Databricks Charles City, United States

    While candidates in the listed locations are encouraged for this role, the team is evaluating candidates in all US time zones. (PST, MST, CST, and EST) · At Databricks we are on a mission to empower our customers to solve the world's toughest data problems by utilizing the Databr ...

  • Databricks

    Delivery Solutions Architect

    2 weeks ago

    Databricks Charles City, United States

    While candidates in the listed locations are encouraged for this role, candidates in other locations will be considered. · At Databricks we are on a mission to empower our customers to solve the world's toughest data problems by utilizing the Lakehouse platform. As a Delivery Sol ...

  • Peloton Group

    OAC/FAW Technical Lead

    3 weeks ago

    Peloton Group Charles City, United States

    Recognized on the Inc. 5000 fastest growing companies in the US, Peloton is one of the largest and fastest growing professional services firms specializing in Integrated Cloud Solutions for Enterprise Resource Planning, Enterprise Performance Management, Supply Chain Management, ...

  • Databricks

    Sr. Solutions Consultant, Healthcare

    3 weeks ago

    Databricks Charles City, United States

    As a Sr. Solutions Consultant in our Professional Services team, you will work with · customers · on short to medium term customer engagements on their big data challenges using the Databricks platform. You will be in a customer-facing role that requires deep hands-on expertise ...

  • GOES Health

    Vice President Marketing

    3 weeks ago

    GOES Health Charles City, United States

    At · GOES Health , we are leading the movement to empower everyone to enjoy the outdoors while being equipped with the knowledge, tools and support to do so safely and sustainably. It's a call to action for a future where the joy of the outdoors is embraced with health and safet ...