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
We are 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.This role requires coordination with multiple geographically dispersed groups (Business partners, Subject Matter Experts, Senior Technologists, Analyst as well as infrastructure teams) across the enterprise to implement solutions.
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.
- Assists in the evaluation of upcoming technologies and contributes to the overall solution design.
- 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
- 4+ 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 Skills 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.
- Architectural Experience: Experience in designing and implementing ETL architecture. This includes defining ETL workflows, designing data pipelines, and ensuring data quality and consistency. Knowledge of ETL performance optimization and troubleshooting is also essential.
- 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.
- Integration Knowledge: Experience with integrating Talend with various data sources and targets. This includes knowledge of APIs, web services, and other data integration methods. Familiarity with cloud platforms and services (e.g., AWS, Azure, Google Cloud) is also beneficial.
- 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 source
- Integration with Other Tools: Familiarity with integrating Power BI with other tools and platforms, such as Excel, SharePoint, and other on prem systems
- 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.
