senior/bi developer in Singapore

posted
contact
sara sun, randstad
job type
permanent

job details

posted
location
singapore
specialism
information technology
job type
permanent
working hours
Full-Time
experience
3 years
reference number
91M0137636_1581038268
contact
sara sun, randstad
phone
+65 6510 1360
add to saved jobs print

job description

  • Stable end user company with listed MNC
  • Newly created regional role
  • work - life balance and friendly environment


about the job

  • Gather, analyze, and document reporting requirements, develop by yourself (both static reports and interactive dashboards).
  • Work closely with business stakeholders to make sure data definitions and technical logic specifications align with business requirements.
  • Perform data extractions via SQL and provide recommendation to business on data visualization and dashboards.
  • Perform data profiling and come up with recommendations and report data quality issues.
  • Document test plan, test cases, test scripts and perform QA activities.
  • Build/Improve automated workflows and data checks to provide smooth running, data integrity and
  • accurate reporting, ensuring consistency of information across reports.
  • Perform routine maintenance to ensure stability and performance of systems and data delivery on time
  • Analyze production problems, realize/recommend data correction.
  • Support remote BI users on: best practices on BI tools, where to find data, troubleshooting.
  • Maintain user guides and release notes up to date.
  • Perform upgrade of the systems and applications to the new versions.
  • Work with vendors (Microsoft) on technical issues resolution.
  • Create/Update technical documentation for database/ETL/reports.
  • skills and experience required
  • Minimum 3 years of experience in business intelligence development.
  • Possess hands-on Power BI and have working experience in manufacturing sector and supply chain knowledge.
  • Must have SQL knowledge and expected to be hands on and write complex SQL for data analysis.
  • Prior knowledge in modeling and designing relational DBs, star schema and cubes will be a plus.
  • Prior experience in ETL tools like SSIS will be a plus.
  • Must be able to work collaboratively with cross-functional teams to analyze and understand business
  • needs in order to translate them into system specifications and deliverable solutions.
  • Must be a team player
  • Self-starter with ability to work independently with minimal supervision and manage own workload
  • Able to communicate effectively with people at different levels including users, vendors, management, developers, etc.
  • Good verbal and written English
  • Hands on experience with Azure service like Data Factory, Azure Data Lake, Azure File Sync Agent
  • Hands on experience with Batch and PowerShell scripts

Good to have experiences (not a must):

  • Prefer with Datawarehouse knowledge include ETL and Modeling design
  • Prefer with finance knowledge
  • Hands on experience with writing complex stored procedure, view table
  • Experience with \understanding of (1) Qlikview, (2) Reporting service SSRS (3) Azure cloud services (4) MapR and Hadoop
  • Familiar with project management concepts (Waterfall and Agile)

To apply online please use the 'apply' function, alternatively you may contact Sara at 65101360.
(EA: 94C3609/R1763325 )




skills

no additional skills required

qualification

no additional qualifications required

educational requirements

Bachelor Degree