Demo

Senior Data Engineer (Snowflake) CONFIDENTIAL

Perennial Resources International
New York, NY Full Time
POSTED ON 1/22/2025
AVAILABLE BEFORE 4/22/2025

I have a full time opportunity for a Senior Data Engineer proficient in Snowflake development. This role is 3 days onsite, 2 days remote with one of our leading financial firms in Midtown Manhattan.

In this role you will work with the Global Data Manager to build high-performing cloud data platforms to meet our analytical and BI reporting needs. This role will work as a key member of a data management team to drive development, delivery, and continuous improvement of the enterprise data warehouse architecture in support of our cloud data strategy.

The role requires solid development experience in cloud data warehousing and modern data engineering technologies. The successful candidate will have experience in building a scalable cloud data platform using best practices and data warehouse principles. This person must understand business requirements and work closely with stakeholders to convert business requirements into technical solutions. This is a hands-on engineering role requiring extensive data engineering and advanced data analytical skills, as well as the ability to provide mentorship and guidance to junior resources.

Essential Functions :

  • Translate business requirements into data model design and technical solutions.
  • Mentor and guide the work of junior database developers and analysts.
  • Develop high-performing, secure ELT / ETL processes to transform and integrate source data from internal and external systems to the cloud data warehouse.
  • Maintain data warehouse and dat pipeline processes, including troubleshooting issues, performance tuning, and implementing data quality improvements.
  • Develop a framework for data validation rules and reports to ensure data quality and control.
  • utomate standard code deployment and production release processes, adhering to change management processes.
  • Create high-quality technical documentation, including data mapping, data processes, and operational support guides.
  • Provide guidance on effective use of the data warehouse platform and facilitate BI reporting and data science model development.
  • Troubleshoot process and data issues, investigate user questions, and identify solutions to resolve issues.
  • Work in a fast-paced, dynamic environment and perform effectively in an agile development environment.

Skills :

  • 3 years of hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.
  • Experience in data modeling tools (e.g. Erwin, ER / Studio, etc.) and data modeling methodologies such as data vault and dimensional data models.
  • 5 years of strong technical experience in building scalable data pipelines to integrate structured and unstructured data in both cloud and on-premise environments.
  • 8 years of overall experience in data warehousing, advanced database design, SQL, stored procedures, views, performance tuning and optimization, database indexing techniques, and database maintenance.
  • Understanding of data security and cloud security methodologies, and experience in configuration and management of data security to meet compliance and IT security requirements.
  • Experience using Airflow or similar tools for developing scheduling and monitoring batch-oriented workflows.
  • Working knowledge of Microsoft Power BI and Tableau.
  • Experience with SDLC processes, agile development, and source code repositories (e.g. Git or Bitbucket).
  • Experience in AWS services, related data and storage services is a plus.
  • Working knowledge of Salesforce or other CRM systems is a plus.
  • Understanding of micro services architecture and methodology is a plus.
  • Excellent communication, organization, and problem-solving skills.
  • Education & Experience :

  • 8 years in in data engineering and data warehouse engineering in cloud environment.
  • Experience with Snowflake needed.
  • Experience with agile development is a plus.
  • Domain expertise with financial services is a plus.
  • Bachelor's degree in computer science, data science, or related field.
  • Successful candidates will be self-motivated with a strong desire to contribute to the success of the department and company.
  • dditional Information :

  • Hybrid role with requirement to be in New York office 3 days a week.
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Data Engineer (Snowflake) CONFIDENTIAL?

    Sign up to receive alerts about other jobs on the Senior Data Engineer (Snowflake) CONFIDENTIAL career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Perennial Resources International

    Perennial Resources International
    Hired Organization Address Newark, NJ Full Time
    Job Details Senior Project Manager New Jersey Full Time (OnSite) Our client seeks an experienced project manager to lead...
    Perennial Resources International
    Hired Organization Address Rutherford, NJ Full Time
    Underwriting Assistant for a major P&C Insurance company to join their team in East Rutherford, NJ. 3 days in office / 2...
    Perennial Resources International
    Hired Organization Address New York, NY Full Time
    As a Talent Acquisition Specialist, you will play a key role in supporting the growth and diversification of our firm. Y...
    Perennial Resources International
    Hired Organization Address Denville, NJ Full Time
    Intermediate-level Software .NET Developer Clever Devices' vision is to make meaningful contributions to worldwide mobil...

    Not the job you're looking for? Here are some other Senior Data Engineer (Snowflake) CONFIDENTIAL jobs in the New York, NY area that may be a better fit.

    AI Assistant is available now!

    Feel free to start your new journey!