For more information on COVID-19 and how we are responding, click here.

Data Engineer, Architect, SQL

Job Details
Posted Date:
March 27, 2022

Job ID:

St. Louis , MO

7 years

Job Description
  • Location: St. Louis, MO
  • Type: Contract
  • Job #8281

Technology Partners is currently seeking a talented Data Engineer, Architect, SQL – 146355. Do you have experience with SQL? Let us help you make your next big career move a reality!

What You Will Be Doing:
The data engineer will focus on design of the Analytic Hub architecture and data pipelines based on business need and technology efficiency. Leads projects and small teams of ETL developers/engineers on complex efforts. Assists in troubleshooting complex issues/efforts with other team members or cross divisional teams, leveraging seasoned judgment, technical and business acumen. Can easily assume a team leadership responsibilities. Ability to quickly establish themselves as creditable resource for understanding new technologies and architectures related to data management solutions. Work closely with QA, business/product analysts and customers to design and implement new feature requests. Ensures standards and directional adherence across the various technical domains. Work with internal and external technology experts to ascertain system functional capacity, constraints, and support lifecycles. Evaluate and make recommendations to ensure technology investments are optimized. Proactively identify unnecessary complexity and potential failure points, assist with creating plans to reduce or eliminate where appropriate. Build and maintain strong relationships with technology teams and business partners to facilitate improved alignment of technology initiatives to business strategies. Design and Build Analytic Hub and BI solutions using technologies like Snowflake, Oracle, SQL Server, RDS PostgreSQL, ETL/ELT Tools, BI servers, Report development Tools, data event streaming pipelines.

Required Skills & Experience:

  • Advanced working SQL/PLSQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases structures (Hadoop, MongoDB, dimensional designed solutions, and structures)
  • Experience building and optimizing data pipelines, architectures, and data sets.
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Strong analytic skills related to working with unstructured datasets and recommending transformations to optimal architectures.
  • Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
  • A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
  • Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores.
  • Experience supporting and working with cross-functional teams in a dynamic environment with an agile mindset, agile methodology, sprint planning, writing user stories and delivering data pipelines in an iterative methodology.
  • Candidates should also have 5+ years of experience using the following software/tools:
  • Cloud-based data storage and data pipeline solutions
  • API development (specifically to connect to SaaS solutions)
  • Hadoop, Spark, Kafka, Linux scripting, etc.
  • Experience with AWS/Azure cloud services and platforms
  • Experience with Snowflake data platform
  • Experience with Matillion, Databricks, or equivalent
  • Experience with object-oriented/object function scripting languages: Python, Java, etc.
  • Data Engineer role who has attained a degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field experience.

Desired Skills & Experience:

  • Data modeling experience using either SAP Power Designer or Erwin tools.
  • Snowflake cloud-based data warehousing platform.
  • Experience using agile development methodology and working within a scrum team.
  • Data modeling experience using either SAP Power Designer or Erwin tools.
  • Experience using agile development methodology and working within a scrum team.

If this position sounds like you, WE SHOULD TALK!

We realize our people are our most valuable asset, that is why we offer the following benefits:

  • Health, Dental, and Vision insurance
  • 401(k) retirement plan
  • Long and Short-Term disability
  • Life insurance
  • Direct deposit
  • Referral program

Your better future is ready, and we want to put the right tools in your hands to get you there. Let’s go!

Keywords: SQL, Oracle, Hadoop, AWS, ERwin

Looking for more opportunities with Technology Partners? Check out!

Technology Partners is an Equal Opportunity Employer. Technology Partners does not discriminate on the basis of race, color, religion, sex, national origin, age, disability or any other characteristic protected by applicable state or federal civil rights laws.

Share this Job!

Apply Now!

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!

Know someone who you think would be a great fit for Technology Partners or one of our many clients? Send them our way!