Our client, a leading financial services company, is seeking a Snowflake Data Management Specialist for a Contract to Hire role. This position requires W2 candidates only. Candidates with financial services industry experience will be preferred. This is a hybrid job based in Coppell, TX. Pay range of $60-$65/hour

Job Description:

Our client is looking for a Snowflake Data Management Specialist with a minimum of 8 years of experience specializing in Analytical data warehousing. The ideal candidate will have at least 3 years of hands-on experience with Snowflake cloud warehouse and its features, along with a good understanding of cloud AWS architecture and its services.

Key Responsibilities:

  • Develop and analyze SQL and PL/SQL procedures for data integration.
  • Build ETL pipelines in and out of data warehouse using Python and Snowflake SQL, and develop scripts using Unix shell for data extraction and loading.
  • Understand logical and physical data models to support analytics and business intelligence.
  • Create SQL-based processes for building slowly changing dimension and various types of facts.
  • Perform Data Lineage Analysis, Data Profiling Mapping Integration, ETL Validation Cleansing Masking Sub setting, Profiling Archiving, Purging Virtualization, Metadata Management, Performing Unit Test, System integration test Support, UAT.
  • Engage in SQL performance tuning and root cause analysis, resolving technical issues.

Must-Have Skills:

  • Minimum 8 years of experience in Data Management and specialized in Analytical data warehousing.
  • Minimum 3 years hands-on experience with Snowflake cloud warehouse and its features.
  • Good knowledge of cloud AWS architecture and its services.
  • Experience with SQL and PL/SQL procedures for data integration.
  • Experience in ETL development using Python and Snowflake SQL, and Unix shell scripting.
  • Strong understanding of logical and physical data models.
  • Experience in Data Lineage Analysis, Data Profiling Mapping Integration, and SQL performance tuning.
  • Experience with Agile methodology and documentation using Jira.
  • Excellent verbal and written communication skills.
  • Accepted file types: pdf, txt, doc, docx, Max. file size: 4 MB.
    Please submit your resume in PDF, DOC formats only. (2MB Maximum File Size)