Woolpert

Senior Data Developer

Woolpert
Apply
10 hours ago
Bengaluru, IndiaSenior

Responsibilities

  • Design, develop, maintain, and optimize complex SQL queries, stored procedures, views, functions, and database objects.
  • Translate business and technical requirements into SQL-based solutions and document data mappings, business rules, and support procedures.
  • Develop transformation, validation, reconciliation, and data-cleansing logic for migration, reporting, and operational needs.
  • Investigate complex data issues across source systems, transformation layers, and target outputs using queries, execution plans, logs, and monitoring tools.
  • Perform data profiling, comparison, reconciliation, and exception analysis to identify missing, duplicate, inconsistent, or incorrectly transformed records.
  • Partner with ETL and integration engineers to support data flows, mappings, transformations, migrations, and pipeline troubleshooting.
  • Prepare and optimize SQL views and datasets for Power BI reports and operational reporting.
  • Support production issue resolution and communicate technical findings and recommended fixes to technical and business stakeholders.

Requirements

  • 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 enterprise data solutions, including production troubleshooting.
  • Experience across development, testing, deployment, and post-production support activities.
  • Advanced SQL skills 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 and Azure Data Factory for querying, transformation, ETL support, and pipeline troubleshooting.
  • Experience preparing and validating data for Power BI reports, semantic models, and scheduled refreshes.
  • Advanced analytical, troubleshooting, data validation, reconciliation, and root-cause analysis skills.
  • Ability to explain technical findings clearly and manage multiple development and support priorities.

Benefits

  • Freedom to Work program allowing employees to set their own schedule and location as appropriate.
  • Flexible paid time off and vacation.
  • Career development and learning opportunities.
  • Health, life, vision, and dental insurance.
  • Paid sick time, retirement plan, fitness reimbursement, pet insurance, identity protection, technology stipend, and employee assistance program.

Tech Stack

Microsoft SQL ServerSnowflakeSQL

Categories

Data Engineering
Woolpert

About Woolpert

1,001-5,000 employees

Woolpert is a privately held architecture, engineering, and geospatial services firm that delivers design, mapping, surveying, and infrastructure consulting to public-sector agencies, utilities, and commercial clients. Founded in 1911 and headquartered in Dayton, Ohio, it provides project-based services spanning transportation, water, aviation, and infrastructure management, including photogrammetry and remote sensing. The company operates from more than 75 offices across five continents.

Contact me