54 applicants

Company

NTT DATA · 21 hours ago

Data Engineer (Matillion/Snowflake)

Portland, OR

Full-time

Remote

Senior Level, Lead/Staff

$121K/yr - $161K/yr

8+ years exp

Maximize your interview chances

Information ServicesInformation Technology

H1B Sponsor Likely

Insider Connection @NTT DATA

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Design, develop, and maintain scalable data pipelines in Snowflake, enabling efficient data ingestion, transformation, and storage - This includes building pipelines for structured, semi-structured, and unstructured data.

Leverage DBT (Data Build Tool) to define and execute complex data transformations within Snowflake - This includes creating modular SQL scripts for transforming raw data into clean, usable datasets that align with business needs. Experience in defining reusable DBT models to enforce data standards and improve productivity is crucial.

Develop, manage, and optimize ETL/ELT workflows using Matillion - This includes configuring Matillion jobs to handle data extractions, loading, and transformations while ensuring pipeline reliability, scalability, and performance. You will be expected to create complex workflows, manage dependencies, and schedule jobs using Matillion's orchestration features.

Design and implement optimized data warehousing solutions within Snowflake by leveraging multi-cluster warehouses, data partitioning, and clustering keys. You will be responsible for ensuring that data retrieval and processing are optimized for both performance and cost efficiency.

Use DBT to structure data transformations efficiently, building incremental models to handle large datasets. You will apply performance tuning techniques, such as query optimization, caching, and materialized views, to ensure the Snowflake environment remains performant as data scales.

Monitor and troubleshoot Matillion workflows to ensure that ETL/ELT processes are executing correctly and efficiently, making necessary adjustments to improve performance.

Collaborate with data architects, analysts, and other stakeholders to design data models and pipelines that align with business goals and adhere to best practices. You will help implement data governance policies, ensuring that data pipelines are secure, reliable, and compliant.

Apply version control practices in both DBT and Matillion, ensuring that development efforts are properly documented, reversible, and aligned with team workflows.

Advocate for and contribute to the continuous improvement of the data engineering process, including driving efforts to implement CI/CD pipelines for Snowflake development using DBT and Matillion.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SnowflakeMatillionSQLDBTData Governance

Required

8+ years of professional services experience

3+ years of experience in Snowflake data engineering (data modeling, performance tuning, data ingestion)

3+ years of experience designing and developing data pipelines using Matillion

3+ years of experience using SQL

Preferred

Experience using data governance concepts

On-site presence

Undergraduate or Graduate degree preferred

Benefits

Medical, dental, and vision insurance with an employer contribution

Flexible spending or health savings account

Life and AD&D insurance

Short and long term disability coverage

Paid time off

Employee assistance

Participation in a 401k program with company match

Additional voluntary or legally-required benefits

Company

NTT DATA

Glassdoor

3.9

NTT DATA provides broad range of IT services and solutions, including consulting, systems integration, and IT outsourcing. It is a sub-organization of Nippon Telegraph and Telephone.

Founded in 1988

Koto, Tokyo, JPN

10,001+ employees

https://www.nttdata.com/jp/ja/

H1B Sponsorship

NTT DATA has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (185)

2022 (731)

2021 (838)

2020 (1190)