AstraZeneca logo

Senior Analyst - Snowflake / SQL Developer

AstraZeneca
NewPosted yesterday

LOCATION

Bangalore · Onsite

EXPERIENCE

8+ Years

SKILLS REQUIRED

SQLSnowflakeData ModelingData WarehousingData ValidationDashboard DevelopmentPower Bi

Job description

Overview

Individual contributor role supporting the Alexion Commercial Reporting team by designing, developing and maintaining Snowflake-based data models, SQL reporting layers and Qlik Sense/Power BI dashboards.

What you'll do

  • Design, develop, validate and maintain Qlik Sense/Power BI dashboards and supporting data models and reporting layer development for various business units and indications.
  • Understand business objectives, data sources and key performance indicators (KPIs) to design effective solutions.
  • Collaborate with business collaborators to gather, interpret and document business rules and logic requirements for reporting use cases.
  • Design and implement logical and physical data models in Snowflake that embody the agreed business rules and facilitate easy reporting.
  • Create and manage SQL-based tables and views to serve as the reporting layer for Power BI/Qlik dashboards and reports.
  • Monitor and tune the performance of Snowflake queries, tables and views to ensure efficient data retrieval and reporting.
  • Carry out data validation, testing and post-production checks to ensure data accuracy and completeness across the reporting platform.
  • Bridge the gap between business customers and technical developers, encouraging clear communication on data requirements and logic implementation.
  • Provide timely responses to ad-hoc business queries and investigative requests.
  • Maintain up-to-date documentation on data models, business rule mappings and reporting logic.
  • Proactively find opportunities to enhance data processes, optimize models and improve reporting efficiency.

What you'll need

  • 8+ years of professional experience.
  • Advanced understanding/experience with SQL, Snowflake and Veeva CRM.
  • Hands-on experience with Snowflake, SQL and data warehousing in a reporting environment.
  • Ability to create new rules and adjust existing rules in table/view creations.
  • Work on creating ER diagrams and logical data models.
  • Familiarity with ETL processes and data integration concepts.
  • Proven expertise in translating business requirements into technical specifications and robust data models.
  • Develop and maintain comprehensive user documentation for data processes, SQL queries and data-related workflows.
  • Expertise in SQL scripting and data modelling concepts, including related skills in: data warehouse, data architecture, data visualization, security and compliance.
  • Recent project experience with Qlik/PBI, plus experience with other BI tools.
  • Experience in documenting data processes, data lineage and reporting frameworks.

Nice to have

  • 6-8 years of experience in developing data models and architecting schemas.
  • Experience with database performance tuning and optimization.
  • Knowledge of ETL processes and data integration workflows.
  • Excellent analytical and problem-solving skills, with keen attention to detail.
  • Ability to work independently and multi-functionally in a fast-paced environment.
  • Good communication and interpersonal skills.
  • Snowflake Certified Data Architect.

Details

  • Location: Manyata Tech Park, Bangalore, India.
  • Shift: 2 pm to 11 pm IST.
  • Grade: D1.
  • Work mode: a minimum of three days per week from the office.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Senior Analyst - Snowflake / SQL Developer