EY EY-GDS Consulting-AI DATA-Snowflake-M 

India, Telangana, Hyderabad 

11140090

JOB DESCRIPTION

Corporate Title: Senior Associate

FLSA Code (US Only): N/A

No

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. Do not edit this bullet

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 7 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
• About DTCC Do not edit this section
• With over 40 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From operating facilities and data centers around the world, DTCC automates, centralizes, and standardizes the processing of financial transactions across the trade lifecycle and mitigates risk for thousands of institutions worldwide.
• At DTCC we value on our clients' interests and partner to deliver superior results with excellence and innovation and lead with integrity. We proactively develop your potential and invest in your career.

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.