Senior Snowflake Engineer with Python Script

.

• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The impact you will have in this role:

As a Database Developer you will assist in the technical design of application components, builds applications, interfaces between applications, and understands data security, retention, and recovery. Can research technologies independently and recommend appropriate solutions. Contributes to technology-specific best practices & standards; contributes to success criteria from design through deployment, including, reliability, cost-effectiveness, performance, data integrity, maintainability, reuse, extensibility, usability and scalability; contributes expertise on significant application components, vendor products, program languages, databases, operating systems, etc executes on the plan by building components, testing, configuring, tuning, and deploying solutions.

Your Primary Responsibilities:

• Identify and prioritize business use cases. Understand the business, strategy, data sets and work with collaborators to develop reusable data models, dashboards, or other data assets.

• Understand the broad uses of data within the organization and build solutions that improve the efficiency of data users.

• End-to-end data architectural expertise for defining and refining RDS data architecture for OLTP, data warehousing and business analytics solutions.

• Technology Expertise - be a subject matter expert on one or more of programming languages, vendor products, DTCC applications, data structures, business lines. Focus on database technologies such as Oracle and Snowflake.

• Programming and optimizing database objects including, Tables, Views, Stored Procs, Functions.

• Programming and operationalizing PERL, Python, and Shell scripts to run various processes / jobs and program executions.

• Providing subject-matter expertise (level 3) support to multiple production applications to support environments and triage any operational issues/incidents.

• Supporting multiple production application releases and maintenance windows during off-peak work hours.

• Platforms - works with Infrastructure partners to stand up development, testing, and production environments

• Data Modeling - Develop conceptual, logical, and physical data models for implementation across RDS Trade Repositories.

• Aligns risk and control processes into day to day responsibilities to supervise and mitigate risk; advances appropriately

****NOTE: The Primary Responsibilities of this role are not limited to the details above. ****

Talents Needed for Success:

• 6+ years' experience in Database Development or System Analysis

• Bachelor's degree in technical/computer field or related experience required

• Deep expertise in data management, data architecture, metadata management, data integration, data governance, data modeling (conceptual, logical, and physical), data transport, data quality, and master data management

• Solid understanding of agile development methodologies

• Proven expertise in scripting languages such as, PERL, Python, and Shell

• Solid understanding of distributed and cloud-based data technologies and analytics tools.

• Specific knowledge of Oracle, Snowflake, Splunk, PowerBI, and Collibra a plus.

• Experience with database specific CICD tools, such as

• Up-to-date knowledge of technology and architecture marketplace

• Excellent collaboration and communication skills

• Good communications skills, both written and verbal

Leadership Proficiencies for this level include

• Accountability: Demonstrates reliability by taking vital 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, positive relationships while at the same time is comfortable exciting ideas.

• Innovation and Creativity: Thinks boldly and out of the box, generates new insights and processes, and confidently pursues challenges as new avenues of opportunity

The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job function