My client, an established financial services provider, is looking for a BI / Data Warehouse Developer to join their team. Responsibilities:
- Work as part of a larger IT team using the Scrum methodology.
- Interact with business users, Business Analysts,and other developers tounderstand user requirements.
- Develop integration solutions using T-SQL and other vendor integration tools
- ETL development to load Data warehouse
- Maintain existing SSRS report definitions to present the data.
- Support existing integration and reporting solutions in the productionenvironment by analysing problems reported by users and track down theircause through debugging techniques and discussion with other team members.
- Testing and deployment of new development
Requirements:
- Degree or diploma in information science or related technical discipline.
- Knowledge of financial concepts and terms and interested in attending coursesto improve business knowledge.
- Financial Services industry experience would be an advantage5-8 yearsSQL experience (stored procedures, UDF’s, T-SQL, performancetuning and optimization, RDBMS, error handling and logging, etc.) is essential
- Experience with data integration, validation,and reconciliation (SSIS or similar).
- Expert knowledge of reporting technologies (SSRS, PowerBI or similar)
- Experience with creating and maintaining cubes (SSAS) would be advantageous
- Working experience with relational and dimensional database structures.
- Experience in interacting with business users to understand requirements andproducing solutions
- Experience working in AWS Cloud implementation would be an advantage
- Exposure to PostreSQLwould be an advantage
Desired Skills:
- ETL
- T-SQL
- Data