MS BI Developer

Company Description

• IQEQ is a preeminent service provider to the alternative asset industry. IQEQ works with managers in multiple capacities ranging from hedge fund, private equity fund, and mutual fund launches; private equity fund administration; advisory firm set-up, regulatory registration and infrastructure design; ongoing regulatory compliance (SEC, CFTC, and 40 Act); financial controls and operational support services; compliance and operational related projects and reviews; and outsourced CFO/controller and administration services to private equity fund investments – portfolio companies, real estate assets and energy assets. Our client base is growing, and our existing clients are engaging the firm across the spectrum of our services offerings.

Job Description

Responsibilities

• As a result of continued growth, we have a fantastic opportunity for an experienced SQL Developer, with SSRS/SSAS/SSIS as primary skills, as Microsoft BI Developer, to join our global team, to develop, maintain, administer the enterprise workflows, integrations and transformations., and to provide support for line of business applications developed internally or from 3rd party applications IQEQ currently using.
• The MS BI developer is required to be able to work with various internal teams, stake holders, business analysts and technical teams to help build, modify, validate, troubleshoot data requirements including stored procedures, functions, views for data analysis and reporting.
• Relationship building with stakeholders across business and IT department will be essential, as will understanding pain points and devising solutions, ultimately leading to a deep technical knowledge of the platforms used and input into the development roadmap and driving best practices.
• You will need to have experience working in a fast-paced environment and able to prioritise tasks that contribute to the delivery of project workstreams, BAU activities, and response to incidents. 
• You will have the ability to work collaboratively with colleagues based around the globe and across many technology functions.
• You will be tenacious and passionate, with the ability to take ownership of tasks whilst managing your time effectively, and prioritising tasks to meet deadlines. 
• You will maintain excellent attention to detail and have a logical approach to solving problems under pressure and be an active communicator on technical issues that affect client delivery.
• This role also expects to have strong aptitude with ability to quickly perform data analysis and turnaround.
• The role requires you to have the ability to discuss and communicate clearly in fast-paced and high-pressure situations including the ability to challenge and influence the view of senior stakeholders respectfully, confidently, and effectively to bring a new perspective.

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

• Design, develop and maintain ETL workflows, SSIS/SSRS/SSAS applications for data integration, transformations, writing efficient and optimized SQL queries.
• Build proof of concept prototypes based on requirement documentation.
• Participate in discussions regarding requirements, designing the application with users and team members.
• Provide effort estimates for a given requirement and able to explain requirements.
• Work both as an individual contributor and team player.
• Review the development, coding standards, and be aware of application change management processes to ensure compliance within releases.
• Perform data profiling, validation, troubleshooting of data issues across multiple data sources, maintain proper documentation for processes, workflows and solutions delivered.
• Should be able to design the target architecture for new solutions or when adding any new capabilities to existing solutions.

Key competencies for position and level

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

• Collaborates
• Communicates effectively.
• Manages complexity.
• Customer focus
• Global perspective
• Tech savvy
• Instils trust.
• Drives vision and purpose.
• Optimizes work processes.

Qualifications

Required Experience

Education / professional qualifications

• Graduate degree, preferably in IT related disciplines

Background experience

• With 10 years of overall IT experience and at least 6 years of working experience on developing applications using SSRS, SSIS and SSAS especially with overall expertise in MS BI stack.
• Strong knowledge of SQL Server (T-SQL, PL/SQL) including query optimizations and performance tuning.
• Experience in data accuracy, consistency and reliability through rigorous testing and validations.
• Create and maintain SQL Server Integration Services packages for data integration and workflow automations.
• Experience in optimizing SSIS packages for performance and scalability.
• Experience in implementing multi-dimensional and tabular models for SQL Server Analysis services (SSAS).
• Expertise in designing, creating reports using SSRS, customizing and enhancing reports to meet business requirements.
• Experience in developing, optimizing T-SQL queries for data retrieval and manipulations, ensuring data performance and integrity.
• Knowledge in implementing and maintaining security measures for databases and BI solutions, ensuring compliance with data governance and privacy standards.
• Hands on experience in .NET, Python and PowerShell scripting.
• Familiarity with collaboration tools and version control systems is an added advantage.
• Strong working experience on Azure architectures is a benefit (ADF, ADB, PySpark, Cloud storages etc)
• Excellent attention to detail
• Excellent communication skills
• Excellent written and spoken English.
• Excellent analytical and numerical skills
• Strong problem solving and conceptual thinking.
• Strong organisation skills

Company, product, and market knowledge

• Experience of working in a complex, multi-country professional services, financial services or BPO organisation with complex processing requirements preferred but not essential.
• Multi-country experience and demonstrates an ability to work in a multi-cultural, talented, and demanding team environment.
• Possess the skills and the personality to operate effectively in a very fast-paced complex global business with an in-depth knowledge of program management.
• Excellent communication skills in both written and oral form, with staff members, customers, suppliers, and the management team with the ability to make decisions, act and get results.
• Passion, dynamism, and drive
• Personal presence, integrity, and credibility
• Ability to solve problems either independently or by utilising other members of the team where necessary

Languages

• Fully proficient spoken and written English, additional European languages will be an asset.