Sr. Snowflake Data Warehouse Specialist_NJ

1 month ago

Woodbridge Township, United States Synechron Full time

About the job

Summary:

We are looking to hire Sr. Snowflake Data Warehouse Specialist with a financial background. Who will play a crucial role in leveraging Snowflake, a cloud-based data warehousing platform, to manage and analyze financial data.



Primary Responsibilities:

  • Able to provide architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse
  • Provide production support for Data Warehouse issues such data load problems, transformation translation problems.
  • Able to translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
  • Able to work on data pipelines and modern ways of automating data pipeline using cloud-based testing and clearly document implementations
  • Able to perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.
  • Able to Develop EL pipelines in and out of data warehouse using combination of Databricks, Python and SnowSQL.
  • Able to provide data ingestion and processing pipelines using Python, Databricks, SnowSql
  • Able to Establish and monitor Operational Level Agreements for the health and performance/cost of the warehouse environment (Loads, queries, data quality)



Basic Qualifications:

  • Overall 10+ years of experience is required.
  • Minimum 3 years of experience in design and implementation of large-scale data solution on Azure Snowflake Data Warehouse
  • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
  • Good experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling
  • Good knowledge of MS Azure configuration items with respect to Snowflake
  • Experience in writing scripts (UNIX, Python)
  • Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies



Good to Have:

  • Experience in Finance / Banking industry – some understanding of Securities and Banking products



We can offer you:

  • A highly competitive compensation and benefits package
  • A multinational organization with 52 offices in 20 countries and the possibility to work abroad
  • Laptop and a mobile phone
  • 10 days of paid annual leave (plus sick leave and national holidays)
  • Maternity & Paternity leave plans
  • A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
  • Retirement savings plans
  • A higher education certification policy
  • Commuter benefits (varies by region)
  • Extensive training opportunities, focused on skills, substantive knowledge, and personal development
  • On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
  • Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
  • Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
  • A flat and approachable organization
  • A truly diverse, fun-loving and global work culture



SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

  • Senior Database Administrator

    3 weeks ago

    Woodbridge Township, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Data Integration Specialist

    1 month ago

    Forks Township, United States Heller Search Associates Full time

    GENERAL SUMMARY:This position is a technical role that has the responsibility for designing and developing data integration solutions in support of our data warehouse environment and inter-system interfaces. The individual will collaborate with cross-functional teams to understand data requirements and implement data integration solution to best satisfy the...

  • Senior Database Administrator

    3 weeks ago

    Woodbridge, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Senior Database Administrator

    1 month ago

    Woodbridge Township, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Data Engineer

    1 week ago

    Meridian charter Township, United States GDI Infotech Full time

    Description:We are looking for a Data Engineer to join our Data Engineering Team. The ideal candidate should have a minimum of 3 years of experience with excellent analytical reasoning and critical thinking skills. The candidate will be a part of a team that creates data pipelines that use change data capture (CDC) mechanisms to move data to a cloud provider...

  • Senior Database Administrator

    2 weeks ago

    Woodbridge, New Jersey, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Senior Database Administrator

    1 month ago

    Woodbridge, United States Plymouth Rock Assurance Full time

    Senior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...

  • Sr. Talent Acquisition Specialist

    4 weeks ago

    Woodbridge, United States Global Data Management Full time

    Objectives of this Role Collaborate with product design and engineering to develop an understanding of needs Research and devise innovative statistical models for data analysis Communicate findings to all stakeholders Enable smarter business processes and implement analytics for meaningful insights Keep current with technical and industry...

  • Sr. Talent Acquisition Specialist

    1 month ago

    Woodbridge, Virginia, United States Global Data Management Full time

    Objectives of this Role Collaborate with product design and engineering to develop an understanding of needs Research and devise innovative statistical models for data analysis Communicate findings to all stakeholders Enable smarter business processes and implement analytics for meaningful insights Keep current with technical and industry...

  • Warehouse Manager

    2 weeks ago

    Woodbridge, United States Gobolt Full time

    **Warehouse Manager** Woodbridge, ON Founded in 2017, Bolt Technologies (Bolt) is a leading Canadian technology-enabled logistics and last-mile delivery provider for businesses of all sizes from small local e-commerce shops to large national retailers. We provide a customer-centric and sustainable approach to fulfillment, including reliable warehousing,...

  • AVP, Claims Data Solutions

    5 days ago

    Readington Township, United States CHUBB Full time

    The AVP, Claims Data Solutions will have a crucial role in the development of the innovative Global Data Platform (GDP) and in harnessing its potential to integrate actionable intelligence across various use cases.  This is a hybrid opportunity, 3 days in the office and 2 days remote. Primary Responsibilities:  Bring a distinct data consumer...

  • Warehouse Operations Coordinator

    2 weeks ago

    Woodbridge, United States International Gourmet Foods Full time

    International Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them.The Warehouse Operations Coordinator is responsible for...

  • Warehouse Operations Coordinator

    2 weeks ago

    Woodbridge, United States International Gourmet Foods Inc Full time

    International Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them. The Warehouse Operations Coordinator is responsible for...

  • Sr Electronics Technician-ITS

    2 weeks ago

    Woodbridge, Virginia, United States Virginia State Gov Full time

    Virginia State Gov JobID: sr electronics technician its prince william virginia united states [Field Technician / Maintenance Mechanic] As an Electronics Technician at the State of Virginia, you'll: Operate, troubleshoot, perform and oversee maintenance of bridge tunnel industrial plant Supervisory Control and Data Acquisition systems; Perform and oversee...

  • Warehouse Operations Manager

    1 week ago

    Woodbridge, United States International Gourmet Foods Full time

    International Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them. The Warehouse Operations Manager is responsible for...

  • Warehouse Operations Coordinator

    1 month ago

    Woodbridge, United States International Gourmet Foods Inc Full time

    Job DescriptionJob DescriptionInternational Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them.The Warehouse Operations...

  • Warehouse Operations Coordinator

    2 weeks ago

    Woodbridge, United States International Gourmet Foods Full time

    International Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them. The Warehouse Operations Coordinator is responsible for...

  • Warehouse Operations Coordinator

    2 weeks ago

    Woodbridge, United States International Gourmet Foods Inc Full time

    Job DescriptionJob DescriptionInternational Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them.The Warehouse Operations...

  • Warehouse Operations Manager

    3 days ago

    Woodbridge, United States International Gourmet Foods Full time

    International Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them. The Warehouse Operations Manager is responsible for...

  • Warehouse Operations Manager

    6 days ago

    Woodbridge, United States International Gourmet Foods Inc Full time

    Job DescriptionJob DescriptionInternational Gourmet Foods, Inc. (IGF) services restaurants, gourmet markets, clubs, caterers, bakeries, country clubs, breweries, wineries, and hotels throughout the eastern United States. We are driven by strong corporate and community values and most importantly, by the employees who uphold them.The Warehouse Operations...