Duties and Responsibilities

• Translate business needs to technical specifications
• Design and develop databases, SQL queries, stored procedures, reports, dashboards and integration solutions for both real time and batch environments.
• Design, build and deploy BI solutions (e.g. reporting tools)
• Maintain and support data analytics platforms (e.g. MicroStrategy)
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation

Requirements

• Proven experience as a BI Developer or Data Scientist.
• Industry experience is preferred.
• Background in data warehouse design (e.g. dimensional modelling) and data mining.
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI, etc)
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), SQL Analysis Services (including Tabular Models), SQL Master Data Services and SQL Data Quality Services.
• Experience working on Microsoft Performance Point Services will be beneficial.
• Experience working on Azure or AWS will be beneficial.
• Proven abilities to take initiative and be innovative.
• Analytical mind with a problem-solving aptitude.
• Minimum 5-8 years’ experience in SQL development.
• Minimum 5-8 years’ experience in Business intelligence and data warehousing.
• Relevant certifications will be an advantage
• Financial System experience will be an advantage

Skills Required

• Good verbal and written communication skills
• Creative thinking and problem-solving skills
• Tenacity to pursue finding solutions to complex problems
• Ability and willingness to learn from and share skills with colleagues
• Team-working Skills
• Ability to work independently and efficiently under deadlines
• Ability to complete work within estimated time constraints
• Time management skills to handle multiple tasks and prioritize work appropriately
• The drive and natural tendency to keep your technology skills up to date
• Ability to develop code and supporting unit tests. (Coverage assessment, mocking)
• Must be detailed oriented