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
Categories
Data Engineering
About Woolpert
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.
