We currently have a career opportunity for a Solutions Architect to join the Healthcare consulting team. While Perficient's headquarters are in St. Louis, MO, this role is remote and candidates can be located anywhere in the continental US.Job Overview:We are looking for a Snowflake 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 to develop, optimize and oversee company's logical, conceptual, and physical data model and provide 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.This role is considered part of the Business Unit Senior Leadership team and may mentor delivery team members.
RESPONSIBILITIES- Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling).
- 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 / Azure 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.
- Lead in Developing Project requirements for end-to-end.
- Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.
- Act as Data domain expert for Snowflake in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.
- Ability to work with business team and help them gathering all requirements based on data.
QUALIFICATIONS- 8+ years of experience implementing data management solutions (Required).
- Management consulting experience (Highly Desired).
- Experience implementing snowflake NLQ / AI features.
- Experience in defining AI use cases that can be implemented to show business value.
- Experience in doing POCs and providing technology implementation roadmap based on use cases.
- Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, Cost optimization, SQL performance tuning, zero copy clone, time travel and automating them.
- Experience in handling unstructured, structed, semi-structured data.
- Experience in Migration processes to Snowflake from on-premises database environment.
- Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
- Experience in Cloud technologies such as Azure Components, Azure Data Factory, Dbt.
- Design and develop automated monitoring processes on Snowflake using combination of Dbt, Snowflake and Azure Data Factory.
- Experience in developing stored Procedures writing Queries to analyze and transform data.
- Certified Snowflake cloud data warehouse Architect (Desirable).
- Bachelor's degree in Computer Science or related field.
Preferred skills and education:
- Master's degree in Computer Science or related field.
- Leadership and team management experience with ability to provide strategic planning and oversight.
- Experience leading customer workshop sessions to educate customers on the latest technology trends and best practices.
- Track record of leadership roles delivering solutions within defined timeframes.
- Experience working with a globally distributed team and managing off-shore teams.
The salary range for this position takes into consideration a variety of factors, including but not limited to skill sets, level of experience, applicable office location, training, licensure and certifications, and other business and organizational needs. The new hire salary range displays the minimum and maximum salary targets for this position across all US locations, and the range has not been adjusted for any specific state differentials. It is not typical for a candidate to be hired at or near the top of the range for their role, and compensation decisions are dependent on the unique facts and circumstances regarding each candidate. A reasonable estimate of the current salary range for this position is $81,978 to $178,090. Please note that the salary range posted reflects the base salary only and does not include benefits or any potential equity or variable bonus programs. Information regarding the benefits available for this position are in our benefits overview.WHO WE ARE Perficient is a leading global digital consultancy. We imagine, create, engineer, and run digital transformation solutions that help our clients exceed customers' expectations, outpace competition, and grow their business. With unparalleled strategy, creative, and technology capabilities, our colleagues bring big thinking and innovative ideas, along with a practical approach to help our clients – the world's largest enterprises and biggest brands succeed.WHAT WE BELIEVE At Perficient, we promise to challenge, champion, and celebrate our people. You will experience a unique and collaborative culture that values every voice. Join our team, and you'll become part of something truly special.We believe in developing a workforce that is as diverse and inclusive as the clients we work with. We're committed to actively listening, learning, and acting to further advance our organization, our communities, and our future leaders... and we're not done yet.Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws. Perficient, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans. Improper interference with the ability of Perficient, Inc. employees to perform their expected job duties is absolutely not tolerated.Applications will be accepted until the position is filled or the posting is removed.Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, please contact us.Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time. #LI-KD1#LI-REMOTE
ABOUT USPerficient is always looking for the best and brightest talent and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands. You'll work with the latest technologies, expand your skills, experience work-life balance, and become a part of our global community of talented, diverse, and knowledgeable colleagues.