Senior Analytics Engineer

Office: India based (Hybrid) Travel (Internationally) may be required therefore access to major transport hub very desirable.

Department: Technology  

Reports to:    Head of Data Analytics & BI Development

About IQ-EQ:

IQ-EQ is a leading investor services group that brings together that rare combination of global expertise and a deep understanding of the needs of clients. We have the know-how and the know you that allows us to provide a comprehensive range of compliance administration asset and advisory services to investment funds global companies family offices and private clients globally.

IQ-EQ employs a global workforce of 5000 people located in 23 jurisdictions and has assets under administration (AUA) exceeding US$500 billion. IQ-EQ works with eight of the top 10 global private equity firms.

This is an exciting time to be part of IQ-EQ we are growing substantially and currently seeking talented Data individuals to come along for the journey into the Data Analytics and Reporting Department. You will have the opportunity to utilise IQ-EQs leading-edge technology stack whilst enjoying our continuous learning and development programme.

What does the Senior Analytics Engineer opportunity look like for you

You will play a pivotal role in the development and maintenance of interactive client investor and operational team facing dashboards using Tableau Power BI and other visual analytics tools. You will work closely with clients and senior stakeholders to capture their BI requirements conduct data analysis using SQL Python (or other open-source languages) and visualise the insights in an impactful manner.

In order to be successful in this role we require the following experience

• Ability to apply advanced working knowledge of conceptual and physical BI implementations to demonstrates they are an expert within the area of Analytics and BI
• Adept at interacting directly with external clients in a verbal manner as well as having the interpersonal savvy to pick up on the nuances within the conversation from one client to the next and through those interactions be able to conceptualise what the overall end-to-end database architecture and data model would look like from the source to the destination of the data
• Advanced hands-on experience of working with and querying structured semi-structured and unstructured data within data warehouses data lakehouses and data lakes both on-prem and in cloud (Microsoft SQL Server Azure AWS or GCP)
  • at least 8 yrs. of demonstrable advanced experience in SQL Server and cloud-based data stores to implement complex and robust solutions
• Advanced hands-on experience of ETL / ELT methods such as incremental and full load as well as advanced experience of the various tools to implement these methods such as Microsoft Fabric Azure Synapse Azure DataBricks Azure Data Factory SSIS Python dbt Kafka airflow to cater for complex data flows (at least 8 yrs. of demonstrable experience)
• Advanced hands-on experience of implementing real-time near real-time or low latency analytics solutions (at least 8 yrs. of demonstrable experience)
• Advanced hands-on experience of implementing dimensional data models within analytics databases / data warehouses
• Advanced hands-on experience of working with Python / Spark packages for analytical data modelling data analysis and data flows (panda NumPy scikit etc.) as well as data visualisation (matplotlib plotly dash etc.) to solve complex problems
• Advanced hands-on experience of BI tools Power BI Tableau etc. (at least 7 yrs. of demonstrable experience) showcasing advanced storytelling and deep insights
• Advanced experience of various java libraries for front end development and embedding of visuals (i.e. D3 react node etc.)
• Ability to take a broad perspective to identify solutions and work independently with guidance in only the most complex situations
• Ability to guide others in resolving complex issues

Tasks (what does the role do on a day-to-day basis)

• Engaging with external clients vendors project reps internal stakeholders from operations as well as client services teams to understand their analytics and dashboard requirements and interpret them into technical specifications
• Creating and maintaining high-level database and model architecture of the BI solution recommending best practice
• Conducting in-depth exploratory data analysis and define business critical features and critical data elements
• Working with key teams within Group Technology to get appropriate access and infrastructure setup to develop advanced visualisations (BI dashboards)
• Creating and optimize SQL Server stored procedures views queries as well as queries from multiple data sources to efficiently and effectively retrieve data from databases employing the fundamentals of dimensional data modelling
• Designing and creating advanced and robust Data Solutions to develop best practice data warehouse solutions that support business analytics asks
• Creating maintaining and document the different analytics solution processes created per project worked on
• Resolving IT and Data Issues. When database issues arise or support requests come in through Azure DevOps or the help desk BI Developers are expected to work to resolve these problems. This requires a good understanding of legacy solutions and issues.
• Ensuring updates to Azure DevOps items help desk tickets and work in progress are well communicated and escalations regarding the support being provided is kept to a minimum

