Franchise Data Engineering - BI
Franchise Data Engineering - Business Intelligence team is part of Global Banking & Markets division focused on building sustainable data models, efficient workflows and generate business insights to help the firm improve client service, and minimize risk in the post-trade flow processing across Securities and OTC Derivative products across Equities & FICC businesses.
HOW YOU WILL FULFILL YOUR POTENTIAL
The analyst role (2-4 years of experience) involves translating business problems into analytical solutions by crunching data into business decision model. The role requires end-end skills in data engineering, ETL, data modeling, math/logic, visualization, and continuous improvement lifecycle. It requires to establish data lineage across multiple analytical models to provide an exhaustive front to back data model servicing the post trade flow – starting from curating data, building data models, ETL pipelines, warehousing, visualizing and generating business insights.
SKILLS AND EXPERIENCE WE ARE LOOKING FOR
- Academic Qualifications: Engineering (or) masters in analytics/data science (or) any math/statistics/quant background
- Expertise in data munging/wrangling methods on large datasets
- Dimensional modeling, OLTP & OLAP structures, relational data models
- ETL processes, data integration, data quality framework
- Experience solving business problems using data and created analysis
- Databases/Warehousing Platforms: Microsoft SQL server, MySQL, MemSQL/Singlestore, AWS, Snowflake
- Analytics tools/platforms: Alteryx (preferred), RapidMiner, Informatica, Qliksense or similar
- Visualization: Tableau (preferred), Qlikview, PowerBI
- Programming languages: Python (Intermediate), R
- Experience working in a global team environment
- Good networking & communication skills
- Direct business stakeholder interaction & management
Preferred Qualifications:
- Has engineering or any quantitative background
- Hands-on experience of Data Engineering & BI – worked end-end from modeling data to analysis and solve business problems
- Expertise in relational DBs, data modeling and ability to convert business logic/decisions into business metrics
- Preferred MS-SQL, Alteryx, Tableau & Python