23 hours ago
Sibiu, Romania +2 moreSenior
Responsibilities
- Analyze and resolve production incidents, technical issues, and data quality problems in existing data solutions.
- Troubleshoot and maintain T-SQL, stored procedures, views, functions, SQL Server Agent jobs, and ETL pipelines.
- Optimize SQL queries, database objects, execution plans, indexes, loading processes, and database performance.
- Maintain, stabilize, and selectively refactor legacy database and reporting logic.
- Monitor production environments, perform root-cause analysis, and document fixes and workarounds.
- Assess databases, dependencies, data flows, interfaces, jobs, reports, and semantic models to determine whether solutions should be maintained, migrated, consolidated, archived, or retired.
- Support controlled database decommissioning, including technical checks, documentation, and rollback options.
- Support data and logic migrations from RepSaS into target environments.
- Maintain and troubleshoot Power BI reports, datasets, and refresh processes.
- Maintain and optimize SSAS Tabular Models, including relationships, measures, processing, and DAX logic.
- Validate KPIs, data quality, and functional and technical consistency across reporting solutions.
- Document data flows, database objects, interfaces, dependencies, and retirement activities, and transfer technical knowledge within the team.
Requirements
- Several years of hands-on experience developing and supporting Microsoft SQL Server and BI solutions.
- Expert knowledge of Microsoft SQL Server, SQL Server Management Studio, and T-SQL.
- Strong experience with SQL performance tuning, execution plans, indexes, blocking, query analysis, and resource-intensive queries.
- Strong hands-on experience maintaining and troubleshooting SSIS and ETL pipelines.
- Strong experience with SSAS Tabular Models, semantic models, relationships, measures, processing, and troubleshooting.
- Strong experience with Power BI, including reports, datasets, data models, DAX, refresh processes, and permissions.
- Understanding of relational and dimensional data modeling, production monitoring, troubleshooting, and root-cause analysis.
- Experience with data lineage and dependency analysis across sources, targets, jobs, interfaces, and data consumers.
- Experience with Git, GitLab, SQL Server Agent, and job scheduling.
- Basic scripting and automation experience with PowerShell.
- Understanding of CI/CD processes for traceable builds, deployments, and technical quality assurance.
- Experience with legacy production systems, complex dependencies, limited documentation, and business-critical incident and bug-fix work.
- Experience with database consolidation, migration, or controlled decommissioning is highly desirable.
- Strong technical documentation and stakeholder communication skills, including advanced spoken and written English.
Tech Stack
Categories
Data Engineering
About NTT DATA
NTT DATA is a Tokyo‑headquartered, publicly traded IT services firm within the NTT Group. It provides consulting, application development, system integration, cloud and enterprise application services, and managed/outsourcing services for large enterprises and public-sector organizations. The company operates in more than 50 countries and is listed on the Tokyo Stock Exchange.
