Analyze and refine requirements for delivering the necessary solutions to business

Ensure assigned feature requests development meets with design and architectural standards while meeting quality, performance, security, and business requirements

Contribute to developing BI solutions in large-scale projects for key finance processes on global & headquarter core applications with significant impact on Novartis financial results

Contribute to ensuring digital technology impact analysis is provided to the dev lead

Be ultimately accountable for the full lifecycle of feature requests development

Communicate complex data or algorithms into simple conclusions that will empower leadership to drive action based on the insights you derive

Advanced degree in Computer Science, Business Intelligence, Statistics, Finance, or Business Administration

3+ years of experience in BI/DWH development enhancement, preferably related to database solution development both relational and dimensional data modeling

Deep, hands-on technical and operational expertise with MS SQL Server 2016 (including T-SQL and performance tuning), SQL Integration Services, Redgate Toolbelt, Snowflake, Confluence, and Jira

Exposure to SQL Server performance and general database management, including index refinement, query plan optimization, and general administration

Hands-on experience using GIT applied to DB development (VS 2019 DB), preferably using Gitflow branching strategy

Capacity to provide technical assessment to dev lead to enable construction of product strategy roadmap

Proven history delivering timely, high-quality, senior manager-level reporting and analysis from diverse, complex data sources and coping with operational activities

Proficient in AWS Lambda, Apache Airflow, and Databricks

B2+ English level