Snowflake Data Architect - R01541483

About Brillio:

Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.

Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Snowflake Architect

Location: Remote - EST working hours

Need an experienced Snowflake Architect with a strong background in Data Warehousing, AWS cloud services, and cloud-based Enterprise Data Warehouse (EDW) solutions. The ideal candidate will have a minimum of 10 years of industry experience, with at least 4 years specifically focused on Snowflake, and will play a pivotal role in designing, implementing, and managing data solutions that align with our business objectives.

Key Responsibilities:

· Architect and Design Data Solutions: Lead the design and architecture of Snowflake-based data warehouse solutions on AWS. Ensure that data models, ETL/ELT processes, and overall architecture align with business needs and best practices.

· AWS Integration: Leverage AWS services, including S3, Lambda, Redshift, Glue, and others, to design and optimize data pipelines and storage solutions within the Snowflake environment.

· Data Modeling and ELT: Develop and implement data models using Snowflake, leveraging Snowpipe for automated data ingestion and developing stored procedures. Ensure efficient data transformation and integration processes.

· Snowflake Expertise: Utilize Snowflake features such as resource monitors, RBAC controls, virtual warehouses, query performance tuning, Zero Copy Clone, and time travel to optimize data warehousing processes.

· ETL Tool Management: Hands-on experience with ETL tools, preferably Matillion, to manage and streamline the data integration process across various data platforms, including structured, semi-structured, and unstructured data.

· Cloud-Based Solutions: Implement cloud-based EDW solutions on AWS, ensuring seamless data movement and integration strategies that support multiple data platforms within the Snowflake environment.

· AWS Best Practices: Ensure that Snowflake implementations on AWS adhere to best practices in terms of security, scalability, and cost-efficiency.

· Ongoing Optimization: Continuously update and refine modeling principles, processes, and solutions to ensure alignment with evolving business needs and best practices.

· Project Leadership: Lead the development of project requirements for end-to-end data integration processes, collaborating with cross-functional teams to deliver robust and scalable data solutions.

Qualifications:

· Experience: 10 years of industry experience with a focus on Data Warehousing, including a minimum of 4 years working with Snowflake.

· AWS Experience: Extensive experience with AWS cloud services, including S3, Lambda, Redshift, Glue, and others, in the context of data warehousing and integration.

· Education: Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent practical experience.

Technical Skills:

• Deep understanding of relational and NoSQL data stores, including star and snowflake schemas, and dimensional modeling.

• Experience in designing and building data pipelines using Snowpipe.

• Proficiency in SnowSQL for developing stored procedures and writing queries for data analysis and transformation.

• Expertise in Snowflake data modeling, ELT processes, and standard DWH and ETL concepts.

• Preferred Tools: Hands-on experience with ETL tools, with a preference for Matillion.

Personal Attributes:

• Strong problem-solving skills with a focus on innovative and efficient solutions.

• Excellent communication and leadership abilities to guide teams and influence stakeholders.

• Ability to adapt to changing business needs and continuously improve processes.

Know more about:

DAI: https://www.brillio.com/services-data-analytics/

Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/

Equal Employment Opportunity Declaration

Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.

· #LI-CH1

Know what it’s like to work and grow at Brillio: Click here