Are you ready to make an impact at DTCC
Pay and Benefits:
- Competitive compensation, including base pay and annual incentive
- Comprehensive health and life insurance and well-being benefits, based on location
- Pension / Retirement benefits
- Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
- DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).
The Impact you will have in this role: As a BI Reporting Analyst , you will be working with Financial Risk Management product team to analyze, build , test and deploy large scale analytical reporting.
Great learning opportunity building cloud native , high performance UI and API rich full stack applications for the financial customers.
Working with high performance ,collaborative Global teams for greater success.
Qualifications:
- Minimum of 4 years of related experience
- Bachelor''s degree preferred or equivalent experience
Talents Needed for Success:
- Solid hands on SQL experience in building reports in large scale Data Systems like Snowflake.
- Minimum 3 years of experience as Reporting analyst creating SQL based reports for financial risk management and functions in Snowflake for large scale data warehouse.
- Hands on experience in building BI reports using AWS quick sight will be a plus.
- Deep understanding on financial risk management for Treasuries, Mortgage-backed securities, bonds, and equities.
- Good understanding of Data warehouse concepts, Dimensional modelling, Enterprise Data integration and Analytics.
- Hands on experience in setting up and managing code repositories, CICD pipelines using bitbucket, Liquibase and Jenkins.
- Minimum 2 years of experience in SQL, PL/SQL for Analysis, debugging and supporting financial risk management business.
- Strong hands-on experience in tuning large SQL reports for performance.
- Minimum 3 years of experience in generating SQL scripts and functions in snowflake for large scale data reports.
- Experience in shell and python scripting, JavaScript AngularJS is a plus.
📌 Business Intelligence Engineer (Chennai)
🏢 DTCC
📍 Chennai