Data Engineer

PEOPLE INC.

Montvale, United States of America

yesterday

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Compensation

$ 140K

Job location

Montvale, United States of America

Tech stack

JIRA

Big Data

Cloud Computing

Cloud Database

Information Systems

Computer Programming

Data Dictionary

Information Engineering

Data Infrastructure

Data Integrity

ETL

Data Masking

Data Retrieval

Data Warehousing

Relational Databases

Database Design

Database Schema

Python

Microsoft SQL Server

MongoDB

NoSQL

Oracle Applications

Performance Tuning

Query Optimization

Role-Based Access Control

SQL Stored Procedures

SQL Databases

SQL Server Integration Services

Data Processing

Scripting (Bash/Python/Go/Ruby)

Freeform SQL

Azure

Sql Optimization

Spark

GIT

Information Technology

Kafka

Cosmos DB

SQL Server Management Studio (SSMS)

Data Pipelines

Database Tools and Utilities

Job description

We are seeking a highly skilled Data Engineer to build and manage our data infrastructure. The ideal candidate will be an expert in writing complex SQL queries, designing efficient database schemas, and developing ETL/ELT pipelines. You will ensure data is accurate, accessible, and optimized for performance to support business intelligence, analytics, and reporting needs., * Database Design & Management: Design, develop, and maintain relational databases (e.g. SQL Server, ProgressSQL, Oracle) and cloud-based data warehouses.

Strategic SQL and Data Engineering: Develop sophisticated, optimized SQL queries, stored procedures, and functions to process and analyze large, complex datasets for actionable business insights.
Data Pipeline Automation & Orchestration:Help build, automate, and orchestrate ETL/ELT workflows utilizing SQL, Python, and cloud-native tools to integrate and transform data from diverse, distributed sources.
Performance Optimization: Tune queries and optimize database schema (indexing, partitioning, normalization) to improve data retrieval and processing speeds.
Data Integrity & Security: Ensure data quality, consistency, and integrity across systems. Implement data masking, encryption, and role-based access control (RBAC).
Documentation: Maintain technical documentation for database schemas, data dictionaries, and ETL workflows.

Requirements

Education: Bachelor's degree in computer science, Information Systems, or a related field.
SQL Mastery: 5+ years of experience with advanced SQL (window functions, CTEs, query optimization).
Database Expertise: Deep understanding of relational database management systems (RDBMS) and data modeling techniques.
Cloud Platforms: Demonstrated experience with Azure Data Services and other data warehouse technologies.
Programming: Proficiency in Python for scripting and data manipulation.
ETL Tools: Familiarity with tools like SSIS or Azure Data Factory.
Soft Skills: Strong analytical thinking, problem-solving, and communication skills.

Nice to Have

Experience with NoSQL databases (Cosmos DB, MongoDB).
Experience with big data frameworks (Apache Spark, Kafka).
Relevant certifications (e.g., Microsoft Certified: Azure Data Engineer Associate, Google Professional Data Engineer).

Typical Work Environment