Sr. Data Engineer

Rapinno Tech; Dallas (TX); Hybrid; USD 100,000 - 120,000; Full time

Job summary

A technology consulting firm in Dallas, TX is seeking an experienced Data Platform Engineer. The role involves expanding and optimizing data architecture and pipeline systems. Candidates must possess over 5 years of SQL Server development and ETL experience, alongside expertise in Alteryx Admin. The position requires strong data modeling skills and knowledge of big data technologies. This is a long-term contract with on-site work 2-3 days a week.

Qualifications

• 5+ years of SQL Server development experience.
• 3+ years of Alteryx Admin/User management experience.
• 5+ years of data modeling experience.
• 5+ years of ETL experience.
• 2+ years of big data experience with Hadoop and Hive.

Responsibilities

• Identify data sources and build pipelines using ETL tools.
• Improve data reliability, efficiency, and quality.
• Define data architecture framework and principles.
• Create and optimize data models for business applications.
• Automate workflows for timely delivery.

Skills

SQL Server development

Alteryx Admin/User management

ETL experience

Data modeling

Big data technologies

Data warehousing

Tools

SSIS

Hadoop

Hive

Python

VBA

Job description

Location: Dallas/Hidden Ridge, TX (2‑3 days weekly onsite from Day 1)

Duration: Long Term Contract

Overview

Every other Tue and Thu in the office. We are looking for a savvy Data platform Engineer to join our growing team of Data platform management. The candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross‑functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. Possess a high level of energy and passion about data and processes, a self‑starter being able to hit the ground running and comfortable supporting the data needs of multiple teams, systems and products.

Responsibilities

• Data acquisition and ingestion – Identify data sources and build pipelines using various ETL tools such as but not limited to SSIS and Alteryx. Data sources including but not limited to SQL Server, SAP, Teradata, Hadoop/Hive, PostgreSQL, Oracle and flat files.
• Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
• Expertise in Alteryx Admin /User management experience, advance workflow management with proper roles and security.
• Assist in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
• Create and optimize data models to support various business applications.
• Reviewing modifications of existing data systems for cross‑compatibility.
• Automate and support workflows to ensure timely delivery.

Must Have

• 5+ years of SQL Server development experience.
• 3+ years ALTERYX Admin /User management experience and advance workflow management.
• 5+ years data modeling experience.
• 5+ years of ETL experience.
• 5+ years of experience in working on more than one database technologies Microsoft SQL server, Teradata.
• 2+ years big data experience, Hadoop, Hive, Spark.
• Expert knowledge of data warehousing.

Desired Skills

• Working understanding of Microsoft VBA, HTML, Python