Company Description
IQ-EQ is a leading investor services group offering a unique mix of global expertise and a profound understanding of our clients' needs. We have the specific knowledge and personal understanding that enables us to provide a wide array of compliance, administration, asset, and advisory services to investment funds, global companies, family offices, and private clients around the world.
IQ-EQ employs over 3,000 people worldwide, located in 23 jurisdictions, and manages assets (AUA) exceeding US$500 billion. We work with eight out of the top 10 global private equity firms.
This is a dynamic time to join IQ-EQ. We're experiencing substantial growth and we're currently seeking talented data-oriented individuals to be a part of our journey into the Data, Analytics and Reporting Department. You will have the chance to leverage IQ-EQ's leading-edge technology while enjoying our ongoing learning and development program.
Job Description
What does the Senior Data & Analytics BI Developer opportunity entail?
You will play a crucial role in the development and maintenance of operational reports and interactive investor dashboards using Tableau, Power BI, and SSRS. You'll collaborate closely with senior stakeholders to understand their BI needs, conduct data analysis with Python (or other open-source languages), and present insights compellingly.
Successful candidates will need the following experience
- Experience with structured and unstructured database warehouses (SQL server) and data lakes (Snowflake), both on-premise and cloud-based (AWS, Azure, or GCP) (5+ years on SQL and 2+ years on Snowflake)
- Advanced knowledge of Python/Spark packages for data analysis (Pandas, Numpy, scikit, etc.) and data visualization (matplotlib, plotly, dash, etc.)
- Advanced knowledge of Tableau or Power BI (3+ years of demonstrable experience)
- Experience with various Java libraries for frontend development (D3, react, node, etc.)
- Knowledge of various ETL/ELT tools like Alteryx, dbt, airflow, SSIS
Daily responsibilities include:
- Engaging with internal stakeholders from operations and client services teams to understand their reporting and dashboard requirements
- Creating high-level architecture for the BI solution
- Conducting in-depth exploratory data analysis and defining business-critical features
- Collaborating with database administrators, solutions architects, data engineers, and data scientists to develop advanced visualizations (BI dashboards)
- Retrieving data from databases and optimizing SQL server queries to efficiently and quickly retrieve data
- Ensuring updates to tickets and work progress are well communicated, and support-related escalations are minimized
- Designing data solutions, developing and creating best-practice data warehouse solutions that support business reporting tasks
- Creating and maintaining reporting processes
- Resolving IT and data issues by understanding and addressing any issues with legacy solutions
Qualifications
Must-Have:
- Degree level education is preferred but equivalent professional IT experience is also acceptable
- 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, SSRS
- Experience with MS Excel including PowerPivot
- Experience of supporting a variety of SQL based applications
- Hands-on experience with SQL 2012 and above
- Experience with T-SQL and ability to analyse queries for efficiency
- Experience with MS SQL Server suite, including SSIS and SSRS
- Experience with version control software such as Git, Bitbucket
Additional Information
At IQ-EQ, we're committed to helping you reach your full potential. We foster an inclusive and diverse environment that supports your career ambitions. With a strong focus 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.