SanFranRecruiter Since 2001
the smart solution for San Francisco jobs

Associate, Data Engineer - ETL Architecture

Company: Blackrock, Inc.
Location: San Francisco
Posted on: April 2, 2024

Job Description:

DescriptionAbout this roleAbout 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 roleAs 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 degreeDesired 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 benefitsTo 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 modelBlackRock'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 BlackRockAt 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 - Twitter: - LinkedIn: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.

Keywords: Blackrock, Inc., San Francisco , Associate, Data Engineer - ETL Architecture, Engineering , San Francisco, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

San Francisco RSS job feeds