Development Associate

Are you ready to make an impact at DTCC

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development

At DTCC, we are at the forefront of innovation in the financial markets. We are 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 creating 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:

Seeking a skilled Talend Developer with expertise in Power BI development and SQL Server to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes using Talend, creating insightful data visualizations with Power BI, and is an expert in writing stored procedures/queries on MS SQL Server databases.

What You'll Do:

• Design, develop, and maintain ETL processes using Talend to extract, transform, and load data from various sources.
• Create and maintain data visualizations and dashboards using Power BI to provide actionable insights to stakeholders.
• Write high performance queries on SQL Server databases, ensuring data integrity, performance, and security
• Collaborate with cross-functional teams to gather requirements, design solutions, and implement data integration and reporting solutions.
• Troubleshoot and resolve issues related to ETL processes, data visualizations, and database performance
• Collaborates with other team members and analysts through the delivery cycle.
• Participates in an Agile delivery team that builds high quality and scalable work products.
• Supports production releases and maintenance windows working with the Operations team

Qualifications:

• Bachelor's degree in computer science, Information Technology, or a related field.

Talents Needed for Success:

• Min 3+ years in writing ETL processes
• Proven experience as a Talend Developer, with a strong understanding of ETL processes and data integration.
• Proficiency in Power BI development, including creating dashboards, reports, and data models.
• Expertise in SQL Server, including database design, optimization, and performance tuning
• Strong understanding of agile processes (Kanban and Scrum) and a working knowledge of JIRA is required
• Strong analytical and problem-solving skills, with the ability to work independently and as part of a team.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with stakeholders at all levels.

Additional Qualifications needed for Success:

• Talend Expertise: Proficiency in using Talend Studio for data integration, data quality, files manipulation. This includes designing and developing ETL processes, creating and managing Talend jobs, and using Talend components for data transformation and integration
• Data Integration Knowledge in Talend: Understanding of data integration concepts and best practices. This includes experience with data extraction, transformation, and loading (ETL) processes, as well as knowledge of data warehousing and data modeling.
• Database Skills: Proficiency in working with various databases, including MS SQL and/or Oracle databases. This includes writing complex SQL queries, understanding database schemas, and performing data migrations.
• Version Control and Collaboration: Experience with version control systems (e.g., Git) and collaboration tools (e.g., Jira, Confluence). This is important for managing code changes, collaborating with team members, and tracking project progress.
• Job Scheduling and Automation: Experience with job scheduling and automation tools. This includes setting up and managing Talend jobs using schedulers like Talend Administration Center (TAC), Autosys or third-party tools to automate ETL workflows.
• Data Visualization: Ability to create visually appealing and insightful reports and dashboards. This involves selecting appropriate visualizations, designing layouts, and using custom visuals when necessary using Power BI
• Power Query: Expertise in using Power Query for data transformation and preparation. This involves cleaning, merging, and shaping data from various sources
• Expertise in scripting languages such as Python, and Shell/Batch programming is a plus

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 functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Skills Required
Power Bi, Talend, Sql Server