CAIA's Career Center is an easy-to-use, comprehensive resource connecting job seekers with employers in the growing AI field. Use your knowledge and credibility to advance your career or build a talented team for your organization. Opportunities targeted to CAIA Charterholders are prioritized.
In order to search for jobs specifically for CAIA Charterholders or those pursuing the CAIA Charter please enter “CAIA” in the search panel.
This will enable you to search for CAIA specific roles globally.
Designing and building end to end BI solutions, that will extract data from multiple systems, transforming and loading into multiple reporting data warehouses
Working with end users and analysts on requirements and translate them into technical specification, provides estimation to the management
Supporting existing BI Platform, reverse engineer and improve processes
Following and contributing to departmental development process in terms of standards, methodologies, testing, version control and documentation, mentor junior members, drive and implement industry best practises, evaluate and introduce new tools, design and improve existing ETL framework, data validation framework
Core Skills and Attributes
Strong experience designing BI solutions using Microsoft stack preferably within Investment banking or Financial services experience (general products and processes knowledge; market, reference and regulatory data)
Microsoft SQL Server 2005/2008/2008R2/2012/2014, performance tuning, backup and recovery, data encryption, capacity planning, understanding of database engine internals and all database objects. Experience of loading data from different sources – xml, csv, excel, web services, different databases, MQ messages etc.
Extensive experience of using SSIS, script tasks, custom plugins
Significant experience designing solutions following Kimball methodology and good knowledge of data modelling concepts
Post release support of deployed BI solutions
Experience of building solutions with SSAS, advanced knowledge of SSAS, MDX, performance tuning, best practices, 2008 onwards
Experience of building reports using SSRS, PowerPivot, integration with SharePoint, building corporate reporting portals, KPIs, dashboards, self service BI
Experience of working in a team following agile development practices, using team development tools, working on the same objects
Wide knowledge of other tools, vendors, solutions available on the market and applicable to BI space, upcoming releases of new software packages, etc