Senior Analyst - Snowflake / SQL Developer
Core
Design, develop, and maintain data reporting solutions and analytics platforms to transform raw data into actionable insights for the Alexion Commercial Reporting team.
Role type
Senior Individual Contributor Data Reporting and Analytics Developer
Builds
Qlik Sense/Power BI dashboards, Snowflake data models, and SQL-based reporting layers
Domain
Biopharma / Commercial Reporting / Data Warehousing
Deliverable
dashboards & analysis
Required skills
SQL, Snowflake, Data Modeling, Data Warehousing, ETL, Data Visualization, Business Requirements Translation, Data Validation, Performance Tuning
Preferred skills
Veeva CRM, ER Diagramming, Data Lineage Documentation, Database Optimization, Snowflake Certification
Technologies
Snowflake, SQL, Qlik Sense, Power BI, Veeva CRM
Responsibilities
Design and implement logical and physical data models in Snowflake; Create and manage SQL-based tables and views for reporting; Monitor and tune performance of Snowflake queries; Collaborate with business units to gather requirements and document business rules; Provide timely responses to ad-hoc business queries and investigative requests; Carry out data validation and post-production checks to ensure accuracy.
Seniority
Senior, hands-on IC