Back to Jobs
Recently postedTechnology

Senior Data Engineer - W2 (No C2C or 1099) - Onsite in Wilmington, MA (Posted SAM)

Global Force USAWilmington, MA🇺🇸United States

Quick overview

SeniorityMid-Senior
Work modeHybrid
LocationWilmington, MA, United States
SQLETLSQL Server

Job description

REQUIRED SKILLS

  1. Database Design and Development:
  • Design, implement, and maintain database structures and dimensional data models, including tables, views, indexes, and schemas using Microsoft SQL Server.
  • Develop complex SQL queries, stored procedures, functions, and triggers to support application development and data processing.
  • Optimize database performance through indexing, query optimization, and other performance tuning techniques.
  1. Data Integration and ETL Processes:
  • Design and develop ETL and ELT processes using SQL Server Integration Services (SSIS) to ingest and transform data from multiple sources.
  • Parameterize SSIS packages and create environment variables for SSIS Catalog package deployment
  • Use expressions in concert with package parameters to make connections dynamic and streamline package deployment/promotion across environments
  • Ensure data quality, consistency, and integrity across different systems and environments.
  • Monitor and troubleshoot data pipelines, implement logging and error handling, and ensure timely and accurate data processing.
  1. Query Optimization:
  • Analyze and optimize SQL queries to improve execution times and reduce resource consumption.
  • Implement indexing strategies to speed up data retrieval operations.
  • Rewrite complex queries to make them more efficient and easier to maintain.
  • Collaborate with developers to optimize queries embedded within applications.
  1. Collaboration and Support:
  • Work closely with software developers, data analysts, and other IT team members to understand requirements and provide database solutions.
  • Provide technical support and troubleshooting for database-related issues.
  • Mentor and guide junior data engineers and other team members.
  1. Documentation and Compliance:
  • Create and maintain comprehensive documentation for database designs, processes, and procedures.
  • Ensure compliance with data governance, security policies, and industry regulations.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs