Sr. Data Engineer

Cleo Consulting; Dallas (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Cleo Consulting seeks a Senior Data Engineer for a 12-month Dallas, TX assignment. Design and optimize data warehouses, develop IICS pipelines, and work with Snowflake and DBT to support large-scale data initiatives.

Applicants should have 5+ years in data warehousing, ETL development, and diverse databases (MSSQL, MySQL, Oracle; NoSQL options). Strong SQL and version-control experience are required.

Qualifications

• 5+ years in data warehousing, IICS and Snowflake DBT development.
• 5+ years with databases including MSSQL, MySQL, Oracle; NoSQL options like MarkLogic, Snowflake, DynamoDB, Redis.
• 3+ years on large data initiatives (>5 TB).
• Advanced SQL skills and experience with relational databases and diverse DBs.
• Experience building and optimizing IICS data pipelines and datasets.
• Experience root-cause analysis on data and processes to drive business improvements.
• Build processes for data transformation, metadata, dependency and workload management.
• Working knowledge of version control systems such as Git and SVN.

Skills

Data warehousing

SQL

Root cause analysis

Version control

ETL development

ETL architecture

IICS

Snowflake

DBT

MSSQL

MySQL

Oracle

DynamoDB

Redis

Git

SVN

Education

Bachelor's degree in Computer Science or related field

Tools

IICS

Snowflake

DBT

MSSQL

MySQL

Oracle

DynamoDB

Redis

Git

SVN

Job description

Job Title: Sr. Data Engineer

Location: Dallas, TX

Duration: 12 Months

Visa: Only US Citizens can apply

Description:

• 5+ years' experience working with data warehousing, IICS and snowflake DBT development.
• 5+ years' experience combined experience with any of the following database technologies (RDBMS: MSSQL, MySQL Oracle; NoSQL: MarkLogic, Snowflake, DynamoDB, Redis).
• 3 years' experience working on large data initiatives (>5 terabytes).
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing IICS 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.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Working knowledge of version control systems (e.g. SVN, Git)

MINIMUM QUALIFICATIONS:

• 3+ years of experience in a Data Engineer role, who has attained a bachelor's degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• AWS: 1 year experience
• DevOps Practices: 1 year experience
• 3+ years' experience working with data warehousing, ETL development and ETL architecture.
• 3+ years' experience combined experience with any of the following database technologies (RDBMS: MSSQL, MySQL Oracle; NoSQL: MarkLogic, Snowflake, DynamoDB, Redis).
• 3 years' experience working on large data initiatives (>5 terabytes).