Project description
Our Customer is one of the world's largest investment management companies. Based in Southern California, our client manages close to $2 trillion in assets and is looking for a new partner to participate in a full scale upgrade of their technology. We are looking for talented and ambitious people to work on cross-location engagement spread across Los Angeles, California, Switzerland, Geneva, and Krakow. We have a huge opportunity to impress them and earn a large share of their new and existing business.
The team will be responsible for developing and maintaining reporting tools based on SimCorp's Coric solution. Since it is rare and unique knowledge, the position will give the opportunity to participate in proper training and gather required domain understanding.
Responsibilities
- Design and Develop Coric reports and dashboards
- Provide operational support for existing reports/dashboards
- Participate in analysis, design, development, testing, deployment, and support of dashboards and reports
- Perform data integration into the tool, maintenance, and support
- Perform impact analysis and validation of existing production reports and universes after application and database upgrade
- Implement industry BI standards and best practices
- Proactively identify problems/issues/risks and provide solutions
SKILLS
Must have
- Key Mandatory Skills:
- Financial Reporting
- Coric
- SQL
- Data Architecture
- Data Visualization
- ETL
- Minimum 3 years of Business Intelligence, Data Analytics, and SQL structured programming, ad hoc queries, and data analysis development.
- Experience in Banking / Financial Services, Regulatory reporting.
- Understanding financial data (e.g. fund and index returns, portfolio holdings and valuation, asset classes: equities, bonds, derivatives etc., and their characteristics)
- Knowledge of Microsoft SQL services and technologies (SSIS, SQL Server 2017+).
- Experience with MS Visual Studio & Data Tools.
- Experience in SQL; Strong T-SQL scripting knowledge, able to create complex SQL queries and stored procedures.
- Demonstrated knowledge of Data Warehouse concepts (data normalization, star schema, slowly changing dimensions etc.).
- Experience with GIT repositories, preferably Bitbucket.
- Knowledge / use of CI/CD tools (preferably Bamboo).
- Experience in creating highly interactive data visualization dashboards.
- Must have good written and verbal communication skills, and be able to communicate effectively in business terms with business partners.
- Strong client focus/customer service skills.
- Prior experience with Agile/Scrum framework and tools like Jira, Confluence etc.
Nice to have
Interest in the Financial markets and knowledge of the Investment industry.
#J-18808-Ljbffr