Job description

Role: AWS Snowflake Datawarehouse Developer

Location: Remote

Duration: long term project

Full description

AWS Enterprise data platform built for the cloud that is effective, affordable, and accessible to all data users. We’re looking for a talented Datawarehouse Developer for our EDP team. In this role, you will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company. This is a strategic, high-impact role that will also help shape the future of our Hybrid AWS Platform.

Responsibilities of the Datawarehouse Developer Include:

• In this role, you will work closely with our Product, Engineering, IT, and Data Science teams to build best in class infrastructure supporting data across the company
• Design, Deploy & Monitor Multi-tenant Lakehouse environment.
• Design, Deploy the RBAC security Model in Multi-tenant Lakehouse environment.
• Design, build, and own the core data models and key infrastructure to manage data and usage across our Snowflake/Redshift account with an emphasis on Multi Tenancy and Security.
• Responsible to integrate Snowflake/Redshift Database with SAML or OpenID Provider for Authentication
• Create Snowflake/Redshift utilization and Capacity Plan for general housekeeping as well as for peak period.
• Implement Snowflake/Redshift best practices & considerations for managing load operations and performance which will aid in creating right size Snowflake/Redshift warehouses.
• Implement Data Masking policies to protect PII/PCI Data.
• Create and manage multiple accounts across the Organization.
• Good knowledge of Time Travel & Cloning
• Automate tenant onboarding to Multi-Tenant Snowflake/Redshift Platform.
• Automate RBAC Security model with Sailpoint Integration.
• Automate Internal/External Data catalog.
• Good Understanding of data replication for data sharing across accounts and for failover scenarios
• Good Understanding of Snowflake ODBC, JDBC drivers as well as SnowSQL in terms of usage as well as troubleshooting any issues
• Good Understanding of Snowflake Snowpark
• Collaborate closely with Engineering, Product Management, IT, Finance, and Compliance to inform product decision making with data and to identify opportunities for system improvements.
• Collaborate with the Engineering, IT, and Compliance team to meet data governance requirements.
• Build dashboards to help IT Leadership monitor performance and availability of our system.
• Think creatively to find optimal solutions to our complex, often unstructured problems.
• Design and implement a data quality monitoring system. The system should include source-to-target data validations as well as anomaly detection.

Candidate will have:

• 10+ years’ experience including:
• 2+ Years’ experience as Redshift DBA/Developer.
• 2+ years’ experience as Snowflake DBA.
• Designing and building complex data pipelines in a large-scale data environment.
• Experience with Salesforce, Workday, and application integrations
• Snow Pro Core Certification preferred
• Expert level Python/SQL, JavaScript and experience building Stored Procedures
• Experience in CI/CD implementation of Snowflake data Platform.
• Ability to clearly present learnings to business leaders and technical stakeholders
• The ability to thrive in a dynamic environment.

Job Type: Contract

Salary: $50.00 - $60.00 per hour

Schedule:

• 8 hour shift

Work Location: Remote

www.arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.arclintfl.com is the ideal place to find your next job.