BI Developer Associate

You are a strategic thinker passionate about driving solutions in BI and Analytics (Alteryx, SQL, Tableau), and you have found the right team. As a Business Intelligence Developer Associate within our Asset and Wealth Management Finance Transformation and Analytics team, you will be tasked with defining, refining, and achieving set objectives for our firm on a daily basis. You will be responsible for designing the technical and information architecture for the MIS (DataMarts) and Reporting Environments. Additionally, you will support the MIS team in query optimization and deployment of BI technologies, including but not limited to Alteryx, Tableau, MS SQL Server (T-SQL programming), SSIS, and SSRS. You will scope, prioritize, and coordinate activities with the product owners, design and develop complex queries for data inputs, and work on agile improvements by sharing experiences and knowledge with the team. Furthermore, you will advocate and steer the team to implement CI/CD (DevOps) workflow and design and develop complex dashboards from large and/or different data sets. 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 include a Bachelor's Degree in MIS, Computer Science, or Engineering. A different field of study with significant professional experience in BI Development is also acceptable. Strong DW-BI skills are required with a minimum of 7 years of experience in Data warehouse and visualization. You should have strong work experience in data wrangling tools like Alteryx and working proficiency in Data Visualizations Tools, including but not limited to Alteryx, Tableau, MS SQL Server (SSIS, SSRS). Working knowledge in querying data from databases such as MS SQL Server, Snowflake, Databricks, etc., is essential. You must have a strong knowledge of designing database architecture, building scalable visualization solutions, and the ability to write complicated yet efficient SQL queries and stored procedures. Experience in building end-to-end ETL processes, working with multiple data sources, handling large volumes of data, and converting data into information is required. Experience in the end-to-end implementation of Business Intelligence (BI) reports & dashboards, as well as good communication and analytical skills, are also necessary. Preferred qualifications, capabilities, and skills include exposure to Data Science and allied technologies like Python, R, etc. Exposure to automation tools like UIPath, Blue Prism, Power Automate, etc., working knowledge of CI/CD workflows and automated deployment, and experience with scheduling tools like Control M are considered advantageous.,