Business Intelligence Engineer

The Depository Trust & Clearing Corporation (DTCC) · Jersey City, NJ · 4 days ago

Full-time

Are you ready to make an impact at DTCC? Work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development. DTCC is at the forefront of innovation in the financial markets, committed to helping employees grow and succeed. We foster a thriving internal community and create a workplace that reflects the diversity of the world we serve.

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 to support 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).

About the Role

As a BI Engineer, you will develop and deliver enterprise reporting and analytics solutions that help business and technology teams make informed, data-driven decisions. Using Power BI, SQL, Snowflake, and modern data technologies, you will transform complex data into actionable insights, build scalable data models, and create intuitive reporting solutions that support key business objectives. You will partner with business and technology stakeholders to understand reporting needs, enhance analytics capabilities, and deliver high-quality BI solutions. Additionally, you will support data modernization initiatives, maintain reporting platforms, and drive continuous improvements in data visualization, reporting performance, and analytics delivery.

Responsibilities

Design, develop, and maintain Power BI dashboards, reports, and analytics solutions
Partner with business and technology stakeholders to translate requirements into actionable insights
Develop scalable data models, DAX measures, Power Query transformations, and SQL-based reporting solutions
Participate in BI initiatives through the full development lifecycle, from requirements gathering through deployment and enhancements
Optimize Power BI performance, troubleshoot issues, and improve report usability, scalability, and reliability
Collaborate with offshore teams to deliver high-quality solutions
Contribute to BI development standards, best practices, and reusable design patterns
Support data modernization initiatives while maintaining and enhancing existing reporting platforms
Align risk and control practices with day-to-day responsibilities to appropriately monitor and mitigate risk

Qualifications

Bachelor’s degree preferred or equivalent practical experience
4-7 years of Business Intelligence, Data Analytics, Reporting, or related technology roles
Experience developing and supporting enterprise reporting and analytics solutions

Skills

Hands-on experience with Microsoft Power Platform, with strong expertise in Power BI
Advanced knowledge of DAX, Power Query (M), and Power BI data modeling
Strong data modeling skills, including star schema design, relationships, and performance optimization
Strong SQL skills with the ability to write, troubleshoot, and optimize complex queries
Experience with Snowflake or similar cloud data platforms
Experience managing Power BI deployments across Development, QA, and Production environments
Knowledge of Power BI performance tuning and report optimization techniques
Strong communication, stakeholder management, analytical, and problem-solving skills
Ability to manage multiple priorities in a fast-paced, collaborative environment

Preferred Skills

Experience with Sigma Computing, Amazon QuickSight, or other BI and analytics platforms
Experience with AWS or cloud-based analytics environments
Experience supporting data modernization or enterprise reporting initiatives
Experience with process mapping, business analysis, and process improvement
Experience working with large-scale enterprise data platforms
Financial services, capital markets, clearing, settlement, or post-trade processing experience

Preferred Certifications

PL-300: Microsoft Power BI Data Analyst Associate
PL-400: Microsoft Power Platform Developer Associate
PL-600: Microsoft Power Platform Solution Architect
PL-900: Microsoft Power Platform Fundamentals

The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations.