Associate, Data Engineer Etl Architecture

Description About this role About Data Ops Engineering (DOE) Data is at the heart of Aladdin and increasingly the ability to consume, store, analyse and gain insight from data has become a key component of our competitive advantage. The DOE team is responsible for the data ecosystem within BlackRock. Our goal is to build and maintain a leading-edge data platform that provides highly available, consistent data of the highest quality for all users of the platform, notably investors, operations teams, and data scientists. We focus on evolving our platform to deliver exponential scale to the firm, powering the future growth of Aladdin data. About this role As a Data Engineer at BlackRock, you will get an experience working at one of the most recognized financial companies in the world while being part of a team responsible for building ETL framework for next generation Enterprise Data platform (EDP), which is designed to automate data acquisition, ingestion, transformation, and distribution processes to handle enterprise-wide data processing capabilities. You will partner with data and analytics experts to deliver high quality data analytical solutions to our consumers. Candidates are expected to have deep understanding of a core ETL components. This role is responsible for embodying engineering best-practices as a habit. Also responsible for ensuring long-term sustainability and scalability of work. Data engineers are expected to work in the areas of building frameworks for ETL/ELT use cases and metadata driven data pipeline processing engines with cloud native service expertise. We are looking for the candidates, who like to innovate and resolve complex data problems. Responsibilities: Data engineer is expected to be engaged from inception of projects, understand requirements, design architecture, develop, deploy, and maintain ETL / ELT framework. The goal is to increase the automation of data pipelines, support both internal and external teams to leverage the reusable ETL components and adopt to the standards of modern data platform while constantly working towards enhancing the enabling core ETL framework with new features and improving platform performance and scalability. Contribute to the development life cycle and maintain ETL framework, acquisition framework, workflow orchestration for data pipelines, including participation in tactical projects and strategic programs. Generate ideas for designing and building Data Engineering solutions using standard frameworks. Adopt new tools and technologies to enhance the capabilities for the frameworks. Work with program managers, product teams and data stewards throughout the SDLC cycle. Build and conduct end-to-end tests to ensure production operations run successfully after every release cycle. Provide L2 or L3 support for technical and/or operational issues. Ability to speak with confidence to individuals, both technical and non-technical, outside the team. Ability to lead process engineering for a data pipeline engineering area. Ability to demonstrate deep understanding of ETL/ELT core components. Ability to design and build ETL solutions which are performant, consistent, and scalable. Ability to contribute on design decisions for complex systems. Ability to support the ETL framework including all complex components. Take responsibility for work beyond assigned tasks. Take emotional ownership of projects. Address issues promptly and transparently. Take on challenges outside of day-to-day responsibilities. Required Experience: At least 3+ years' experience as a Data Engineer ETL/ELT Framework design and Workflow Orchestrations Experience with object-oriented design patterns Experience with ETL Performance Tuning Experience in SQL, PL/SQL programming, Stored procedures, UDFs Experience in Python / PySpark programming Experience with Agile development concepts and related tools Experience conducting root cause analysis and solve issues. Excellent written and verbal communication skills. Ability to operate in a fast-paced environment. Strong interpersonal skills with a can-do attitude under challenging circumstances BS equivalent degree Desired Qualifications: Experience with Snowflake, SnowPipe, Snowpark Exposure with Workflow management tools such as Airflow ETL tools like DBT Experience in Azure Cloud Native services Exposure to real time streaming platforms such as SnowPipe Streaming, Kafka Bachelor's degree in computer science is preferred. Our benefits To help you stay energized, engaged and inspired, we offer a wide range of benefits including a strong retirement plan, tuition reimbursement, comprehensive healthcare, support for working parents and Flexible Time Off (FTO) so you can relax, recharge and be there for the people you care about. Our hybrid work model BlackRock's hybrid work model is designed to enable a culture of collaboration and apprenticeship that enriches the experience of our employees, while supporting flexibility for all. Employees are currently required to work at least 4 days in the office per week, with the flexibility to work from home 1 day a week. Some business groups may require more time in the office due to their roles and responsibilities. We remain focused on increasing the impactful moments that arise when we work together in person - aligned with our commitment to performance and innovation. As a new joiner, you can count on this hybrid model to accelerate your learning and onboarding experience here at BlackRock. About BlackRock At BlackRock, we are all connected by one mission: to help more and more people experience financial well-being. Our clients, and the people they serve, are saving for retirement, paying for their children's educations, buying homes and starting businesses. Their investments also help to strengthen the global economy: support businesses small and large; finance infrastructure projects that connect and power cities; and facilitate innovations that drive progress. This mission would not be possible without our smartest investment - the one we make in our employees. It's why we're dedicated to creating an environment where our colleagues feel welcomed, valued and supported with networks, benefits and development opportunities to help them thrive. For additional information on BlackRock, please visit @blackrock | Twitter: @blackrock | LinkedIn: www.linkedin.com/company/blackrock BlackRock is proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to age, disability, family status, gender identity, race, religion, sex, sexual orientation and other protected attributes at law. This employer is a corporate member of myGwork - LGBTQ+ professionals, the business community for LGBTQ+ professionals, students, inclusive employers & anyone who believes in workplace equality.