Lead Business Intelligence Engineer (Snowflake)

The Impact you will have in this role:

The Enterprise 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 Enterprise Intelligence; This role will be in the Claw Team within Enterprise Data & Corporate Technology (EDCT). The Enterprise Intelligence team maintains the firms business intelligence tools and data warehouse.

Your Primary Responsibilities:

• 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
• 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 DTCCs ITIL process for incident, change and problem resolution

Qualifications:

• Minimum of 8 years of related experience
• Bachelor's degree preferred or equivalent experience.

Talents Needed for Success:

• Must have experience in snowflake or SQL
• 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
• Strong understanding of star/snowflake schemas and data integration methods and tools
• Moderate to advanced competency of Windows and Unix-like operating system principles
• Developed competencies around essential project management, communication (oral, written) and personal effectiveness
• Working experience in MS Office tools such as Outlook, Excel, PowerPoint, Visio and Project
• Optimize/Tune source streams, queries, Powerbase Dashboards
• Good knowledge of the technical components of Claw (i.e. Snowflake, Talend, PowerBI, PowerShell, Autosys)