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

Job Duties in Brief:

Your Role:

Develop and executedatabase queriesand conductdata analyses

Create scriptsto analyze andmodify data, import/export scripts and execute stored procedures

Model databy writingSQL queries/Python codesto supportdata integration and dashboard

requirements

Developdata pipelinesthat provide fast, optimized, and robust end-to-end solutions

Leverage and contribute to design/building relationaldatabase schemasfor analytics. Handle and

manipulate data in various structures andrepositories (data cube, data mart, data warehouse,

data lake)

Analyze, implement and contribute to building ofAPIs to improvedata integration pipeline

Perform data preparation tasks includingdata cleaning, normalization, deduplication, type

conversion etc.

Performdata integrationthrough 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 asPower BIDesktop/Cloud orQLIK

Integrating PBI/QLIK reportsinto other applications using embedded analytics like Power BI

service(SaaS), or byAPI automationis 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 ofSQL and/or Pythonexperience is a must

Strong knowledge of data concepts and tools and experienced in RDMS such asMS 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 withREST or SOAP APIs

Well versed with concepts forAPI Management and Integrationwith various data sources in

cloud platforms, to help with connecting totraditional SQLandnew age data sources, such as

Snowflake

Familiarity with Machine Learning concepts like featureselection/deep learning/AI and ML/DL

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

advantage

Familiarity withBI 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 infast 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