Welcome to RemoteYeah 2.0! Find out more about the new version here.

Remote Data Engineer (T-SQL & SSIS)

at OZ Digital LLC

Posted 2 days ago 4 applied

Description:

  • The position is for a Data Engineer specializing in T-SQL and SSIS, focusing on developing comprehensive data integration solutions.
  • The candidate will be responsible for developing and maintaining SQL code and SSIS packages to ensure robust and scalable solutions for evolving data needs.
  • Responsibilities include writing efficient SQL scripts for data extraction, transformation, and loading processes, as well as updating and enhancing SSIS packages for improved performance.
  • The role involves analyzing data to address business issues, identifying trends, interpreting complex data sets, and collaborating with stakeholders to deliver actionable insights.
  • Regular review and optimization of query performance is required, including monitoring execution times and applying best practices to enhance overall performance.
  • The candidate will provide production-level support to ensure the reliability and availability of data systems, troubleshooting issues, resolving bugs, and implementing fixes promptly.
  • Documentation of all processes is essential to maintain a clear record of methodologies and practices, promoting knowledge sharing and compliance with standards.

Requirements:

  • A minimum of 5 years of proven experience in Microsoft (MS) Transact-SQL (T-SQL) is required.
  • The candidate must have at least 2 years of analytical experience, synthesizing complex information, collecting and researching data, and presenting insights to stakeholders.
  • Working experience with the Microsoft BI Tool Suite, including SQL Server, SSIS, SSAS, and SSRS, is necessary.
  • Understanding of SQL Server Agent, Integration Services Catalogs, SSISDB Projects and Environments, SSMS, and Visual Studio is required.
  • Proficiency in data modeling, data transformation, and ETL/ELT processes is essential.
  • Experience with data warehousing is a must.
  • The candidate should be able to identify and resolve data quality issues.
  • Familiarity with data governance best practices and tools is required.
  • Fluency in English is mandatory.

Benefits:

  • The position offers the opportunity to work on diverse analytical needs, ensuring data is utilized to its fullest potential.
  • The role provides a chance to develop and enhance skills in SQL and data integration techniques.
  • The candidate will have the opportunity to collaborate with stakeholders and contribute to business growth through actionable insights.
  • The position supports professional development through documentation practices that promote knowledge sharing and compliance.
  • The role ensures a dynamic work environment with evolving data needs, allowing for continuous learning and adaptation.