BI/Data Warehouse Developer
BI/Data Warehouse Developer
London
Up to 55,000k per annum
Permanent Role
Sponsorship *NOT AVAILABLE*
Job Profile Summary:
This is an outstanding opportunity to join one of the largest alternative asset managers in the world, constantly looking at better ways of doing things. The culture embraces change and change is the norm rather than the exception in a constantly evolving organisation and industry.
We are looking for an Associate BI/Data Warehouse Developer with analytical skills and a genuine passion
for technology and data to work within our Data Management team. The work will be a mixture of extending
and supporting existing systems as well as some involvement with greenfield data-centric projects in line
with our long-term vision.
Technical Competencies:
Experience working as a BI/Data Warehouse Developer, comfortable working in a technical environment with a variety of technologies and integration techniques.
Essential
An understanding of database and data warehouse design principles and involvement in
developing database solutions.
Project experience with the Microsoft BI stack, including
SQL Server Analysis Services (Tabular and OLAP)
SQL Server Integration Services
SQL Server 2016/2017 RDBMS and above
SQL Server Reporting Services
Business analysis and requirements gathering
Advantageous
Tableau and/or Power BI
A proponent of collaborative software engineering techniques and methods: agile
development, continuous integration, code review or pairing, unit testing, refactoring and
related approaches
Oracle
Experience using C# to extend the functionality of the Microsoft BI Stack
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
email - as they go live.
MORE JOBS LIKE THIS
Business Analyst - CRM Technology
I'm working with a leading investment banking client who are looking to bring on an experienced Business Analyst with experience in Sales & Pipeline Management, Client On-boarding, Digitization of Products to support their CRM client technology business.
Candidates should have:
Significant experience in Business Analysis
within Banking or Financial Services IT.- Experience working CRM projects related to Sales & Pipeline Management, Client On-boarding, Digitization of Products. (must have).
- Extensive knowledge of applying business analysis skills & techniques
- Experience of working in a direct customer-facing role
- Strong experience with Software Development Lifecycle processes
- Hands on experience in Agile / Scrum environment.
- Ability to effectively prioritise and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Experience working with global team
- Hands on experience Confluence, JIRA and or / Azure tool to manage business requirements
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
Senior Platform Services Analyst
Senior Platform Services Analyst – London – Hybrid
A Global Financial Services provider working at the heart of the world’s financial, energy and commodities markets covering FX, Rates, Credit, Equities and Energy & Commodities are looking for a Senior Platform Services Analyst to join their team in London.
Clients include banks, insurance companies, pension and hedge funds, asset managers, energy producers and refiners, as well as risk and compliance managers and charities.
Responsibilities:
- Working within a shift rota to provide support coverage from 7am – 6pm
- Contribute towards ‘follow the sun’ support model, working closely with global teams in APAC and US to ensure pre-market health checks are performed for each region
- Perform regional start of day health checks to ensure all members are connected to the platform
- Utilising proprietary tools, provide daily application support and troubleshooting for platform members and internal users, escalating to Development teams appropriately
- Daily interaction with all internal stakeholders with regards to support issues
- Efficiently create and track issues within an incident-management system to help identify trends and patterns
- Create and monitor internal reports and usage queries
- Assist with product testing and project work
Skills:
- At least 3 years hands-on support experience within a financial institution (buy-side, sell-side, venue/platform provider)
- Proven experience of MSSQL, Oracle and Sybase database environments, including complex query-writing
- Solid application support experience within a Unix / Linux environment
- Good working knowledge of the FIX protocol
- Proven experience of supporting Windows Server environments
- Experience in troubleshooting network problems: i.e. firewall and routing problems
- Good understanding of international Equity market mechanics and flows
Desirable:
- Exposure to supporting message-based architecture
- Working knowledge of at least one buy-side or sell-side Order Management System
- Good understanding of Fixed Income market mechanics and flows
- Experience with industry-standard monitoring tools (ITRS or similar)
- Automation experience using PERL, Python, or similar scripting languages
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
Senior Algo Support
Senior Algo Support – London – Hybrid
A Global Financial Services provider working at the heart of the world’s financial, energy and commodities markets covering FX, Rates, Credit, Equities and Energy & Commodities are looking for a Senior Algo Support to join their team in London.
Clients include banks, insurance companies, pension and hedge funds, asset managers, energy producers and refiners, as well as risk and compliance managers and charities.
Responsibilities:
- Utilising proprietary tools, provide daily application support and troubleshooting for platform members and internal trade desks, escalating to development teams appropriately
- Fulfilling client customisation requests within algorithmic trading systems and MTF platform
- Troubleshooting and analysis of order routing and trade flow and post-trade issues
- Managing team chats, queues, and mailboxes to ensure requests are being actioned in a timely manner with appropriate prioritization
- Ensuring incident and problem management procedures are followed and performing analysis to determine trends and patterns
- Assist with product testing and project work
- Working within a shift rota to provide support coverage from 7am – 6pm
- Contribute towards ‘follow the sun’ support model, working closely with global teams in APAC and US to ensure pre-market health checks are performed for each region
- Performing regional start of day health checks to ensure all processes are up and members are connected to the platform
Skills:
- At least 5 years hands-on support experience of an algorithmic trading platform within a financial Institution
- Ability to convey expected behaviour of industry-standard algorithms (VWAP, TWAP, IS, POV etc)
- Experience managing a small support team, preferably within the front office
- Excellent working knowledge of the FIX protocol
- Solid application support experience within a Linux environment
- Good understanding of European Equity market structure, mechanics, and flows
- Proven experience of MSSQL, Oracle and Sybase database environments, including complex query writing
- Proven experience of supporting Windows Server environments
- Experience in troubleshooting network problems: i.e. firewall and routing problems
Desirable:
- Automation and scripting experience
- Client / Venue technical FIX onboarding exposure
- Exposure to supporting message-based architecture
- Working knowledge of at least one buy-side or sell-side Order Management System
- Experience with industry-standard monitoring tools (ITRS or similar)
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
MORE JOBS LIKE THIS
-
Business Analyst - CRM Technology
I'm working with a leading investment banking client who are looking to bring on an experienced Business Analyst with experience in Sales & Pipeline Management, Client On-boarding, Digitization of Products to support their CRM client technology business.
Candidates should have:
Significant experience in Business Analysis
within Banking or Financial Services IT.- Experience working CRM projects related to Sales & Pipeline Management, Client On-boarding, Digitization of Products. (must have).
- Extensive knowledge of applying business analysis skills & techniques
- Experience of working in a direct customer-facing role
- Strong experience with Software Development Lifecycle processes
- Hands on experience in Agile / Scrum environment.
- Ability to effectively prioritise and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Experience working with global team
- Hands on experience Confluence, JIRA and or / Azure tool to manage business requirements
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
-
Senior Platform Services Analyst
Senior Platform Services Analyst – London – Hybrid
A Global Financial Services provider working at the heart of the world’s financial, energy and commodities markets covering FX, Rates, Credit, Equities and Energy & Commodities are looking for a Senior Platform Services Analyst to join their team in London.
Clients include banks, insurance companies, pension and hedge funds, asset managers, energy producers and refiners, as well as risk and compliance managers and charities.
Responsibilities:- Working within a shift rota to provide support coverage from 7am – 6pm
- Contribute towards ‘follow the sun’ support model, working closely with global teams in APAC and US to ensure pre-market health checks are performed for each region
- Perform regional start of day health checks to ensure all members are connected to the platform
- Utilising proprietary tools, provide daily application support and troubleshooting for platform members and internal users, escalating to Development teams appropriately
- Daily interaction with all internal stakeholders with regards to support issues
- Efficiently create and track issues within an incident-management system to help identify trends and patterns
- Create and monitor internal reports and usage queries
- Assist with product testing and project work
Skills:- At least 3 years hands-on support experience within a financial institution (buy-side, sell-side, venue/platform provider)
- Proven experience of MSSQL, Oracle and Sybase database environments, including complex query-writing
- Solid application support experience within a Unix / Linux environment
- Good working knowledge of the FIX protocol
- Proven experience of supporting Windows Server environments
- Experience in troubleshooting network problems: i.e. firewall and routing problems
- Good understanding of international Equity market mechanics and flows
Desirable:- Exposure to supporting message-based architecture
- Working knowledge of at least one buy-side or sell-side Order Management System
- Good understanding of Fixed Income market mechanics and flows
- Experience with industry-standard monitoring tools (ITRS or similar)
- Automation experience using PERL, Python, or similar scripting languages
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
-
Senior Algo Support
Senior Algo Support – London – Hybrid
A Global Financial Services provider working at the heart of the world’s financial, energy and commodities markets covering FX, Rates, Credit, Equities and Energy & Commodities are looking for a Senior Algo Support to join their team in London.
Clients include banks, insurance companies, pension and hedge funds, asset managers, energy producers and refiners, as well as risk and compliance managers and charities.
Responsibilities:- Utilising proprietary tools, provide daily application support and troubleshooting for platform members and internal trade desks, escalating to development teams appropriately
- Fulfilling client customisation requests within algorithmic trading systems and MTF platform
- Troubleshooting and analysis of order routing and trade flow and post-trade issues
- Managing team chats, queues, and mailboxes to ensure requests are being actioned in a timely manner with appropriate prioritization
- Ensuring incident and problem management procedures are followed and performing analysis to determine trends and patterns
- Assist with product testing and project work
- Working within a shift rota to provide support coverage from 7am – 6pm
- Contribute towards ‘follow the sun’ support model, working closely with global teams in APAC and US to ensure pre-market health checks are performed for each region
- Performing regional start of day health checks to ensure all processes are up and members are connected to the platform
Skills:- At least 5 years hands-on support experience of an algorithmic trading platform within a financial Institution
- Ability to convey expected behaviour of industry-standard algorithms (VWAP, TWAP, IS, POV etc)
- Experience managing a small support team, preferably within the front office
- Excellent working knowledge of the FIX protocol
- Solid application support experience within a Linux environment
- Good understanding of European Equity market structure, mechanics, and flows
- Proven experience of MSSQL, Oracle and Sybase database environments, including complex query writing
- Proven experience of supporting Windows Server environments
- Experience in troubleshooting network problems: i.e. firewall and routing problems
Desirable:- Automation and scripting experience
- Client / Venue technical FIX onboarding exposure
- Exposure to supporting message-based architecture
- Working knowledge of at least one buy-side or sell-side Order Management System
- Experience with industry-standard monitoring tools (ITRS or similar)
McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.
