Software Developer

Job Responsibilities:

SSRS, SSAS Development:

• Design, develop, and deploy interactive and paginated reports using SSRS.
• Optimize reports for performance and maintainability.
• Optimize and maintain SSAS projects.
• Collaborate with stakeholders to gather requirements and deliver customized reporting solutions.
• Perform non-functional testing.

SSIS Development:

• Design and develop robust ETL workflows using SSIS to extract, transform, and load data from various sources.
• Monitor and troubleshoot SSIS packages for performance and error resolution.
• Implement data quality and validation checks during ETL processes.

Data Management & Analysis:

• Design and optimize database schemas to support BI solutions.
• Develop complex T-SQL queries, stored procedures, and functions for reporting and ETL purposes.
• Perform data profiling and ensure data accuracy and integrity.
• Knowledge in all other SQL server objects such as functions, views, synonyms, etc.

Collaboration & Documentation:

• Work closely with business analysts, data analysts, and other developers to understand business needs and translate them into technical solutions.
• Document technical designs, workflows, and user guides for BI solutions.

Performance Optimization:

• Conduct performance tuning of SSRS reports, SSIS packages, and SQL queries.
• Ensure efficient and scalable BI solutions that handle growing datasets.

Leadership and Project Management:

• Communicate and collaborate with architects, stakeholders, business, and project managers to gather requirements and define technical solutions.
• Develop detailed technical work plans, estimates, improvement plans, and status reports.
• Perform regular peer-reviews, maintain low technical debts, assess & up-skill junior staff.
• Take ownership and leadership of medium-size projects.
• Able to mentor/guide Junior Developers or Team members on the technical and project knowledge acquired.
• Prepare KPIs and report to transverse project manager and management about the projects in your scope.
• Contribute to initiatives managed at the department level (continuous improvement, innovation, etc.).

BAU:

• Provide L3 Support on applications - analyze and resolve issues as they arise.
• Maintain existing BI solutions/ETL pipelines and propose continuous improvements.
• Ability to design appropriate solutions and challenge and recommend solutions as per the business needs in compliance with the company’s standards.
• Ensure the respect of the company’s code of conduct and compliance rules within the team.

Requirements:

• At least 8 years of work experience in leading Microsoft BI projects, including SSRS, SSIS, and SQL Server.
• Strong proficiency in T-SQL, including query optimization and stored procedures.
• Hands-on experience with ETL processes and data integration using SSIS.
• Good exposure and usage experience in CI/CD tools/processes.
• Expertise in designing and developing reports using SSRS.
• Strong knowledge of relational database concepts and best practices.
• Familiarity with data warehousing principles and dimensional modeling.
• Excellent analytical and problem-solving skills.
• Strong communication skills and ability to work in a team environment.
• Relational databases – MSSQL.
• SSIS, SSRS, SSAS.
• PowerShell, Power BI, and other Microsoft technologies (.Net, .Net Core, C#) are a plus.
• Good to have knowledge or experience with Apache Spark SQL.
• Build management using TFS or Nexus.
• Workload automation and scheduling tools such as CTRL-M is a plus.
• Experience in Compliance, Capital Markets, or Market Abuse Domain is required.
• Experience in Enterprise-Wide Risk Assessment is a plus.