Skip to content

Open nowPosted 178 days ago

BI & Data Warehouse Data Engineer

Astellas93 open roles

Where
Bengaluru, IND
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowBI & Data Warehouse Data EngineerAstellas · Bengaluru, IND
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Astellas's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

13.7% of postings close within 7 days. Measured by our own scanner across the market. Astellas postings stay open a median of 7 days.

Share of postings closed within
  1. 2.3%1 day
  2. 4.8%3 days
  3. 13.7%7 days
  4. 22.1%14 days
  5. 37.2%30 days
  6. 59.1%60 days
This job: posted 178 days ago

Astellas median: 7 days open

The posting

As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives.

DigitalX our new information technology function is spearheading this value driven transformation across Astellas. We are looking for people who excel in embracing change, manage technical challenges and have exceptional communication skills. We are seeking committed and talented MDM Engineers to join our new FoundationX team, which lies at the heart of DigitalX. As a member within FoundationX, you will be playing a critical role in ensuring our MDM systems are operational, scalable and continue to contain the right data to drive business value. You will play a pivotal role in building maintaining and enhancing our MDM systems.

This position is based in Bangalore, India. We recognize the importance of work/life balance & believe in optimizing the most productive work environment for all employees to succeed and deliver.

Purpose and Scope:

As a Junior Data Engineer, you will play a crucial role in assisting in the design, build, and maintenance of our data infrastructure focusing on BI and DWH capabilities. Working with the Senior Data Engineer, your foundational expertise in BI, Databricks, PySpark, SQL, Talend and other related technologies, will be instrumental in driving data-driven decision-making across the organization. You will play a pivotal role in building maintaining and enhancing our systems across the organization. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilize your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.

Essential Job Responsibilities:

  • Collaborate with FoundationX Engineers to design and maintain scalable data systems.
  • Assist in building robust infrastructure using technologies like PowerBI, Qlik or alternative, Databricks, PySpark, and SQL.
  • Contribute to ensuring system reliability by incorporating accurate business-driving data.
  • Gain experience in BI engineering through hands-on projects.

Data Modelling and Integration:

  • Collaborate with cross-functional teams to analyze requirements and create technical designs, data models, and migration strategies.
  • Design, build, and maintain physical databases, dimensional data models, and ETL processes specific to pharmaceutical data.

Cloud Expertise:

  • Evaluate and influence the selection of cloud-based technologies such as Azure, AWS, or Google Cloud
  • Implement data warehousing solutions in a cloud environment, ensuring scalability and security.

BI Expertise:

  • Leverage and create PowerBI, Qlik or equivalent technology for data visualization, dashboards, and self-service analytics.

Data Pipeline Development:

  • Design, build, and optimize data pipelines using Databricks and PySpark. Ensure data quality, reliability, and scalability.
  • Application Transition: Support the migration of internal applications to Databricks (or equivalent) based solutions.
  • Collaborate with application teams to ensure a seamless transition.
  • Mentorship and Leadership: Lead and mentor junior data engineers. Share best practices, provide technical guidance, and foster a culture of continuous learning.
  • Data Strategy Contribution: Contribute to the organization’s data strategy by identifying opportunities for data-driven insights and improvements.
  • Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond.
  • Design, develop and implement robust and scalable data analytics using modern technologies.
  • Collaborate with cross functional teams and practices across the organization including Commercial, Manufacturing, Medical, DataX, GrowthX and support other X (transformation) Hubs and Practices as appropriate, to understand user needs and translate them into technical solutions.
  • Provide Technical Support to internal users troubleshooting complex issues and ensuring system uptime as soon as possible.
  • Champion continuous improvement initiatives identifying opportunities to optimize performance security and maintainability of existing data and platform architecture and other technology investments.
  • Participate in the continuous delivery pipeline. Adhering to DevOps best practices for version control automation and deployment. Ensuring effective management of the FoundationX backlog.
  • Leverage your knowledge of data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization.
  • Stay-up to date on the latest trends and technologies in data engineering and cloud platforms.

Qualifications:

Required

  • Bachelor's degree in computer science, Information Technology, or related field (master’s preferred) or equivalent experience
  • 3-5+ years of experience in data engineering with a strong understanding of BI technologies, PySpark and SQL, building data pipelines and optimization.
  • 3-5+ years + experience in data engineering and integration tools (e.g., Databricks, Change Data Capture)
  • 3-5+ years + experience of utilizing cloud platforms (AWS, Azure, GCP). A deeper understanding/certification of AWS and Azure is considered a plus.
  • Experience with relational and non-relational databases.
  • Any relevant cloud-based integration certification at foundational level or above. (Any QLIK or BI certification, AWS certified DevOps engineer, AWS Certified Developer, Any Microsoft Certified Azure qualification, Proficient in RESTful APIs, AWS, CDMP, MDM, DBA, SQL, SAP, TOGAF, API, CISSP, VCP or any relevant certification)
  • Experience in MuleSoft (Anypoint platform, its components, Designing and managing API-led connectivity solutions).
  • Experience in AWS (environment, services and tools), developing code in at least one high level programming language.
  • Experience with continuous integration and continuous delivery (CI/CD) methodologies and tools
  • Experience with Azure services related to computing, networking, storage, and security
  • Understanding of cloud integration patterns and Azure integration services such as Logic Apps, Service Bus, and API Management

Preferred

  • Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations/ reporting within Life Sciences/ Pharma industry across Commercial, Manufacturing and Medical domains.
  • Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical.
  • Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools
  • Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
  • Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
  • Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

Working Environment

At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

#LI-CH1

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Astellas's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on Astellas's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    Astellas's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.