Job Title: SSRS/SSIS Developer – Lead
Location: Singapore
Experience: 7 - 8 Years
Job Summary:
We
are seeking a highly experienced and technically proficient SSRS/SSIS Developer
Lead to join our Data & BI team in Singapore. The ideal
candidate will be responsible for leading the design, development, and
deployment of business intelligence solutions using Microsoft SQL Server
Reporting Services (SSRS) and SQL Server Integration Services (SSIS). The
candidate should have strong data warehousing knowledge, a track record of
leading small to mid-size BI teams and delivering scalable reporting and ETL
solutions.
Mandatory Skills
·
7+
years of experience in SSRS and SSIS development
·
Strong
experience in T-SQL, stored procedures, and performance tuning
·
Expertise
in ETL process design, development, and optimization
·
Experience
with data warehousing concepts and dimensional modeling
·
Experience
working with large datasets and complex reporting requirements
Key Responsibilities
·
Lead
the development and maintenance of SSRS reports and SSIS ETL packages
·
Gather
and understand reporting/ETL requirements from stakeholders
·
Design
efficient ETL processes to support data integration and warehousing needs
·
Optimize
report performance and ensure high availability of reporting systems
·
Provide
technical mentorship to junior developers
·
Perform
data validation, quality checks, and troubleshooting
·
Work
closely with DBAs, Data Architects, and business analysts to deliver data
solutions
·
Maintain
documentation for solutions, processes, and best practices
·
Ensure
adherence to SLAs and compliance standards in project execution
Qualifications
·
Bachelor’s
or Master’s degree in Computer Science, Information Systems, or related field
·
Microsoft
certifications in SQL Server / BI stack preferred
Technical Skills
·
SSRS,
SSIS, T-SQL, SQL Server 2016/2019/2022
·
Experience
with SQL Server Agent, Job Scheduling, and automation
·
Familiarity
with source control tools (Git, TFS)
·
Working
knowledge of Power BI (a plus)
·
Experience
with Agile/Scrum methodology
·
Exposure
to cloud-based data platforms (Azure Data Factory, Synapse – desirable)
Soft Skills
·
Strong
analytical and problem-solving skills
·
Excellent
communication and client interaction skills
·
Leadership
and team management abilities
·
Ability
to multitask and prioritize tasks effectively
·
Detail-oriented
and process-driven mindset
Good to Have
·
Knowledge
of Power BI dashboards and integration with SSRS
·
Experience
in Azure Data Services or AWS equivalent
·
Understanding
of DevOps for database deployments
·
Exposure
to CI/CD pipelines for database and ETL deployments
Work Experience
·
7+
years of professional experience in SSRS/SSIS
·
Minimum
2 years in a technical lead or senior developer capacity
Compensation & Benefits
·
Competitive
salary and annual performance-based bonuses
·
Comprehensive
health and optional Parental insurance.
·
Optional
retirement savings plans and tax savings plans.
Key Result Areas (KRA)
·
Timely
delivery of high-quality reports and ETL solutions
·
Accurate
interpretation of business requirements into BI solutions
·
Improvement
in reporting system performance and reliability
·
Mentoring
junior team members and building technical capability
·
Contribution
to architecture and design discussions for BI platforms
Key Performance Indicators (KPI)
·
≥
95% on-time delivery of reports and ETL solutions
·
≥
98% success rate for SSIS/ETL job executions
·
≤
24–48 hours average issue resolution turnaround
·
≥
4.5/5 stakeholder satisfaction rating
·
≥
10 hours per quarter spent on mentoring and knowledge sharing
·
≤
2 defects per release cycle in code reviews
·
≥
99.5% uptime of reporting systems and dashboards
·
100%
adherence to technical documentation standards
Contact: hr@bigtappanalytics.com