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

Wilmington, MA, US • Posted 6 hours ago • Updated 6 hours ago
Contract W2
6 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Governance
  • Data Integration
  • Data Processing
  • Data Quality
  • Database
  • ETL
  • Microsoft SQL Server
  • Microsoft SSIS
  • SQL
  • Software Asset Management

Summary

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10300977
  • Position Id: 9148268
  • Posted 6 hours ago
Contact the job poster
Mel Warden

Mel Warden

President @ Global Force USA

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.