Sr Snowflake Archite....
Sr Snowflake Architect
Posted on :
31-08-2023
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2203616
WHO WE ARE
Nextphase.ai is a Data Management solution provider focused on Data Operations services for enterprise data in the cloud. We are leading the innovation agenda with our clients by delivering a portfolio of services to help them improve data quality and manage data governance for their cloud data. NextPhase.ai data management services are tailored to achieve our client s business outcomes thus enabling our clients to focus on monetizing their data while we handle data operations. Nextphase.ai provides you with a dynamic and fun work environment and encourages you to use creative thinking to solve client challenges.
Nextphase.ai is a Data Management solution provider focused on Data Operations services for enterprise data in the cloud. We are leading the innovation agenda with our clients by delivering a portfolio of services to help them improve data quality and manage data governance for their cloud data. NextPhase.ai data management services are tailored to achieve our client s business outcomes thus enabling our clients to focus on monetizing their data while we handle data operations. Nextphase.ai provides you with a dynamic and fun work environment and encourages you to use creative thinking to solve client challenges.
THE ROLE
We are looking for a Data Architect in a consulting capacity to support our customer based out of the SF Bay Area, CA. The individual will be part of the Data Management team that is responsible for data warehouse architecture, administration, and integrations supported by IT across the go-to-market organization. The right candidate has empathy, curiosity, and desire to improve and constantly learn; has technical experience in all the capabilities of cloud-based data warehouse (AWS Redshift or Snowflake), data transformation (DBT), and cloud-based ETL/ELT tool (Matillion or equivalent) and a proven track record of driving best practices and processes, with hands-on experience in developing ETL projects, configuration, automation, & support. This individual is responsible for designing and building performant data transformation and ETL projects working independently and in partnership with a global team of PMs, business analysts, and developers. The individual will provide vision for enhancements, and technical design, and participate in design reviews to ensure governance principles and best practices. This is a hybrid role and requires one to be in the office 3 days a week.
YOU WILL
We are looking for a Data Architect in a consulting capacity to support our customer based out of the SF Bay Area, CA. The individual will be part of the Data Management team that is responsible for data warehouse architecture, administration, and integrations supported by IT across the go-to-market organization. The right candidate has empathy, curiosity, and desire to improve and constantly learn; has technical experience in all the capabilities of cloud-based data warehouse (AWS Redshift or Snowflake), data transformation (DBT), and cloud-based ETL/ELT tool (Matillion or equivalent) and a proven track record of driving best practices and processes, with hands-on experience in developing ETL projects, configuration, automation, & support. This individual is responsible for designing and building performant data transformation and ETL projects working independently and in partnership with a global team of PMs, business analysts, and developers. The individual will provide vision for enhancements, and technical design, and participate in design reviews to ensure governance principles and best practices. This is a hybrid role and requires one to be in the office 3 days a week.
YOU WILL
- Lead and executed the Cloud Data Warehouse architecture design for Snowflake
- Lead and executed the complete ETL development lifecycle, including requirements gathering, solution design, documentation, configuration, development, testing, and deployment; take ownership of escalated or complex issues and follow through to resolution.
- Experience with dbt for data transformation including testing and documenting data in the data warehouse
- Suggest improvements inspired by ideas from the global Matillion community and the broader data engineering community.
- Follow Agile principles to projects. Conduct regular knowledge-sharing sessions with developers to drive adoption of Matillion (or equivalent ETL) based integrations
- Implement best practice and architecture recommendations to leadership
- Perform change management functions associated with large scale high-impact configurations
- Create, manage and enforce application configuration and SDLC standards.
- Hands-on role (100%) - working on critical Data Warehouse and ETL fixes, design, development and QA.
- Focus on backend systems (Matillion or equivalent ETL, AWS infrastructure, Redshift/Snowflake, dbt and Terraform).
YOU HAVE
- Experience with data architecture in AWS Cloud infrastructure Platform, Redshift, and Snowflake is required.
- Strong understanding of data warehouse concepts
- 7+ years ETL development experience with Data Warehouse, Data Engineering, or similar roles working with backend systems and large, disparate, and complex datasets.
- 5+ years of hands-on experience using Snowflake or other cloud data warehouses, coupled with SQL transformation tools like dbt or Matillion
- Experience with data transformation and ETL automation tools such as DBT is required
- Experience with infrastructure as code tools such as Terraform, or AWS CDK is required
- Develop and maintain scalable data pipelines and build new API integrations to support continuing increases in data volume and complexity.
- Very good SQL experience.
- Extensive experience working with business teams.
- Experience working with Salesforce data required.
- Clear understanding of data warehousing concepts such as Change Data Capture, and Slowly Changing Dimensions and experience in practical implementation in ETL.
- Experience using version control, Agile Project Management, and Ticketing applications - GIT, JIRA, Zendesk.
- Experience in data engineering, dimensional database design, data lake, and data warehouse.
- Experience in practicing agile methodologies, including scrum and continuous integration environments.
- Experience leading technical requirements gathering and architecting/building solutions from those requirements; working at scale by standardizing components to ship visualizations rapidly.
- Ability to work seamlessly as part of a multi-site, multicultural, development and testing team, onshore and offshore, and internal and external resources.
- Matillion Building A Data Warehouse or equivalent ETL certification is nice to have
Pay Range:$85 - $100/hr
NextPhase.ai is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
