Job Summary:
We are seeking an experienced Snowflake + Matillion ETL Developer / Data Engineer to design, develop, and optimize cloud-based data pipelines and analytics solutions. The ideal candidate will have deep expertise in Snowflake Data Warehouse , Matillion ETL , AWS data services , and data modeling (Facts, Dimensions, SCD Type 2). This role involves building reliable, scalable, and high-performance data integration solutions that power business insights and reporting.
Key Responsibilities:
Design, develop, and deploy ETL/ELT pipelines using Matillion ETL and Snowflake for data ingestion, transformation, and analytics.
Build and maintain Matillion architecture including orchestration jobs, transformation workflows, and variable management.
Create and manage Snowflake objects databases, schemas, tables, views, streams, tasks, and stored procedures.
Implement data validation, cleaning, and transformation to ensure data accuracy, completeness, and consistency.
Design and maintain data warehouse models (Star/Snowflake schema) including Slowly Changing Dimensions (SCD Type 2) .
Integrate data from multiple sources such as AWS S3, RDS, Redshift, and APIs using Matillion and Python connectors.
Optimize SQL queries, transformations, and Snowflake workloads for performance and cost efficiency.
Collaborate with data architects, BI developers, and DevOps teams to implement CI/CD pipelines (Git, Jenkins, GitHub Actions).
Monitor ETL processes, troubleshoot issues, and ensure on-time delivery of reliable data pipelines.
Apply data governance, quality, and security best practices across all environment
Required Skills & Experience:
8 10 years of overall IT experience with 4+ years in Snowflake Data Engineering and 3+ years in Matillion ETL .
Strong proficiency in SQL and Snowflake scripting (Streams, Tasks, Procedures, Performance Tuning).
Expertise in Matillion ETL job design , orchestration, and optimization.
In-depth understanding of data modeling concepts Facts, Dimensions, Hierarchies, and SCD Type 2 .
Experience with AWS data services such as S3, Glue, Lambda, and Redshift.
Proficiency in Python for data transformations and automation.
Hands-on experience with CI/CD pipelines and Git-based version control systems.
Strong analytical, problem-solving, and communication skills.
Preferred Qualifications:
SnowPro Core Certification or Matillion Associate Certification .
Experience with BI tools (Tableau, Power BI, Looker) for data validation and visualization.
Familiarity with Airflow or AWS Step Functions for orchestration.
Understanding of data lake architecture , real-time streaming , and data governance frameworks .
...for experienced Caregivers in the Louisville KY area who can work 12 hour shifts days primarily. Primary Day Shifts needed (7AM-7PM)... ...some overnight shifts available (7PM-7AM). Full time hours with pay up to $16/hr. Applicants must live in Louisville area or surrounding...
...This is where your work makes a difference. At Baxter, we believe every personregardless of who they are or where they are fromdeserves a chance to live a healthy life. It was our founding belief in 1931 and continues to be our guiding principle. We are redefining...
...Siege Media is a growing and remote-first organic growth agency! We are nationally recognized on Inc.s Best Workplaces list and Inc. 5000 list, highlighting the 5000 fastest-growing private companies. Interested in working with the Siege team? We currently have a spot...
...its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for Medtronic. Clicking "Apply Now" or "Read more" on Lensa redirects you to the job board/employer site. Any information collected there is subject...
...PHYSICAL THERAPIST OUTPATIENT LEAD FULL TIME ARBOR REHAB & NURSING LODI, CA Join our IN-HOUSE Therapy Team in Lodi as a dedicated PT! Arbor Rehab & Nursing in Lodi, CA, is seeking a Full Time Outpatient Lead Physical Therapist to join our in-house therapy...