Data/Sql Software Engineer

Job Summary

We are seeking a seasoned SQL Developer/Data Warehouse Engineer to design, build, and manage robust data warehousing solutions and replication strategies.

This role demands hands-on experience across both Oracle and SQL Server environments, with a strong command of Azure Fabric and data lake technologies.

You'll be key in crafting reliable datasets for dashboarding, reporting, and analytical consumption, utilizing an AI-augmented approach to solutioning, and ensuring seamless data replication and synchronization using Oracle Golden Gate and similar tools.

A commitment to collaborative problem solving, sophisticated design, and product quality is essential.

Job Description

Key Responsibilities

Design, implement, and maintain scalable data warehouse solutions, using AI tools (e.g., GitHub Copilot, Claude, Cursor)

Develop, optimize, and manage SQL code across Oracle and SQL Server, with AI assistance for code completion, refactoring suggestions, and identifying potential bugs.

Architect and monitor replication solutions using Oracle Golden Gate and SQL Server replication tools

Leverage Azure Fabric to support distributed data processing

Build data pipelines and curate datasets within data lakes

Collaborate with BI teams to deliver clean, reliable data for Tableau, Power BI, Business Objects and other visualization tools

Drive performance optimization and ensure data integrity across systems

Partner with product and technical leads to review and finalize requirements; use AI summarization tools to rapidly synthesize documentation and user stories.

Responsible for effectively and responsibly integrating AI coding assistants into their workflows.

Own developer testing for assigned projects; use AI-powered test generation tools to achieve high coverage while reducing manual test-writing effort.

Resolve technical issues in new and existing code through systematic debugging; apply AI-assisted root cause analysis to accelerate issue resolution.

Required Qualifications

5+ years of SQL development experience with Oracle and SQL Server

Experience designing and maintaining data warehouses and ETL pipelines

Proven expertise with Oracle Golden Gate and SQL Server replication

Solid understanding of Azure services including Azure Fabric, Synapse, and Data Factory

Hands-on with data lake solutions and file formats such as Parquet and Delta

Fluency in data modeling techniques and schema design

Preferred Skills

Knowledge of Power BI, Business Objects, Tableau or other visualization platforms

Exposure to AI DevOps practices and CI/CD automation for data workflows

Familiarity with Python, Scala, or Spark for big data processing

Worker Type

Regular

Number Of Openings Available

1