Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Engineer (AWS/Snowflake/Matillion)

Prophecy Technologies

Role: Data Engineer (AWS/Snowflake/Matillion)

Location: St. Louis, MO

Competencies
  • Digital: Amazon Web Services (AWS) Cloud Computing
  • Digital: Snowflake
Experience: 10+ Years Overall

Technical / Functional Skills
  • 1+ years of hands-on experience with Matillion .
  • 5+ years in ETL/ELT development , leveraging industry-recognized tools.
  • 2+ years developing and supporting cloud-based data platforms , particularly Snowflake .
  • Proficiency with AWS services including Lambda and data pipelines .
  • Experience implementing Change Data Capture (CDC) processes.
  • Strong command of SQL -stored procedures, triggers, functions, and error handling.
  • Demonstrated ability in problem-solving and developing technical solutions.
  • Excellent verbal and written communication skills; capable of multitasking in collaborative environments.
  • Proven experience building and supporting ETL/ELT processes from multiple data sources.
  • Familiarity with self-service BI tools (OBIEE, Looker, Power BI, etc.).
  • Ability to document ELT processes and maintain accurate procedures.
  • Skilled in data analysis, mapping, and transformation logic for project-specific needs.
  • Experience creating and maintaining ELT specifications (source-to-target mappings).
  • Capable of participating in production on-call support for ETL processes.
  • Experience providing effort estimates and suggesting process improvements .
  • Bonus: Experience with Oracle Data Integrator (ODI) .
