Company DescriptionIQ-EQ is a leading Investor Services group which combines global expertise with an unwavering focus on client service delivery. We support fund managers, global companies, family offices and private clients operating worldwide.
Job DescriptionThe Senior BI Developer will be responsible for the development and maintenance of operational reports and interactive investor dashboards using Tableau, Power BI and SSRS. You will work closely with senior stakeholders to capture their BI requirements, conduct data analysis using python (or any other open source languages), and visualise the insights in impactful manner. In order to be successful in this role you would possess below key requirements.Ø Experience of working with structured and unstructured database warehouses (SQL server) and datalakes (Snowflake) both on-prem and in cloud (AWS, Azure or GCP)
Ø Advance knowledge of Python/Spark packages for data analysis (panda, numpy, scikit, etc.) as well as data visualisation (matplotlib, plotly, dash, etc.)
Ø Knowledge of SQL Server SSIS and SSRS (at least 3 yrs of demonstrable experience)
Ø Experience of various java libraries for front end development (i.e. D3, react, node, etc.)
Ø Knowledge of various ETL/ELT tools like SSIS, alteryx, dbt, airflowTasks (what does the role do on a day-to-day basis)Engage with internal stakeholders from operations as well as client services team to understand their reporting and dashboard requirementsCreate a high-level architecture of the BI solutionConduct in-depth exploratory data analysis and define business critical featuresWork with database administrators, solutions architect, data engineers and data scientists to collaboratively develop advanced visualization (BI dashboards)Retrieve Data from Databases. Optimize SQL server queries to efficiently and quickly retrieve data.Ensure updates to tickets and work in progress are well commutated and escalations regarding the support being provided is kept to a minimumDesign Data Solutions. Develop and create and design best-practice data warehouse solutions that support business reporting tasks. This is achieved using different programs and software, such as Tableau, MS SQL Server and Microsoft Excel.Create and Maintain Reporting Processes. Develop and maintain a record of the different reporting processes in place.Resolve IT and Data Issues. When database issues arise or support requests come in through the help desk, BI Developers work to resolve these problems. This requires an understanding of legacy solutions and issues.
QualificationsEducation / professional qualificationsDegree level education is preferred but equivalent professional experience in IT is acceptable.Background experienceA Minimum of 5 years’ experience in a (senior) developer role or similar DB experience.Experience with other visualization and reporting tools like Tableau, Power BI, Qlikview, Looker, SSRSExperience with MS Excel including PowerPivotTechnicalExperience of supporting a variety of SQL based applications.Hands on experience with SQL 2008 and aboveExperience with T-SQL and the ability to analyse queries for efficiency.Experience with MS SQL Server suite, including SSIS and SSRSLanguages
EnglishAdditional InformationAt IQ-EQ we want you to reach your full potential. We offer an inclusive and diverse environment to support your career aspirations. With a strong emphasis on continuous learning and a holistic approach to your professional and personal development. We also offer opportunities across our service lines and our international network of offices.
