Data Engineering Specialist

Job Description:

The Data Engineering Specialist will primarily focus on the development of large-volume information ingestion and transformation. This position is responsible for orchestrating data interfaces into (and out of) our Enterprise Data Warehouse using Talend, SQL, Python, and other Data Engineering solutions.

GENERAL RESPONSIBILITIES:

Design and develop ETL (Talend) / SQL / Python-based processes to perform complex data transformation processes. Top skill needed ETL/Talend expereince

Design, code, and test major data processing features, as well as work jointly with other team members to provide complex software enhancements for the enterprise data storage platforms (RDBMS and No-SQL platforms)

Build Data Integration solutions to handle batch/streaming / IoT data on ETL and big-data platforms.

Develop and Deliver changes in the Enterprise Data Warehouse according to Data Warehousing best practices

Gather requirements and construct documentation to aid in maintenance and code reuse in accordance with team processes and standards

Design, code, and test major data processing features, as well as work jointly with other team members to provide complex software enhancements for the enterprise data storage platforms

Monitor scheduled jobs and improve the reliability of ongoing processing

Monitor, measure, and enhance ways to improve system performance

Ability to multi-task deliverables and efficiently manage them.

Performs other duties as assigned

QUALIFICATIONS:

Understanding and Hands-on experience with key technologies (SQL, ETL, Data modeling, data processing)

Development experience in a Big-Data environment a Plus; Spark, Kafka, Message Queues

1 – 2 yrs Hands-on experience with ETL tools

Strong SQL skills with Relational DBMS technology - SQL Server a plus

Experience with shell scripting / Python

Good understanding and expertise in relational database concepts and data processing concepts

Experience in handling multiple data formats (Delimited file, JSON, XML etc)

Hands on experience designing and implementing data ingestion techniques for real time processes (IoT, eCommerce) a plus.

Strong communication skills (oral and written)

Good analytical and problem solving skills

Knowledge of CRM, MDM, HR Reporting and Business Intelligence a plus

Candidate must be thorough and detail-oriented and a team player

Able to work on multiple priorities in a deadline-driven environment

Hybrid Requirments- once a month on-site.

Skills:

ETL, Talend, Python, SQL, azure, databricks, kafka, Customer data, HR

Experience Level:

Intermediate 2-3+ years of hands-on experience.

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.