Roles & Responsibilities
  • Deliver small to midsize assignments or projects; present results to team, IT peers, and business stakeholders.
  • Design, implement, and maintain end-to-end ELT pipelines to extract data from diverse sources into data warehouses/lakes.
  • Develop and manage data models, schemas, and transformations , leveraging tools such as dbt .
  • Build and manage integrations with internal/external data sources and APIs.
  • Implement data validation, quality, and security controls to ensure integrity and compliance.
  • Configure and monitor data infrastructure (databases, warehouses like Snowflake or BigQuery, and cloud storage).
  • Optimize queries and pipeline performance to improve run efficiency and reduce load times.
  • Monitor, troubleshoot, and debug scheduled ETL/ELT jobs.
  • Continuously enhance existing pipelines to align with evolving business requirements.
  • Collaborate effectively within a team, managing priorities and escalating issues appropriately.
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Data Engineer (AWS/Snowflake/Matillion) in Saint Louis, MO vacancy
  •  ...VA, WV, WI Responsibilities: The Data Services team supports a modern suite...  ...technologies—including Looker, Snowflake, Atlan, and Matillion—hosted in AWS. These tools form the foundation of...  ...growth across the organization.? As an Engineer 2 (Data), candidate will design,... 
    Amazon Web Service

    PTR Global

    Saint Louis, MO
    5 days ago
  • PTR Global in St. Louis is seeking an Engineer 2 (Data) to design and maintain data pipelines using cloud-based technologies like AWS and Matillion. The ideal candidate will have over 3 years of ETL experience and be capable of working within Central Standard Time hours... 
    Amazon Web Service

    PTR Global

    Saint Louis, MO
    5 days ago
  • A tech solutions provider in St. Louis is seeking a Data Engineer to design and maintain data warehouses within Snowflake. You will build robust ETL/ELT pipelines, optimize data integration workflows, and implement data governance policies. The role requires a Bachelor'... 
    Suggested

    TechDigital Group

    Saint Louis, MO
    5 days ago
  • A leading tech company seeks a Data Engineer to build and operate their Snowflake data lakehouse. You will design and maintain data pipelines, analyze data relationships, and develop data solutions for reporting and analytics. The ideal candidate has advanced SQL knowledge... 
    Suggested

    Sky Mavis

    Saint Louis, MO
    3 days ago
  • $43.4 - $62 per hour

     ...is currently seeking a talented DevOps Engineer. Do you have experience building and maintaining...  ..., managing cloud infrastructure with AWS, and scripting with Python or Groovy?...  ...Skills & Experience Familiarity with Snowflake Data Cloud or enterprise data warehouse concepts... 
    Amazon Web Service
    Contract work
    Work at office

    Technology Partners

    Saint Louis, MO
    1 day ago
  • $77k - $202k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector...  ...people in data and analytics engineering focus on leveraging advanced...  ...Certification in Cloud Platforms [e.g., AWS Solutions Architect, AWS Data...  ...Data Engineer Associate, Snowflake Core, Snowflake Databricks... 
    Amazon Web Service
    Full time
    H1b

    PwC

    Saint Louis, MO
    5 days ago
  • $88k - $113.5k

     ...department. Interested in building data products that power advanced...  ...Description: As an Analytics Engineer II, you will play a key role...  ...Qualifications: Experience with Snowflake or similar cloud-native data...  ...cloud platforms such as Azure, AWS, or GCP Experience with... 
    Amazon Web Service
    Work at office
    Work from home
    Flexible hours
    3 days per week

    DiversityJobs Inc

    Saint Louis, MO
    a month ago
  • $124k - $280k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector...  ...people in data and analytics engineering focus on leveraging advanced...  ...Certification in Cloud Platforms [e.g., AWS Solutions Architect, AWS Data...  ...Data Engineer Associate, Snowflake Core, Snowflake Architect,... 
    Amazon Web Service
    Full time
    H1b

    PwC

    Saint Louis, MO
    8 days ago
  • $99k - $232k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector...  ...people in data and analytics engineering focus on leveraging advanced...  ...Certification in Cloud Platforms [e.g., AWS Solutions Architect, AWS Data...  ...Data Engineer Associate, or Snowflake Core, Snowflake Databricks... 
    Amazon Web Service
    Full time
    H1b

    PwC

    Saint Louis, MO
    18 days ago
  •  ...Data Engineer, Data Solutions Overview NISA Investment Advisors, LLC (NISA) offers customized investment solutions for tax-exempt...  ...Python, C#, or similar high-level language ~ Experience with AWS, AWS Lambda, S3, Airflow, and related technologies ~ Professional... 
    Amazon Web Service
    Work experience placement

    NISA Investment Advisors

    Clayton, MO
    3 days ago
  •  ...Senior Geospatial Data Engineer Object Computing, Inc. is seeking a Senior Geospatial Data Engineer to join our Xtrack Product Team. In...  ...adoption and optimization of cloud-based data solutions (e.g., GCP, AWS, Azure). Ensure data quality, integrity, and security across... 
    Amazon Web Service

    Object Computing

    Saint Louis, MO
    4 days ago
  • Stifel Financial Corp. is seeking a Data Engineer III in St. Louis, Missouri, responsible for designing and maintaining robust data pipelines on AWS. The ideal candidate will have over 7 years of experience in data engineering, strong programming abilities in Python and... 
    Amazon Web Service

    Stifel Financial Corp.

    Saint Louis, MO
    4 days ago
  • Stifel is looking for a Data Engineer III based in St. Louis, Missouri, to design, develop, and maintain critical data pipelines on the AWS platform. The ideal candidate should possess strong programming skills in Python and SQL, along with a robust understanding of various... 
    Amazon Web Service

    Stifel

    Saint Louis, MO
    5 days ago
  • $124k - $280k

     ...Specialty/Competency: Data, Analytics & AI Industry/Sector...  ...people in data and analytics engineering focus on leveraging advanced...  ...Azure Health Data Services), AWS (SageMaker, Bedrock), and/or...  ...warehouse technology including Snowflake or Databricks Experience working... 
    Amazon Web Service
    Full time
    H1b

    PwC

    Saint Louis, MO
    5 days ago
  •  ...Position Title: Lead AWS Data Engineer Location: St. Louis, MO Job Description • Design and build scalable, cloud-native data platforms using PySpark, Python, and modern data engineering practices. • Mentor and guide other engineers, sharing knowledge... 
    Amazon Web Service

    Tech M USAAvance Consulting

    Saint Louis, MO
    4 days ago
  • $215k - $265k

     ...Team Financial Systems owns the data and reporting foundation for...  ...financial information using dbt and Snowflake to enable scalable BI, close...  ...looking for a Staff Analytics Engineer to build and own our Financial...  ...human‑in‑the‑loop review. AWS experience (nice to have): S3/... 
    Amazon Web Service
    Work at office
    Remote work
    Flexible hours

    Affirm

    Saint Louis, MO
    1 day ago
  •  ...We're a team of multi-cloud natives with certifications across AWS and Azure; helping our customers solve their business problems...  ...having a passion for building applications. The primary focus of a Data Engineer is to help our clients build reliable, performant, and scalable... 
    Amazon Web Service

    CleanSlate Technology Group

    Saint Louis, MO
    5 days ago
  • What You'll Be Doing The Data Engineer III is responsible for designing, developing, and maintaining data pipelines and infrastructure on the AWS platform. The Data Engineer III works with large volumes of data, ensuring its quality, reliability, and accessibility. Tasks... 
    Amazon Web Service

    Stifel

    Saint Louis, MO
    1 day ago
  •  ...Senior Data Engineer The primary responsibilities of this role are to: lead and participate in design sessions with Enterprise and Hub Data...  ...in the Scala programming language. 3+ years of experience with AWS Fargate. 3+ years of experience with AWS Lambda. 3+ years of... 
    Amazon Web Service
    Temporary work

    Infotree Global Solutions

    Saint Louis, MO
    4 days ago
  • Responsibilities The Data Engineer III is responsible for designing, developing, and maintaining data pipelines and infrastructure on the AWS platform. The role includes data ingestion, transformation, storage, sharing, consumption, and implementing data security and privacy... 
    Amazon Web Service

    Stifel Financial Corp.

    Saint Louis, MO
    4 days ago
  • $106.9k - $176.5k

     ...working world. We are seeking a highly skilled Senior Consultant Data Engineer with expertise in cloud data engineering, specifically...  ...engineering solutions using Databricks on cloud platforms (e.g., AWS, Azure, GCP). Collaborate with clients to understand their data... 
    Amazon Web Service
    Summer holiday
    Flexible hours

    EY

    Saint Louis, MO
    2 days ago
  •  ...Unable to Provide Sponsorship or do C2C We are seeking a Senior Data Engineer to support a Fortune 50 health insurance organization, driving...  ...Hands-on experience with cloud computing platforms, including AWS, Databricks, Azure, and GCP . Knowledge of MLOps best practices... 
    Amazon Web Service

    Brooksource

    Saint Louis, MO
    4 days ago
  •  ...Cyber Data Analysis Engineer Abile Group has an exciting and challenging opportunity for a Cyber Data Analysis Engineer on a contract providing...  ...Skills: Experience with public clouds such as AWS, Google, Rackspace. Experience with private clouds such as... 
    Amazon Web Service
    Contract work
    For contractors
    Immediate start
    Worldwide

    Abile Group, Inc.

    Saint Louis, MO
    4 days ago
  •  ...What You Will Be Doing : Help customers send their log data through one or more enterprise networks to a specific destination...  ...pipelines consisting of products like Cribl, ArcSight, Kafka, various AWS products, Linux servers, and Microsoft servers. Design, build,... 
    Amazon Web Service
    Temporary work
    For contractors
    Local area
    Immediate start
    Flexible hours

    Crimson Phoenix

    Saint Louis, MO
    4 days ago
  • $111.6k - $139.5k

     ...hardware, software, networks, and data systems, while providing top-...  ...be doing? As a Senior Data Engineer, you will collaborate with a...  ...and ELT platform such as Matillion or Informatica. ~ Have excellent...  ...products e.g. Databricks, Snowflake, Redshift, etc. ~... 
    Permanent employment
    Full time
    H1b
    Remote work
    Visa sponsorship
    Shift work

    World Wide Technology

    Saint Louis, MO
    3 days ago
  •  ...design, development and programming, software engineering, systems development, testing,...  ...required by career. Job Description Senior Big Data Analytics Developer w/proven experience leading...  ...writing Scala architecture on OS X and AWS (Amazon Web Services), as well as Java... 
    Amazon Web Service
    Remote work

    Atria Group LLC

    Saint Louis, MO
    2 days ago
  •  ...Must be a US Citizen or Green Card only Applicant **** The Data Analytics Engineer will be a part of the Data Engineering team whose primary mission...  ...with tools/technologies such as Fivetran, dbt, SQL, AWS Redshift, Boomi, PowerBI , Git. Ability to work on-site at least... 
    Amazon Web Service
    2 days per week

    The Timberline Group

    Saint Louis, MO
    5 days ago
  •  ...Analytics Engineer / Data Scientist (Full Stack) Awetomaton is seeking a full stack Analytics Engineer / Data Scientist to develop and implement...  ...: Cloud cost and usage data (billing reports such as AWS CUR 2.0) Platform usage metrics (telemetry systems like... 
    Amazon Web Service
    Work at office
    Flexible hours

    Awetomaton Ltd

    Saint Louis, MO
    4 days ago
  •  ...Description: Data Engineer The mission of Bayer Crop Science is centered on developing agricultural solutions for a sustainable...  ...maintain cloud based infrastructure on a major cloud provider like AWS, Azure or Google Cloud Platform • Experience data modeling... 
    Amazon Web Service
    For subcontractor
    Work at office
    Remote work
    Flexible hours
    Shift work

    inSync Staffing

    Saint Louis, MO
    1 day ago
  • Job Title : Lead AWS Data Bricks Spark/Scala Engineer Job ID: 2022-11882 Job Location: Remote, Memphis, TN (preferred), Morris Plains, NJ, Austin, TX (preferred), St. Louis, MO Job Travel Location(s): # Positions: 1 Employment Type: W2 Candidate Constraints: Duration:Long... 
    Amazon Web Service
    Permanent employment
    Remote work

    Highbrow LLC

    Saint Louis, MO
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Engineer (AWS/Snowflake/Matillion). Be the first to apply!