Back to Jobs
Recently postedTechnology

Senior Data Developer

WoolpertBengaluru🇮🇳India

Quick overview

SeniorityMid-Senior
Work modeHybrid
LocationBengaluru, India
Talent AcquisitionSQLETLSnowflakeReconciliationAzurePower BISQL ServerData AnalysisAzure Data Factory

Job description

At Woolpert, you’ll do work that matters.

As a leading global architecture, engineering, and geospatial firm, we help clients solve complex challenges that shape communities, strengthen critical infrastructure, advance technology, and improve the world around us. Here, you’ll collaborate across disciplines, tackle meaningful projects, and build a career defined by growth, opportunity, and impact.

Position Overview

Woolpert is hiring a Senior Data Developer to join us. This is a hands-on technical role responsible for developing, maintaining, and supporting SQL-based data solutions across Woolpert’s business applications. The primary focus of this role is advanced SQL development, data analysis, and troubleshooting. The developer will work with SQL Server and Snowflake and partner with ETL and integration engineers by providing the SQL development, transformation, validation, and data troubleshooting needed to support integration and migration processes. Working knowledge of Azure Data Factory and Power BI is required to effectively support these processes.

We are unable to provide visa sponsorship for this position. Applicants must already possess work authorization in the country the job is located.

What You Will Do:

  • SQL Development & Database Programming

    • Design, develop, and maintain complex SQL queries, stored procedures, views, functions, and database objects.
    • Analyze business and technical requirements and translate them into practical SQL-based solutions.
    • Optimize SQL queries and database processes for performance, reliability, and maintainability.
    • Develop transformation, validation, reconciliation, and data-cleansing logic for migration, reporting, and operational needs.
    • Maintain clear documentation for SQL solutions, data mappings, business rules, and support procedures.

    Data Analysis & Troubleshooting

    • Investigate complex data issues by tracing records across source systems, transformation layers, and target outputs.
    • Perform data profiling, comparison, reconciliation, and exception analysis to identify missing, duplicate, inconsistent, or incorrectly transformed records.
    • Use SQL queries, execution plans, logs, and available monitoring tools to identify root causes and recommend practical resolutions.
    • Provide clear technical findings and support production issue resolution in partnership with application and business teams.

    Data Integration & ETL Support

    • Work with ETL and integration engineers to understand data flows, mappings, and transformation requirements.
    • Develop SQL-based transformation and validation logic to support ETL processes and data movement.
    • Apply working knowledge of Azure Data Factory and Snowflake to support data validation and troubleshoot data-related pipeline issues.

    Reporting & Data Support

    • Prepare and optimize SQL views and data sets used by Power BI reports and operational reporting.
    • Support troubleshooting of data refresh, transformation, and reporting data issues.
    • Validate reporting outputs and work with stakeholders to resolve data discrepancies.

What You Will Bring:

  • Education & Experience

    • Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
    • Solid hands-on experience in SQL development, database programming, data analysis, or a closely related role.
    • Experience developing and supporting data solutions in enterprise environments, including production troubleshooting.
    • Experience working through development, testing, deployment, and post-production support activities.

    Technical Expertise

    • Advanced SQL capability, including complex joins, common table expressions, window functions, stored procedures, query optimization, and performance tuning.
    • Hands-on experience with SQL Server and SQL Server Management Studio.
    • Working knowledge of Snowflake, including querying, data transformation, and troubleshooting.
    • Working knowledge of Azure Data Factory with the ability to understand and support ETL data flows and pipeline issues.
    • Experience preparing and validating data for Power BI reports, semantic models, and scheduled refreshes.

    Analytical & Problem-Solving Skills

    • Advanced analytical and troubleshooting skills with the ability to independently investigate complex data problems.
    • Strong attention to detail and a disciplined approach to data validation, reconciliation, and root-cause analysis.
    • Ability to explain technical findings, data issues, and recommended fixes clearly to technical and business stakeholders.
    • Ability to manage multiple development and support priorities in a deadline-driven environment.

    Technical Skills Summary

    • SQL Server and SQL Server Management Studio
    • Advanced SQL development and performance tuning
    • Data profiling, validation, and reconciliation
    • Snowflake
    • Azure Data Factory
    • Microsoft Power BI
    • ETL process understanding and support
    • Production troubleshooting and root-cause analysis

Benefits You Will Love

Certified as a Great Place to Work, Woolpert is one of the fastest-growing architecture, engineering, and geospatial companies in the world. With over 75 offices and countless projects around the globe, you’ll work on meaningful assignments that improve quality of life around the world. In addition to offering competitive pay, we provide employees with a robust set of unique benefits, including:

  • Freedom to Work program: Set your own schedule and location (as appropriate).
  • Flexible paid time off/vacation: Take time off when it makes sense for you and your team.
  • Career development: Explore a wide range of learning and growth opportunities within and across industries.
  • Health, life, vision, and dental insurance: Cover all your medical bases.
  • Paid sick time, retirement plan, fitness reimbursement, pet insurance, identity protection, technology stipend, employee assistance program, and more!

Find out more about what Woolpert has to offer here: http://woolpert.com/about-us/

Woolpert is an equal-opportunity employer. Woolpert is committed to the full inclusion of all individuals. We recruit, train, compensate, and promote regardless of race, religion, color, national origin, sex, disability, age, veteran status, and other protected status as required by applicable law. You may view more about EEO on our website: Equal-Employment-Opportunity-The-Law.pdf and EEO is the Law Poster Supplement.

Applicants who require an accommodation throughout the application and interview process should request this in advance by contacting your Recruiter

To all agencies: Please, no phone calls or emails to any employee of Woolpert or any of our subsidiaries about this requisition. All resumes submitted by search firms/employment agencies to any employee at Woolpert via email, the internet, or in any form and/or method will be deemed the sole property of Woolpert, unless such search firms/employment agencies were engaged by Woolpert's Talent Acquisition Team for this requisition and a valid agreement is in place. In the event a candidate who was submitted outside of Woolpert's applicant process is hired, no fee or payment of any kind will be paid.

Haystack's AI agent can fill in and submit this application for you. How AI auto apply works

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs