Data Integration Engineer
Depository Trust & Clearing Corporation (DTCC)24 hours ago
Tampa, FL, USASenior
Responsibilities
- Plan, design, develop, test, and support software systems and enterprise data integration solutions from start to finish.
- Design and maintain real-time and batch data integration and transformation frameworks using Snowflake services, SQL, PL/SQL, and AWS.
- Develop logical, physical, and dimensional data models, including slowly changing dimensions and fact table designs, for analytics, reporting, and business intelligence.
- Ensure data quality and consistency across source systems and coordinate issue resolution with data product managers.
- Perform SQL performance tuning, monitoring, root cause analysis, and resolution of complex data pipeline and platform issues.
- Support unit testing, system integration testing, user acceptance testing, and production readiness.
- Collaborate with architects, product managers, project managers, product owners, business stakeholders, and technical teams to define requirements and solutions.
- Manage technical and operational support, incidents, problems, changes, vulnerabilities, security baselines, and audit-related objectives.
- Refine and prioritize the team backlog and contribute to sprint planning, estimation, story design, and documentation.
- Participate in user training and support employee engagement, growth, and appraisals.
Requirements
- At least 4 years of related experience.
- 5+ years of experience in data management, including leading complex data initiatives end to end and working with analytical data warehousing and enterprise-scale data platforms.
- At least 2 years of hands-on experience with Snowflake Cloud Data Warehouse, including advanced features and performance optimization.
- Strong AWS cloud architecture expertise and experience designing and supporting scalable, secure, and cost-efficient data solutions.
- Advanced SQL and PL/SQL development experience for data integration and transformation.
- Experience with Snowpark, Streams, Tasks, and Snowpipe for real-time and batch data integration.
- Strong knowledge of logical and physical data models and dimensional modeling, including slowly changing dimensions and fact table designs.
- Experience with unit testing, system integration testing, user acceptance testing, monitoring, troubleshooting, and production support.
- Experience working in Agile delivery teams and using Jira.
- Strong verbal and written communication skills for collaboration with technical and business stakeholders.
- Bachelor's degree preferred, or equivalent experience.
Benefits
- Competitive compensation including base pay and annual incentive.
- Comprehensive health and life insurance and well-being benefits, depending on location.
- Pension and retirement benefits.
- Paid time off, personal and family care, and other leaves of absence.
- Flexible hybrid work model with three days onsite and two days remote, including onsite Tuesdays, Wednesdays, and a third team- or employee-specific day.
- Investment in professional development and employee growth.
About Depository Trust & Clearing Corporation (DTCC)
Depository Trust & Clearing Corporation (DTCC) runs global post-trade market infrastructure, delivering clearing, settlement, securities depository, trade reporting, and data services for broker-dealers, banks, and asset managers. It provides these services through subsidiaries such as DTC, NSCC, FICC, and the Global Trade Repository, with revenue primarily from transaction and service fees. Founded in 1973 and headquartered in Jersey City, NJ, DTCC is industry-owned and privately held, serving markets across multiple regions.