Principal Business Intelligence Engineer

28 Jun 2024

Vacancy expired!

About this Opportunity This role will be in Data Engineering and Platforms Domain on the BI & Analytics Engineering team. The team maintains the firm's reporting and analytics platform (CLAW) for centralized IT data, KPIs and metrics. The Principal BI Engineer is responsible for working on and leading engineering and development focused projects from start to finish with minimal supervision.

What You'll Do
  • Lead engineering and development focused projects from start to finish with minimal supervision
  • Provide technical and operational support for our customer base as well as other technical areas within the company that utilize CLAW
  • Risk management functions such as reconciliation of vulnerabilities, security baselines as well as other risk and audit related objectives
  • Administrative functions for our tools such as keeping the tool documentation current and handling service requests
  • 24x7 on-call L3 support on a rotational schedule with other team members
  • Participate in user training to increase awareness of CLAW
  • Ensure incident, problem and change tickets are addressed in a timely fashion, as well as escalating technical and managerial issues
  • Follow DTCC's ITIL process for incident, change and problem resolution

Sound Like You?
  • Minimum of 8 years of related data warehousing work experience
  • 5+ years managing data warehouses in a production environment. This includes all phases of lifecycle management: planning, design, deployment, upkeep and retirement
  • 5+ years managing distributed teams with an employee/vendor mix
  • 5+ years managing offshore vendors
  • Strong understanding of star/snowflake schemas and data integration methods and tools
  • Bachelor's degree preferred or equivalent experience

Additional Qualifications
  • Good SQL skills and good knowledge of relational databases, specifically, Snowflake
  • Ability to manage agile development cycles within the DTCC SDLC (SDP) methodology
  • Optimize/Tune source streams, queries, PowerBI Dashboards
  • Good knowledge of the technical components of CLAW (i.e. Snowflake, Talend, PowerBI, PowerShell, Autosys)
  • Moderate to advanced competency of Windows and Unix-like operating system principles (power user functions)
  • Developed competencies around essential project management, communication (oral, written) and personal effectiveness
  • Working experience covering Microsoft Office tools such as Outlook, Excel, PowerPoint, Visio and Project
  • Certification in any of the listed tools a plus

About Us

About DTCC

DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.

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.

About the Team

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.

  • ID: #43652982
  • State: Texas Coppell 75019 Coppell USA
  • City: Coppell
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-06-28
  • Deadline: 2022-08-26
  • Category: Et cetera