Data Engineer (T-SQL & SSIS)

1 month, 3 weeks ago
Full-time
Senior
Software Development
OZ Digital,

OZ Digital,

OZ Digital Consulting Unlock growth opportunities with OZ Digital Consulting. Our expert solutions drive innovation, transformation, and success for your business. OZ is a consulting and technology solutions leader focused on increasing customer engage...

Internet Software & Services
251-1K
Founded 1997

Description

  • Develop and maintain SQL code and SSIS packages for data extraction, transformation, and loading.
  • Design, update, and optimize SSIS packages and ETL/ELT workflows to improve performance and scalability.
  • Analyze data to identify trends, diagnose business issues, and deliver actionable insights to stakeholders.
  • Monitor and review query and job performance, analyze execution plans, and optimize T-SQL code.
  • Provide production-level support by troubleshooting issues, resolving bugs, and implementing timely fixes to ensure system availability.
  • Document processes, packages, and methodologies to maintain clear records for knowledge sharing and future enhancements.
  • Identify and resolve data quality issues and collaborate with teams on data governance and quality assurance.

Requirements

  • 5+ years of proven experience in Microsoft Transact-SQL (T-SQL).
  • Working experience with Microsoft BI Tool Suite (SQL Server, SSIS, SSAS, SSRS) and developing/maintaining SSIS packages.
  • Understanding of SQL Server Agent, Integration Services Catalogs, SSISDB projects and environments, SQL Server Management Studio (SSMS), and Visual Studio.
  • Proficiency in data modeling, data transformation, and ETL/ELT processes.
  • Experience with data warehousing.
  • Strong analytical skills: synthesize complex information, research data, create solutions, and present insights to stakeholders.
  • Experience identifying and resolving data quality issues and familiarity with data governance best practices and tools.
  • Fluent in English.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

AI Data Engineer

Influur 11-50 Media

Influur is hiring an AI Data Engineer in New York/remote to own the full data-to-agent pipeline behind its autonomous viral marketing system for influencer campaigns.

AWS GCP LLM Python
4 hours, 43 minutes ago

Senior Data Engineer

Zencore Group 11-50 Internet Software & Services

Zencore is hiring a Senior Data Engineer in its LATAM Data & Analytics team to help customers modernize and migrate data platforms on Google Cloud through hands-on pipeline engineering and advisory work.

Apache Airflow Apache Spark CI/CD Databricks GCP MLOps Oracle Python Snowflake SQL
5 hours, 28 minutes ago

Data Observability Consultant - Dynatrace

Lingaro 5K-10K IT Services

Dynatrace India’s Consulting and Advisory Data Consulting Practice is hiring a remote Data Observability Consultant to support data-focused consulting work.

5 hours, 43 minutes ago

Senior Data Engineer

Lodgify 251-1K Internet Software & Services

Lodgify is hiring a Senior Data Engineer in Barcelona to build and optimize the company’s modern data platform that powers data-driven decisions across its vacation rental business.

Apache Airflow AWS Azure dbt GCP JavaScript Machine Learning Python SQL
5 hours, 43 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers