* Visa sponsorship is not available for this position *
Are you ready to explore a world of possibilities?
Join our DTCC family, and you’ll grow your expertise and become the best version of you. As you embark on a new journey, you’ll tackle challenges with flexibility and grace, learning new skills and advancing your career while having the time of your life
The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.
Why you’ll love this job
We are looking for a Senior Technical Solution Architect with AWS Cloud experience to lead DTCC projects as we migrate to Snowflake / Data Lake and execute day to day projects. This resource will work with the management and leadership to envision and define the Center of Excellence solutions and projects, and manage, mentor, and lead the teams that will implement those solutions. This position will involve working as a senior member of an implementation team on large, complex and industry leading data and analytics projects. DTCC is looking for enthusiastic leaders who enjoy solving tough industry and technical problems and building tools which enable Risk Analytics team to elevate the efficiency and effectiveness of Data Analytics at DTCC.
Highly technical position with an emphasis on providing expert consultative services to development teams and hands-on ETL and Data Warehouse development. Works closely with the Product Owner, Scrum Master, ETL Developers and various business stakeholders to support and provide quality of delivery for data extraction, transformation and load needs through the development of new and/or enhancement of existing routines. Works with Leadership to assess project scope and provides estimates for project timelines and cost feasibility as necessary. Requires exceptional technical and analytical skills.
What you’ll do
Develop a Snowflake Center of Excellence and Data Strategy and Data Science architecture patterns and guidelines for various teams to follow
Lead the analysis, architecture, design, and development of traditional data warehouse and business intelligence solutions
Build data flows for data warehousing and data platform
Experience designing highly scalable ETL processes with complex data transformations, data formats including error handling and monitoring.
Design and implement processes that transform data for the Enterprise Data Warehouse according to business needs. This may include views, ETL and ELT processes that manipulate, aggregate, clean, or enrich the data.
Own and drive forward specific areas of technology architecture
Provide architectural solutions/designs to project execution teams for implementation
Develop Proof-of-Concept projects to validate new architectures and solutions.
Engage with business stakeholders to understand required capabilities, integrating business knowledge with technical solutions
Engage with Technical Architects and technical staff to determine the most appropriate technical strategy and designs to meet business needs
Demonstrate broad solutions technical leadership, impacting significant technical direction, exerting influence outside of the immediate team and driving change
*NOTE: Responsibilities of this role are not limited to the details above. *
Your talents needed for success
Data & Analytics project implementation experiences that exploit the full capabilities (discover, design, implement and optimization)
Experience in project and solution estimation and team structure definition for Big Data and traditional data warehousing projects
Extensive hands-on expertise with SQL and SQL analytics
Experience on AWS, Azure, Snowflake, Power BI, Tableau or similar with data architecture, design, analytics and deployment
Experience with high-scale distributed MPP databases such as Greenplum and standard RDBMS systems (PostgreSQL, Oracle, Exadata, Sybase, SQL Server)
Experience in Agile development and delivery
Experience with CI/CD and working knowledge of Jenkins, Bitbucket, JIRA
Familiar with AWS infrastructure components and services like S3, EC2, EMR
Experience in creating scalable data processing pipelines using Python and PySpark in EC2 and EMR environments
Knowledge in process flow orchestration using Airflow DAG’s or equivalent tools
Experience working on multiple concurrent projects
Be independent and self-driven
8+ years’ experience designing and implementing data lakes and warehouses
2+ years’ experience implementing AWS based solutions
6+ years’ experience working as a Solution architect
6+ years’ experience working as a Technical architect
Must have significant experience with:
One or more market leading ETL/ELT platforms
One or more market leading Business Intelligence / Visualization tool
Bachelor’s degree required with Masters or equivalent experience
More jobs from our partners (715)
State FarmData Analyst- Data Analytics and Technical Product Ownership – 2020-12558 on23 January 2021Full Time
AppleAI/ML – Senior Analyst Operations, Annotation Operations on23 January 2021Any