GDS Consulting - AI and DATA - Snowflake - Senior

The Business Intelligence Lead will be responsible for building data pipelines using their deep knowledge of Talend, SQL and Data Analysis on the bespoke Snowflake data warehouse for Business Intelligence.

Specific

• 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 we'll as other technical areas within the company that utilize Claw
• Risk management functions such as reconciliation of vulnerabilities, security baselines as we'll 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 we'll 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 we'll 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 (ie 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
• Bachelors 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