Full-Time Senior Data Architect
Bounteous is hiring a remote Full-Time Senior Data Architect. The career level for this job opening is Expert and is accepting USA based applicants remotely. Read complete job description before applying.
This job was posted 4 months ago and is likely no
longer active. We encourage you to explore more recent opportunities on our site. However, you
may still try your luck using 'Apply Now' link below. We recommend focusing on newer listings
available here.
Bounteous
Job Title
Senior Data Architect
Posted
Career Level
Full-Time
Career Level
Expert
Locations Accepted
USA
Share
Job Details
We are looking for a Senior 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 Senior Data 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.
Worked in the Healthcare domain.
Skills
FAQs
What is the last date for applying to the job?
The deadline to apply for Full-Time Senior Data Architect at Bounteous is
10th of September 2024
. We consider jobs older than one month to have expired.
Which countries are accepted for this remote job?
This job accepts [
USA
] applicants. .
Related Jobs You May Like
Lead Data Scientist
USA
3 days ago
Data Analysis
Data Engineering
Machine Learning
Stellar Health
Full-Time
Experienced
YEAR $175000 - $220000
Data Scientist
USA
3 days ago
Data Analysis
Machine Learning
Python
Wpromote
Full-Time
Experienced
YEAR $117500 - $132500
Solutions Engineer
USA
4 days ago
Data Analytics
Data Visualization
Machine Learning
NobleAI
Full-Time
Experienced
YEAR $200000 - $220000
Field Application Scientist I
West Coast / Remote
4 days ago
Customer Support
Data Analysis
Instrumentation
LGC Group
Full-Time
Entry Level
Data Scientist II
USA
4 days ago
Data Analysis
Machine Learning
Python
Oscar
Full-Time
Experienced
YEAR $131200 - $172200
Senior Data Scientist
USA
5 days ago
data modeling
Lead Scoring
Python
Goodleap
Full-Time
Senior Manager
Healthcare Data Scientist
Ann Arbor, MI
5 days ago
Communication
Problem-solving
Python
ArborMetrix
Full-Time
Experienced
YEAR $75000 - $95000
Healthcare Data Scientist - SAS Programmer
Ann Arbor, MI
5 days ago
Data Analysis
Python
SAS
ArborMetrix
Full-Time
Experienced
YEAR $85000 - $100000
Senior Data Scientist
Costa Mesa, CA
6 days ago
Cloud Computing
Data Science
Machine Learning
Experian
Full-Time
Senior Manager
Senior Data Scientist
UK
1 week ago
Algorithms
Coding
Data Analysis
StackAdapt
Full-Time
Senior Manager
Staff Data Scientist
USA
1 week ago
Data Analysis
Healthcare Data
Machine Learning
Machinify
Full-Time
Expert
YEAR $200000 - $250000
Staff Data Scientist, Guest Journey
USA
1 week ago
Causal Inference
Data Analysis
Machine Learning
Airbnb
Full-Time
Expert
YEAR $192000 - $243000