L3 Support (DWH)

Ework Group, founded in 2000 and listed on Nasdaq Stockholm, has around 13,000 independent professionals on assignment. The company provides total talent solutions partnering with clients in private and public sectors, focusing on IT/OT, R&D, Engineering, and Business Development. This role is for a Backend Developer (DWH L3 Support) for a global IT company client.

• Strong experience with Microsoft SQL Server, including managing data warehouse schemas, index tuning, and advanced SQL query optimization
• Practical knowledge of SSIS, including package maintenance, delta/incremental loads, and deployment via SSIS Catalog
• Hands-on experience with SSAS, including multi-dimensional cubes and tabular models, and writing/modifying DAX and MDX expressions, KPIs, and dimensions
• Experience managing and troubleshooting SQL Server Agent Jobs
• Minimum 3+ years of experience in L2/L3 Application Support (AMS) or production maintenance within a Data Warehouse/BI environment
• Proven experience in monitoring batch jobs, investigating processing failures, and conducting Root Cause Analysis (RCA) to deliver permanent hotfixes
• Familiarity with ITSM/AMS processes: Incident, Problem, Change, and Release Management under strict SLA guidelines
• Experience supporting production deployments, code rollbacks, and data reconciliation activities

• L2/L3 support for SSIS packages, SSAS cubes/tabular models, and SQL-based data warehouse jobs
• Monitor and resolve batch job failures, data load issues, and cube processing failures
• Perform root cause analysis (RCA) and implement permanent fixes for recurring incidents
• Support production deployments, hotfixes, and rollback activities
• Ensure SLA adherence for incidents, service requests, and problem management
• Support business and upstream/downstream teams during data issues and reconciliations
• Implement small enhancements in SSIS (new columns, logic changes, source additions)
• Modify SSAS measures, dimensions, KPIs, DAX / MDX calculations as per business requests
• Enhance existing data models to support new reports or analysis
• Work on delta loads, performance improvements, and optimization of ETL & cubes
• Update technical design documents and impact analysis for changes
• Maintain SQL Server data warehouse schemas (facts, dimensions, staging tables)
• Optimize SQL queries, indexes, and ETL performance
• Handle data quality checks, reconciliation, and historical data management
• Support incremental loads, archiving strategies, and capacity planning
• Follow AMS processes: incident, problem, change, and release management
• Support code deployments via SSIS Catalog, SQL Agent Jobs, and controlled releases
• Participate in client discussions for issue resolution and minor change request clarifications
• Provide knowledge transfer/support documentation and contribute to knowledge base articles