Data Engineer Sr

Primary Duties & Responsibilities

• Build, maintain, and optimize ETL/ELT pipelines for ingesting, transforming, and processing data.
• Ensure data pipelines are scalable, reliable, and efficient.
• Design and implement data models, warehouses, and lakehouse architectures.
• Optimize data storage solutions using relational (SQL) and NoSQL databases.
• Work with big data technologies like Spark, Hadoop, and Kafka for large-scale data processing.
• Deploy and manage data solutions on cloud platforms (AWS, Azure, GCP).
• Improve query performance and storage efficiency.
• Implement indexing, partitioning, and caching strategies for faster data retrieval.

Education & Experience

Typically requires a Bachelor’s degree with 8+ years experience, a Master’s degree and 6+ years experience, a PhD with 3+ years experience, or an equivalent combination of education & experience.

Skills & Abilities

• Strong in T-SQL and Python.
• Expertise with ETL/ELT tools such as SSIS and Azure Data Factory.
• Knowledge of both on premise and cloud database management systems.
• Exceled application of data modeling principles and best practices.
• Knowledge with Big Data concepts such as Multi Parallel Processing and Modern Cloud Data Warehouse Architecture.
• Excellent communication skills, both verbal and written.
• Exceptional analytical and problem-solving skills with keen attention to detail.

Physical Requirements

This position is primarily office-based, operating in a professional and climate-controlled environment. The majority of work is performed on a computer, requiring prolonged periods of sitting, typing, and viewing a screen. The work environment is generally quiet with minimal exposure to noise, hazards, or extreme temperatures. This position requires the ability to maintain focus and productivity in a desk-based setting, with occasional movement throughout the office for meetings or collaborative tasks.