You are a strategic thinker passionate about driving solutions in BI and Analytics (Alteryx, SQL, Tableau), you have found the right team.

As a BI Developer – Senior Associate within the Asset and Wealth Management Finance Transformation and Analytics team, you will spend each day defining, refining, and delivering set goals for our firm.

Job Responsibilities:

Design the technical and information architecture for the MIS (DataMart’s) and Reporting Environments.Focuses on data modelling and database design for the AWM LOB.Support the MIS team in query optimization, and deployment of BI technologies including but not limited to Alteryx, Tableau, Databricks, MS SQL Server (T SQL programming) /SSIS and SSRS. Design and develop complex dashboards from large and/or different data sets.Scope, prioritize and co-ordinate activities with the product owners. Partner with technology teams to identify solutions required to establish a robust MIS environment.Design and develop complex queries which caters to data inputs for the dashboards/reports from large data sets.Work on the agile improvements by sharing experiences and knowledge with the team. Advocate and steer the team to implement CI/CD (Devops) workflow. Overall, the ideal candidate for this position will be highly skilled in reporting methodologies, data manipulation & analytics tools and have expertise in the visualization and presentation of enterprise data.

Required qualifications, capabilities and skills

Bachelor’s Degree in MIS, Computer Science, or Engineering.  Different field of study, with significant professional experience in BI Development, is acceptable. Strong Data Warehousing-BI Skills. Experience Required: 12+ in Data warehouse, ETL and visualization.Strong work experience in data wrangling tools like Alteryx.Working Proficiency on Data Visualizations Tools. Experience on BI technologies not limited to Alteryx, Tableau, MS SQL Server (SSIS,SSRS), Databricks, ThoughtSpotWorking knowledge in querying data from databases such as MS SQL Server, Snowflake, Databricks etc.Strong knowledge of designing database architecture and building scalable visualization solutions. Ability to write complicated yet efficient SQL queries and stored procedures.Working experience on building end to end ETL processes. Experience in working with multiple data sources and handling large volumes of data. Experienced in conversion of data into information. Experience in end-to-end implementation of Business Intelligence (BI) reports & dashboards. Good communication and analytical skills

Preferred qualifications, capabilities and skills

Exposure to cloud based Analytics, Python would be an added advantageExposure to automation tools like UIPath, Blue Prism, Power Automate etc.Working knowledge on CI/CD workflows and automated deployment and experience on scheduling tools like Control M.