Specific Responsibilities:This role will be in the Claw Team within Enterprise Data & Corporate Technology (EDCT). The Business Intelligence team maintains the firm’s business intelligence tools and data warehouse. As part of the Claw team, the candidate is responsible for:
- Working on and leading engineering and development focused projects from start to finish with minimal supervision
- Providing 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
- Ensuring incident, problem and change tickets are addressed in a timely fashion, as well as escalating technical and managerial issues
- Following DTCC’s ITIL process for incident, change and problem resolution
Qualifications/Knowledge/Skills
- Self-starter, continually striving to improve the teams service offerings and one’s own skillset
- Must have a problem-solving and innovative mindset to meet a wide variety of challenges
- Willingness and ability to learn all aspects of our operating model as well as new tools
- Ability to meet deadlines, goals and objectives
- 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
- 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)
- Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately.
Leadership Competencies for this level include
- Accountability: Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
- Global Collaboration: Applies global perspective when working within a team by being aware of own style and ensuring all relevant parties are involved in key team tasks and decisions.
- Communication: Articulates information clearly and presents information effectively and confidently when working with others.
- Influencing: Convinces others by making a strong case, bringing others along to their viewpoint; maintains strong, trusting relationships while at the same time is comfortable challenging ideas.
- Innovation and Creativity: Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.
Qualifications
- Minimum of 5 years of related experience
- Bachelor's degree preferred equivalent experience
Specific Skills and Technologies
- Minimum of 5 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
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.