Be an early applicantLess than 25 applicants

Company

NTT DATA North America · 6 hours ago

Data Engineer (Matillion/Snowflake)

Portland, OR

Full-time

Remote

Senior Level, Lead/Staff

$80/hr - $100/hr

8+ years exp

Maximize your interview chances

ConsultingDigital Marketing

H1B Sponsor Likely

Insider Connection @NTT DATA North America

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.

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.

Design and implement optimized data warehousing solutions within Snowflake by leveraging multi-cluster warehouses, data partitioning, and clustering keys.

Use DBT to structure data transformations efficiently, building incremental models to handle large datasets.

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.

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.

Snowflake data engineeringData pipeliningMatillionSQLData governance conceptsData modelingPerformance tuningData ingestionDBT

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

Undergraduate or Graduate degree preferred

Benefits

Medical, dental, and vision insurance

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 North America

Glassdoor

3.9

NTT DATA, Inc. is a trusted global innovator of business and technology services.

Founded in 1988

Plano, Texas, USA

10001+ employees

https://us.nttdata.com

H1B Sponsorship

NTT DATA North America 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)