Key competencies for position and level (see Group Competency model)

• Analytical Reasoning Ability to identify patterns within a group of facts or rules and use those patterns to determine outcomes about what could / must be true and come to logical conclusions
• Critical Thinking Ability to conceptualise analyse synthesise evaluate and apply information to reach an answer or conclusion
• Conceptual Thinking and Creative Problem Solving - Original thinker that has the ability to go beyond traditional approaches with the resourcefulness to adapt to new / difficult situations and devise ways to overcome obstacles in a persistent manner that does not give up easily
• Interpersonal Savvy Relating comfortably with people across all levels functions cultures & geographies building rapport in an open friendly & accepting way
• Effective Communication Adjusting communication style to fit the audience & message whilst providing timely information to help others across the organisation.  Encourages the open expression of diverse ideas and opinions
• Results / Action Orientated and Determination Readily taking action on challenges without unnecessary planning and identifies new opportunities taking ownership of them with a focus on getting the problem solved

Key behaviours we expect to see

In addition to demonstrating our Group Values (Authentic Bold and Collaborative) the role holder will be expected to demonstrate the following:

• Facilitate open and frank debate to drive forward improvement
• Willingness to learn develop and keep abreast of technological developments

An analytical mind excellent problem-solving & diagnostic skills attention to detail

Qualifications :

Required Experience

Education / professional qualifications

• Degree level education in Data Analytics or Computer Science is preferred but equivalent professional IT certification is acceptable.

Background experience

• A minimum of 8 years experience in a (senior) developer / engineer role or similar DB experience.
• Experience in leading teams or projects
• Deep understanding of dimensional data modelling methodologies
• Advanced experience with visualization and reporting tools namely Tableau and Power BI as well as Qlikview Looker ThoughtSpot
• Experience with Microsoft Fabric Platform
• Experience with PowerAutomate
• Experience with MS Excel including PowerPivot

Technical

• Advanced experience of developing and supporting a variety of SQL based applications.
• Advanced Hands on experience with SQL 2016 and above
• Advanced Experience with T-SQL and the ability to analyse queries for efficiency.
• Advanced experience with MS SQL Server suite including SSIS
• Advanced experience with Microsoft Fabric Azure Synapse Azure Databricks Fabric Data Factory Azure Data Factory
• Advanced experience in both batch (incremental and full load) and near-real time data ETL / ELT data processing
• Advanced experience with version control software e.g. Git Bitbucket as well as software development platforms such Azure DevOps and Jira

Languages

Fully proficient in spoken and written English

Additional Information :

OUR COMMITMENT TO YOU AND THE ENVIRONMENT

As a forward-looking business sustainability is integral to our strategy and operations. Our sustainability depends on us building and maintaining meaningful long-term relationships with all our stakeholders including our employees clients and local communities while also reducing our impact on our natural environment.

There is always more we can and should do to improve whether in relation to our people our clients our planet or our governance. Our ongoing success as a business depends on our sustainability and agility in a changing and challenging global landscape. Were committed to fostering an inclusive equitable and diverse culture for our people led by our Diversity Equity and Inclusion steering committee.

Our learning and development programmes and systems enable us to invest in growing our employees careers while our hybrid working approach supports our employees in achieving balance and flexibility while remaining connected to their colleagues. We want to empower our 5800 employees - from 94 nationalities speaking 41 languages across 25 countries - to each achieve their potential. Through IQ-EQ Launchpad we support female managers launching their first fund in an environment where only 15% of all private equity and venture capital firms are gender balanced.

Were committed to growing long-term relationships with our clients and supporting them in achieving their objectives. We understand that our clients sustainability and success leads to our sustainability and success. Were emotionally invested in our clients right from the beginning.

Remote Work :

No

Employment Type :

Full-time