Data Engineer ( SQL, SSIS)

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

5-8 years of experience in data engineering roles., Strong expertise in SQL Server and SSIS for ETL development., Knowledge of data warehousing concepts and data modeling., Excellent problem-solving and analytical skills..

Key responsibilities:

  • Design and maintain ETL processes using SSIS.
  • Write complex SQL queries for data transformation.
  • Collaborate with teams to understand data requirements and deliver solutions.
  • Monitor data jobs and provide production support.

dotSolved Systems Inc. logo
dotSolved Systems Inc. Information Technology & Services SME http://www.dotsolved.com/
201 - 500 Employees
See all jobs

Job description

Responsibilities:
  1. Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
  2. Write complex SQL queries, stored procedures, and functions for data transformation and integration.
  3. Optimize database performance, troubleshoot data issues, and ensure data integrity.
  4. Work closely with business and analytics teams to understand data requirements and deliver scalable solutions.
  5. Develop and maintain data pipelines for structured and unstructured data sources.
  6. Implement data validation and reconciliation processes to ensure accuracy and consistency.
  7. Collaborate with stakeholders to design and enhance data models, reporting, and dashboards.
  8. Ensure compliance with data security, privacy, and governance standards.
  9. Monitor data jobs, troubleshoot failures, and provide production support.
  10. Document processes, workflows, and best practices for data management.
Skills & Experience:
  1. Strong expertise in SQL Server, including database design, query optimization, and performance tuning.
  2. Hands-on experience with SSIS for ETL development, deployment, and automation.
  3. Knowledge of data warehousing concepts, data modeling, and ETL best practices.
  4. Experience in integrating data from multiple sources (APIs, flat files, databases).
  5. Strong problem-solving and analytical skills with attention to detail.
Location: Remote

Required profile

Experience

Industry :
Information Technology & Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Analytical Skills
  • Detail Oriented
  • Problem Solving

Data Engineer Related jobs