Job responsibilities:
SSRS, SSAS Development:
- Design, develop, and deploy interactive and paginated reports using SSRS.
- Optimize reports for performance and maintainability.
- Optimizing and maintenance of 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 solution
- Develops detailed technical work plans, estimates, improvement plans and status reports
- Perform regular peer-reviews, maintain low technical debts, assess & up-skill junior staffs
- Take ownership and leadership of medium-size projects
- Able to mentor / guide Junior Devs or Team members on the technical and project knowledge acquired
- Prepare KPI and report to transverse project manager and management about the projects in your scope
- Contribute to initiatives managed at department level (continuous improvement, innovation…)
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 solution and Challenge and Recommend solutions as per the business needs in compliant to 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 modelling.
- 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
Interested applicants please send your resume in MS Words format and attention it to Tan Joanna (R1104661)
Short listed candidates will be notified
www.ambition.com.sg
EA Registration Number: R1104661
Data provided is for recruitment purposes only
Business Registration Number: 200611680D. Licence Number: 10C5117
