Bounteous is hiring a
Senior Data Architect, Remote - United States

Summary

The job is for a Senior Data Architect at Bounteous x Accolite, a company offering services in various digital areas. The role involves developing data models using Snowflake and AWS, expanding and optimizing data pipelines, and providing input on implementation and administration methodologies to management.

Requirements

• 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

Responsibilities

• Develop, optimize, and oversee the company’s logical, conceptual, and physical data model
• Expand, optimize, and monitor our expanding data pipelines through meticulous architecting, intelligent business logic, consistent data governance, testing, and continuous delivery

Preferred Qualifications

• Certified Snowflake cloud data warehouse Architect
• Worked in the Healthcare domain

Benefits

Bounteous x Accolite is willing to sponsor eligible candidates for employment visas