About this roleCompany: BlackRock Financial Management, Inc. Job Title: Associate Location: 50 Hudson Yards, New York, NY 10001Job Duties: Design, implement and maintain a robust OLAP data warehouse on Snowflake and Sybase IQ that caters to Investment Book of Record (IBOR), Accounting Book of Record (ABOR) and Analytics &amp; Risk. Conduct Data Pipeline engineering efforts for different domains that includes premium content like Investment Operational KPIs. Build pipelines on enterprise data platform leveraging core technologies that includes Airflow, DBT, Snowflake, and DataHub. Support external clients (40+) for Aladdin Data Cloud (ADC). Drive standardization across all schemas for all client environments that requires strong working knowledge in all the domains, expertise in metadata, identifying data and schema parity, collaborate with product marketing for client notifications and release management. Act as a mentor for analysts and interns.Qualifications: Bachelor’s degree in Computer Science, Engineering (any), Information Technology, or a related field and two (2) years of experience as an Associate, Application Engineer, Analyst; or a related role. Must have two (2) years of experience with: Sybase IQ and Cassandra; Using Snowflake’s cloud data platform including Snowflake SQLs, stored procedures, query optimization, snowpark, snowpipe and data sharing; Data Discovery, Operational Tooling, and Semantic modeling; Character encoding standards (UTF-8, ISO-8859-1, ASCII) to maintain data integrity during ingestion; Building, optimizing, and managing ETL/ELT pipelines for structured and semi-structured data; Development using Agile methodologies; Version control using Git and Maven; Using SQL and corresponding tools to query data within large datasets in a business environment; Designing, developing and integrating APIs using Protocol Buffers and adhering to AIPs; Orchestration and automation with Airflow and DBT; Managing relational and dimensional schemas and ETL pipelines for ABOR, IBOR, Analytics and Risk as well as KPI datasets; Implementing and managing single-tenant and multi-tenant solutions while ensuring scalability and data isolation; and Hands-on experience in open-source data catalogue platforms including DataHub. Must have one (1) year of experience with: Liquibase for database schema version control and change management.To apply, please click “Apply” on this webpage  &amp;#xa;For New York, NY Only the salary range for this position is USD$145,700.00 - USD$162,000.00 . Additionally, employees are eligible for an annual discretionary bonus, and benefits including healthcare, leave benefits, and retirement benefits. BlackRock operates a pay-for-performance compensation philosophy and your total compensation may vary based on role, location, and firm, department and individual performance.&amp;#xa;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 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 <a href="http://careers.blackrock.com/" target="_blank">@blackrock</a> | Twitter: <a href="https://twitter.com/blackrock" target="_blank">@blackrock</a> | LinkedIn: <a href="http://www.linkedin.com/company/blackrock" target="_blank">www.linkedin.com/company/blackrock</a><div></div><div></div>BlackRock is proud to be an equal opportunity workplace. We are committed to equal employment opportunity to all applicants and existing employees, and we evaluate qualified applicants without regard to race, creed, color, national origin, sex (including pregnancy and gender identity/expression), sexual orientation, age, ancestry, physical or mental disability, marital status, political affiliation, religion, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. View the <a href="https://www.dol.gov/sites/dolgov/files/OFCCP/regs/compliance/posters/pdf/22-088_EEOC_KnowYourRights.pdf" target="_blank">EEOC’s Know Your Rights poster and its supplement</a> and the <a href="https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf" target="_blank">pay transparency statement</a>. BlackRock is committed to full inclusion of all qualified individuals and to providing reasonable accommodations or job modifications for individuals with disabilities. If reasonable accommodation/adjustments are needed throughout the employment process, please email <a href="mailto:Disability.Assistance@blackrock.com" target="_blank">Disability.Assistance@blackrock.com</a>. All requests are treated in line with our <a href="http://www.blackrock.com/corporate/compliance/privacy-policy#recruitment-privacy-notice" target="_blank">privacy policy</a><a href="http://www.blackrock.com/corporate/compliance/privacy-policy#recruitment-privacy-notice" target="_blank">.</a>BlackRock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law, including any applicable fair chance law.