Fund Services – Senior Business Solutions Specialist – Data (SQL/Python/ML/AWS)

Job Duties in Brief:

Your Role:

 Develop and execute database queries and conduct data analyses

 Create scripts to analyze and modify data, import/export scripts and execute stored procedures

 Model data by writing SQL queries/Python codes to support data integration and dashboard

requirements

 Develop data pipelines that provide fast, optimized, and robust end-to-end solutions

 Leverage and contribute to design/building relational database schemas for analytics. Handle and

manipulate data in various structures and repositories (data cube, data mart, data warehouse,

data lake)

 Analyze, implement and contribute to building of APIs to improve data integration pipeline

 Perform data preparation tasks including data cleaning, normalization, deduplication, type

conversion etc.

 Perform data integration through extracting, transforming and loading (ETL) data from various

sources.

 Identify opportunities to improve processes and strategies with technology solutions and identify

development needs in order to improve and streamline operations 

 Create tabular reports, matrix reports, parameterized reports, visual reports/dashbords in a

reporting application such as Power BI Desktop/Cloud or QLIK

 Integrating PBI/QLIK reports into other applications using embedded analytics like Power BI

service (SaaS), or by API automation is also an advantage

 Implementation of NLP techniques for text representation, semantic extraction techniques, data

structures and modelling

 Contribute to deployment and maintainence of machine learning solutions in production

environments

 Building and Designing cloud applications using Microsoft Azure/AWS cloud technologies.

About You:

Background / Qualifications

 Bachelor's Degree in technology/related field or equivalent work experience

 4+ Years of SQL and/or Python experience is a must

 Strong knowledge of data concepts and tools and experienced in RDMS such as MS SQL Server,

Oracle etc.

 Well-versed with concepts and techniques of Business Intelligence and Data Warehousing.

 Strong database designing and SQL skills. objects development, performance tuning and data

analysis

 In-depth understanding of database management systems, OLAP & ETL frameworks

 Familiarity or hands on experience working with REST or SOAP APIs

 Well versed with concepts for API Management and Integration with various data sources in

cloud platforms, to help with connecting to traditional SQL and new age data sources, such as

Snowflake

 Familiarity with Machine Learning concepts like feature selection/deep learning/AI and ML/DL

frameworks (like Tensorflow or PyTorch) and libraries (like scikit-learn, StatsModels) is an

advantage

 Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) is an advantage

 Hands-on experience at least in one ETL tool (SSIS, Informatica, Talend, Glue, Azure Data

factory) and associated data integration principles is an advantage

 Minimum 1+ year experience with Cloud platform technologies (AWS/Azure), including Azure

Machine Learning is desirable. Following AWS experience is a plus:

o Implementing identity and access management (IAM) policies

o Managing user accounts with IAM

o Knowledge of writing infrastructure as code (IaC) using CloudFormation or Terraform.

o Implementing cloud storage using Amazon Simple Storage Service (S3)

o Experience with serverless approaches using AWS Lambda, e.g. AWS (SAM)

o Configuring Amazon Elastic Compute Cloud (EC2) Instances

Previous Work Experience: 

 Experience querying databases and strong programming skills: Python, SQL, PySpark etc.

 Prior experience supporting ETL production environments & web technologies such as XML is an

advatange

 Previous working experience on Azure Data Services including ADF, ADLS, Blob, Data Bricks,

Hive, Python, Spark and/or features of Azure ML Studio, ML Services and ML Ops is an

advantage

 Experience with dashboard and reporting applications like Qlik, Tableau, Power BI

Other:

 Well rounded individual possessing a high degree of initiative

 Proactive person willing to accept responsibility with very little hand-holding

 A strong analytical and logical mindset

 Demonstrated proficiency in interpersonal and communication skills including oral and written

English.

 Ability to work in fast paced, complex Business & IT environments

 Knowledge of Loan Servicing and/or Loan Administration is an advantage

 Understanding of Agile/Scrum methodology as it relates to the software development lifecycle

What We Offer:

 A rewarding and challenging environment that spans multiple geographies and multiple business

lines

 Great working environment, competitive salary and benefits, and opportunities for educational

support

 Be part of an industry leading global organisation, renowned for excellence

 Opportunities for personal and professional career development