Lead Business Intelligence Engineer

Are you ready to make an impact at DTCC?
The Lead BI Engineer is the point person for the firm’s primary BI Analytics platforms. The Lead BI Engineer will define and architect the best practices of a BI infrastructure, coordinate operational design, develop support plans and provide support for applications.

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:

• Manage Power Bl Gateways; ensure the dashboards and reports refresh automatically.
• Automate Power BI platform related activities using scripting languages like PowerShell/Python/Shell scripting etc.
• Build CI/CD pipeline to check in and migrate Power BI data sets/dashboards/reports between workspaces utilizing Power BI Rest APIs/Power Platform
• Build & Support Power BI platform metrics such as user tracking/logging, usage monitoring, anomalies detection in published data sets and reporting at an enterprise level using Power BI Platform
• Configure Power BI Tenant settings for PBI features such as workspace settings, Export and sharing settings, Publish to web, Developer settings.
• Manage Power BI Premium capacities for capacity planning and performance management.
• Monitor premium capacities regularly to identify trends that indicate underlying issues
• Train self-service BI users and support the business in promoting self-service and the overall data platform through communications, collateral and training material.
• Support BI production environment for large scale user base.
• Provide on call support for Production issues when needed.
• Provide leadership and vision for best usage and practices with regards to Cognos tool set.
• Set standards and guidelines for BI development.
• Mentor other team members 
• Align risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately
  
   

Qualifications:

• Minimum of 6 years of related experience
• Bachelor's degree or equivalent experience

Talents Needed for Success:

• Experience with developing & managing Business Intelligence solutions, reports leveraging Power BI technologies and tools like Power BI Desktop, Paginated Report Builder & Power BI Service(SaaS)
• Intermediate/Advanced knowledge & experience with SQL and good understanding of Data warehousing and Relational database concepts & technologies
• Strong Knowledge of Python & Powershell.
• Experience designing & developing automated solutions in a Distributed computing environment
   

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.