Business Intelligence Engineer

Socket.dev; New Jersey; Hybrid; USD 100,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Pension plan

Paid time off

Hybrid work model

Life insurance

Job summary

DTCC is seeking a BI Engineer to design, develop, and deliver enterprise reporting and analytics solutions using Power BI, SQL, Snowflake and modern data tools. You will partner with business and technology stakeholders to translate needs into actionable insights and support data modernization initiatives.

You will build scalable data models, optimize reports for performance, and contribute to development standards while collaborating with global teams to ensure reliable, scalable analytics

Qualifications

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

Responsibilities

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

Skills

Power BI

DAX

Power Query

Data modeling

SQL

Snowflake

Analytics comms

Stakeholder mgmt

Education

Bachelor’s degree or equivalent

Tools

Snowflake

AWS

Sigma Computing

Amazon QuickSight

Power Platform

Job description

Are you ready to make an impact at DTCC?
Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that 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 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 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. In addition, you will support data modernization initiatives, maintain reporting platforms, and drive continuous improvements in data visualization, reporting performance, and analytics delivery.

Your Primary 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.

Talent Needed for Success

• 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. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem. In 2024, DTCC’s subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC’s Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually.

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.

Serves as a dedicated technology resource for advancing DTCC’s business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC’s mission to support the financial markets.