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

Data Migration Engineer

Mark43 251-1K Professional Services

Mark43 is hiring a Data Migration Engineer (ETL Developer) to lead customer data migration efforts for public safety software, ensuring agencies transition clean, accurate data into the platform.

SQL
5 minutes ago

Principal Engineer - Data Infrastructure

Sezzle 251-1K Diversified Financial Services

Sezzle is hiring a Principal Engineer for Data Infrastructure to own and evolve the systems that power large-scale data storage, movement, and analytics across the company.

Apache Airflow AWS Dagster Databricks dbt Elasticsearch Flink Git GitLab Go Kafka Kubernetes MySQL PostgreSQL Prefect Python React React Native REST API Snowflake SQL TypeScript
20 minutes ago

Principal Engineer - Data Infrastructure

Sezzle 251-1K Diversified Financial Services

Sezzle is hiring a Principal Engineer for Data Infrastructure to own and evolve the systems that power the company’s MySQL, Postgres, Redshift, and data lake environments as its data volume and business needs continue to grow.

Apache Airflow AWS Dagster Databricks dbt Elasticsearch Git GitLab Go Kafka Kubernetes MySQL PostgreSQL Prefect Python React React Native Snowflake SQL TypeScript
20 minutes ago

Data Automation Engineer

Zeta Global 1K-5K Media

Zeta Global is seeking a builder to create and improve automation workflows across its data cloud acceleration team, turning repeatable business problems into measurable, production-ready solutions.

Apache Airflow AWS Azure C# JavaScript LLM Python Serverless Snowflake SQL TypeScript
49 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