Sr. Data Engineer (SQL and SSIS)
Role details
Job location
Tech stack
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 in moving but this person will be leading efforts
Requirements
· Experience designing and building scalable data pipelines
· Strong understanding of data architecture and integration patterns
· Ability to work cross-functionally with business and technical teams
· Experience with cloud-based data platforms Mulesoft
Fabric
Benefits & conditions
Salary: $120,000-130,000 annually plus 15% bonus depending on skills and experience