Senior Snowflake Engineer with Python Script

Are you ready to explore a world of possibilities?

Do you want to work on innovative projects, collaborate with a dynamic and encouraging team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We're committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to crafting a workplace that looks like the world that we serve.

Pay and Benefits:

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• 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

About Us

DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you'll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It's the chance to make a difference at a company that's truly one of a kind.

Learn more about Clearance and Settlement by clicking here .

About the Team

Serves as a dedicated technology resource for advancing DTCC's business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC's mission to support the financial markets.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.