SQL Developer-30867] (Hyderabad)

SQL Developer-30867] (Hyderabad)

19 Nov
|
Talent500
|
Hyderabad

19 Nov

Talent500

Hyderabad

Talent500 is hiring for one of its clients.

About Itineris:

Itineris, with HQ in Belgium, is a global technology company purely focused on software and services for the energy and water industry. Itineris is the developer of UMAX, a customer information system (CIS) and ERP solution fully integrated with and leveraging the power of Microsoft’s Dynamics 365 platform.

Founded in 2003 and Microsoft Dynamics Global ISV, Itineris has a sound financial base and has established an impressive track record of successful implementations. Our clients are international and regional players such as De Watergroep, Eneco, Engie, SSE, City of New York, City of Baltimore, Boston Water and Sewer Commission, City of Dallas

Role focus: SQL-based reporting, controlled data correction, and SQL query optimization.

Role Purpose:

The SQL Developer – Reporting, Data Correction & SQL Optimization designs, develops, and maintains SQL-based reporting solutions that provide accurate, timely, and actionable business information. Working with functional consultants, support teams, and data owners, the role translates reporting requirements into robust SQL queries, reporting datasets, automated extracts, and business-facing outputs.

The role also strengthens enterprise data integrity. It investigates data anomalies, performs root cause analysis, and translates confirmed data errors into controlled, tested, auditable, and executable SQL correction scripts. The SQL Developer ensures that reporting outputs and the underlying data are reliable, explainable, and fit for operational and management use.

Key Responsibilities:

Reporting & Analytics:

- Design, develop, and maintain SQL queries, views, stored procedures, functions, and datasets for operational, management, and regulatory reporting.
- Translate business and functional requirements into efficient, scalable, and maintainable reporting solutions.
- Develop datasets and data models for consumption by Power BI, Excel, and other approved reporting platforms.
- Create reusable reporting components, standardized business rules, automated extracts, and clear sample outputs.




- Validate report outputs against documented requirements, source systems, and agreed acceptance criteria.

Data Quality, Investigation & Correction:

- Investigate data-integrity issues identified through reporting, operational processes, audits, testing, or support activities.
- Perform root cause analysis to identify the source of data discrepancies, processing failures, and reporting inconsistencies.
- Translate confirmed data errors and approved correction rules into protected, narrowly scoped, auditable, and executable SQL correction scripts.
- Include pre-execution checks, validation queries, transaction controls, and rollback logic where appropriate; test corrections in non-production before controlled release.
- Document assumptions, impacted records, approvals, execution evidence, validation results, and any residual risks.
- Identify recurring data-quality issues and recommend preventative controls, monitoring, or process improvements.

Database Performance & Engineering:

- Demonstrate strong SQL query optimization capability, including execution-plan analysis, indexing strategies, and performance tuning for large, complex datasets.
- Apply version control, peer review, naming conventions, structured testing, and deployment standards to SQL assets.

Stakeholder Collaboration:

- Work with business users, analysts, application specialists, testers, and support teams to translate reporting and data needs into precise technical specifications.
- Explain technical findings, data limitations, correction impacts, and solution options to technical and non-technical audiences.

Documentation, Security & Governance:

- Maintain clear technical documentation covering reports, datasets,



source mappings, business rules, dependencies, and correction scripts.
- Apply least-privilege access, secure handling of sensitive data, and organizational data-governance requirements.
- Ensure data corrections follow approved change, testing, segregation-of-duties, and audit processes.

Required Skills & Experience:

Technical:

- Strong Microsoft SQL Server and T-SQL development experience, including complex queries, views, functions, stored procedures, and reusable components.
- Proven SQL query optimization capability, including indexing, execution-plan analysis, performance troubleshooting, and tuning of large datasets.
- Experience developing datasets for Power BI, SSRS, Excel Power Query, or comparable reporting tools.
- Experience with data reconciliation, anomaly analysis, root cause investigation, and controlled, auditable data remediation.
- Knowledge of source control, release management, and structured testing practices.

Analytical & Professional:

- Strong analytical thinking, structured problem-solving, attention to detail, and the ability to turn ambiguous business needs into executable solutions.
- Clear communication and a collaborative working style, with the ability to explain SQL logic and data findings to business audiences.

Key Success Measures:

- Accuracy, reliability, usability, performance, and maintainability of reporting solutions.
- Timely correction of approved data issues without unintended impact, supported by complete testing evidence and audit trails.
- Reduction in recurring data-quality defects and manual reporting effort.
- Stakeholder adoption and compliance with security, release, and data-governance standards.

Role Profile:

This role is suited to a SQL professional who combines strong reporting-development capability with a data-stewardship mindset. The successful candidate does not only present business data; they investigate its reliability, convert confirmed defects into controlled technical corrections, and help prevent the same issues from recurring.

📌 SQL Developer-30867] (Hyderabad)
🏢 Talent500
📍 Hyderabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: sql developer-30867] (hyderabad) / hyderabad