Lead Business Intelligence Engineer

About the role

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

Responsibilities

• Extensive experience with implementing and managing BI platforms for business intelligence, data applications, and embedded analytics.
• Experience in managing BI platforms includes Looker, Amazon Quicksight.
• Experience in designing and delivering complex platform architectures.
• Extensive experience with Python programming, Shell Scripting and Powershell Scripting.
• Identify and implement various automation solutions using scripting.
• Worked on various product APIs to automate Admin functions.
• Extensive knowledge and experience on setting up security using Active Directory, Azure AD and Ping federate.
• Have worked on configuring OAuth, SAML configurations for SSO implementation.
• Experience with defining SDLC process and CICD process using Jenkins.
• Integrating Looker with a Git repo for code commits.
• Extensive knowledge and experience with platform governance and resiliency.
• Quicksight, Looker architecture design and administration including but not limited to troubleshooting and find opportunities for automation to streamline the day-to-day Operations of the platform.
• Architect and develop data models, ETL packages, Reports utilizing Power BI applying best practices to the development lifecycle.
• Data Modeling experience with Kimball method.
• Experience with more than one database tool such as Snowflake, Oracle, DB2, SQL Server.
• Understanding of various external components that BI tools depend in order for a successful connectivity which includes understanding of Network, Firewall, Proxy etc.
• Integrating BI with different tools which includes and not limited to Splunk, collibra, Service now.
• Understanding of pre-requisites for a successful connection setup.
• Strong ability to quickly propose solutions by recalling the latest best practices learned from MVP & Product Team articles, vendor documentation, whitepapers, and community publications.
• A passion for understanding and integrating business semantics into technology solutions.
• Excellent communication, presentation, influencing, and reasoning skills.
• Ability to lead complex projects.
• Available on call support for Production issues.
• Provide leadership and vision for best usage and practices with regards to multiple BI tool set.
• Setting standards and guidelines for BI development.
• Mentor other team members for knowledge transfer.

Qualifications

• Minimum of 10 years of related experience.
• Bachelor's degree preferred or equivalent experience.