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
- 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) .
- 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 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
- 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
- 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
$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 ServiceContract workWork at office$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 ServiceFull timeH1b$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 ServiceWork at officeWork from homeFlexible hours3 days per week$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 ServiceFull timeH1b$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 ServiceFull timeH1b- ...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 ServiceWork experience placement
- ...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
- 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 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
$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 ServiceFull timeH1b- ...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
$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 ServiceWork at officeRemote workFlexible hours- ...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
- 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
- ...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 ServiceTemporary work
- 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
$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 ServiceSummer holidayFlexible hours- ...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
- ...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 ServiceContract workFor contractorsImmediate startWorldwide
- ...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 ServiceTemporary workFor contractorsLocal areaImmediate startFlexible hours
$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 employmentFull timeH1bRemote workVisa sponsorshipShift work- ...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 ServiceRemote work
- ...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 Service2 days per week
- ...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 ServiceWork at officeFlexible hours
- ...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 ServiceFor subcontractorWork at officeRemote workFlexible hoursShift work
- 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 ServicePermanent employmentRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Engineer (AWS/Snowflake/Matillion). Be the first to apply!
Related searches
- data engineering intern summer Saint Louis, MO
- senior data integration developer Saint Louis, MO
- data science developer Saint Louis, MO
- senior data center engineer Saint Louis, MO
- software data engineer Saint Louis, MO
- data developer Saint Louis, MO
- remote data engineer Saint Louis, MO
- sr data engineer Saint Louis, MO
- big data cloud engineer Saint Louis, MO
- big data devops engineer Saint Louis, MO

