Sr Snowflake Developer - 2

• 5-10 years of experience in data warehousing.
• Understanding of data models and co-ordinate with Client to capture requirements.

Experience in snowflake and control M

• Data Architecture Design: Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies to effectively store and access data from various sources as per the requirements.
• Business Requirements Gathering: Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements.
• Data Integration and ETL Development: Oversee the design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format and load it into the EDW.
• Data Modeling: Create dimensional data models to optimize querying and reporting on the data within the EDW.
• Performance Optimization: Monitor and optimize the performance of the EDW to ensure efficient data access and query response times.
• Data Governance: Establish data governance policies and procedures to ensure data quality, consistency and compliance with regulations.
• Overall Technical Leader: Provide technical guidance on data warehouse technologies, tools and best practices to the relevant stakeholders.
• Collaboration with Stakeholders: Work closely with business users, data analysts and application developers to understand their data needs and deliver data-driven insights.

Tools and Technologies:

• Data Warehousing Expertise: Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modeling, star schema, snowflake schema and ETL processes.
• Database Management Systems (DBMS): Proficient in SQL and Databases like Snowflake, Oracle, SQL Server or Teradata, Control M
• Data Modeling Tools: Experience with data modeling tools like Erwin, Power Designer or other industry-standard modeling software.
• Data Integration Tools: Familiarity with data integration tools for ETL development and data cleansing.
• Communication Skills: Excellent communication skills to effectively collaborate with stakeholders from various departments.

The pay range that the employer in good faith reasonably expects to pay for this position is $41.61/hour - $65.01/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Salary : $42 - $65