Business Intelligence Engineer

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:

• Strong 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.