Snowflake Engineer

We are seeking an experienced Enterprise Snowflake Engineerto lead the design development and optimization of scalable data solutions using the Snowflake Data Cloud. This role involves working across teams to build robust data pipelines ensure data integrity and security and support enterprise-wide analytics and reporting initiatives.

Required Skills:
Candidate must be located within commuting distance of Dallas TX/Tampa FL/New Jersey NJor be willing to relocate to the area. This position may require travel to project locations.
Bachelors degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
Overall 7 years of experience 4 years of experience in data engineering or cloud data solutions on Azure GCP etc.
Role requires deep expertise in Snowflake architecture SQL optimization and data modeling as well as hands-on experience with GCP BigQuery schemas UDFs and partitioning strategies.
Engineer will be responsible for translating query logic optimizing performance and ensuring data integrity throughout the migration.
Familiarity with orchestration tools (e.g. Airflow dbt) secure data sharing and compliance with financial data governance standards is essential.
Design scalable data models optimized for Snowflakes cloud-native architecture including use of virtual warehouses clustering keys and materialized views.
Collaborate with data engineers and architects to implement models that support real-time analytics fraud detection and risk management.
Ensure data quality and consistency across diverse financial systems such as trading platforms customer onboarding and compliance tools.
Integrate structured and semi-structured data (e.g. JSON XML) using Snowflakes native capabilities to support complex financial reporting.
Document data lineage and metadata to support auditability and transparency for internal and external stakeholders.
Optimize data storage and query performance using Snowflake-specific features like automatic clustering and query profiling.
Support data governance initiatives by aligning models with enterprise data catalogs stewardship policies and access controls.
Collaborate with business analysts and compliance teams to translate financial reporting needs into robust data structures.
Continuously refine models based on evolving financial products market conditions and regulatory changes.

Preferred Skills:
Certified SnowPro Advanced: Architect
Proficiency in Python for data manipulation and automation.
Experience with Snowflake features like Snowpipe Streams Tasks and Time Travel.
Understanding of data governance frameworks and compliance standards.
Strong understanding offinancial services workflows including Collateral Management and Corporate Action.
Excellent communication and stakeholder engagement skills.

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone email or face to face. Travel may be required as per the job requirements.

The estimated annual compensation range for candidates in the New Jersey NJ location will be: $93713- $135386

Along with competitive pay as a full-time Infosys employee you are also eligible for the following benefits:-
Medical/Dental/Vision/Life Insurance
Long-term/Short-term Disability
Health and Dependent Care Reimbursement Accounts
Insurance (Accident Critical Illness Hospital Indemnity Legal)
401(k) plan and contributions dependent on salary level
Paid holidays plus Paid Time Off