Sr. Data Engineer (SQL and SSIS)

Job Description
• 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.
 • Performs other duties as assigned.

Main Projects:
Converting from old JDE to new JDE- rewriting all integrations in SSIS to stored procedures- moving to Mulesoft and building a Lakehouse and Fabric
SQL version is 2014 - this person will be helping to move to SQL 2025
Managed service provider helping i...