Senior Datawarehouse & Etl Developer (Contract)

We are seeking a highly experienced and specialized Senior Datawarehouse and ETL Developer ( SME ) to join our data and analytics team. The ideal candidate will have a proven track record of designing, developing, and maintaining large-scale data warehouse systems, ETL processes, and BI reporting solutions. This role requires deep expertise in SQL Server, SSIS, SSRS, SSAS, and metadata management, with a strong emphasis on managing data from multiple sources and ensuring data quality and integrity.

Experience :
10 + Years

Work Location :
Changi

Note:
Position requires the ability to work various work schedules that may include night standby, scheduled weekend activity and/or holiday activities.

Role :
Contract

Key Responsibilities:

• Data Warehouse Management:
  Oversee the processing and maintenance of Datawarehouse Analytics (DWA) and Enterprise Data Analytics (EDA) systems.
  Ensure the Data Warehouse and Enterprise Platforms are fully operational post-patching and during peak usage periods.
  
  
• ETL Development:
  Design and develop SSIS/SQL ETL solutions to acquire and prepare data from various upstream systems.
  Debug and tune SSIS, SQL Agent jobs, and other ETL processes to ensure accurate and efficient data movement.
  Develop and maintain meta-data driven SSIS packages to automate data integration.
  
  
• BI Reporting:
  Lead the creation of BI reports and dashboards using SSRS, Power BI, and other reporting tools.
  Design and develop data models, data integration routines, and analytics reports to support business requirements.
  
  
• Production Support:
  Provide routine production support, troubleshoot user issues, and handle data extraction requests.
  Manage ITSM ticketing system queries and extend support during budget cycles.
  Conduct data validation, reconciliation, and quality control checks to ensure data accuracy.
  
  
• Data Integration and Migration:
  Execute data migration projects, including the transition from on-premise to network-attached storage for BI projects.
  Develop automated processes for access reviews of gaming systems within defined timelines.
  
  
• Stakeholder Engagement:
  Engage with customers and stakeholders to translate business use cases and requirements into technical solutions.
  Work closely with application teams and business users to design, model, develop, and maintain SQL database objects.
  
  
• Technical Documentation and Best Practices:
  Document designs, data mappings, integration workflows, and load processes.
  Establish and enforce technical best practices for data movement, data quality, and data cleansing.
  
  

Experience :
10 + Years

Must-Have Skills:

• Extensive experience with SQL Server, SSIS, SSRS, and SSAS.
  
• Proficiency in metadata management and data validation techniques.
  
• Strong understanding of data warehouse architecture and ETL processes.
  
• Proven ability to debug and tune complex ETL solutions.
  
• Expertise in BI tools such as Power BI &
  Tableau,
  
• Familiarity with cloud technologies (Alibaba Cloud, Microsoft Azure) and PaaS (Dataphin).
  
• Proficiency in Python and JavaScript for scripting and automation tasks.
  
• Experience with ITSM systems and routine production support.
  
• Strong analytical skills and attention to detail.
  

Requirements and Qualifications:

• Bachelor’s degree in Engineering, Computer Science, or a related field.
  
• Over 10 years of professional experience in SQL, ETL, and BI reporting.
  
• Demonstrated experience in managing large-scale data warehouse systems.
  
• Strong project management and organizational skills.
  

Note:
Position requires the ability to work various work schedules that may include night standby, scheduled weekend activity and/or holiday activities.