Analyst & Power BI Support, Data Visualization

Key Skills

Business Intelligence, Data Visualization, Database, English Proficiency, Marketing Strategy, Microsoft Office suites, Microsoft-Excel, PowerBI, Powerpoint, Sales, SQL

Job Description

About This Role

You will build and support the US Data Visualization & Reporting capability as part of the US Data Strategy for the US Commercial Organization at Biogen. As part of the US Data team, you will enable the US Commercial digital and analytics strategies by developing data solutions that maximize the use of our data assets. As a partner to US Data Team, you will execute and streamline monthly reporting, lead ad hoc analytics use cases, and communicate with all TA’s to build end-to-end data management in close collaboration with stakeholders in CE&O, Finance and IT management.

What You’ll Do:

• Design, develop and publish new dashboards and work on enhancements
• Translate complex data sets into actionable reporting frameworks and models to enable key performance indicator (KPI) visualization that supports high performance for end users
• Use industry standard business intelligence (BI) tools (including Business Objects, QlikView, QlikSense) to formulate metrics and to create data quality management assessments and tools to perform ad hoc data inquiries
• Perform training to other PowerBI users, as needed
• Responsible for design and updating methodology and project documentation
• Collaborate with internal teams to understand business needs, and work to gain in-depth understanding of company processes and procedures
• Translate business needs to technical specifications
• Conduct unit testing and troubleshooting
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Follows quality assurance and control processes, and performs routine data management tasks, such as data validation and correction, queries and editing to ensure data accuracy, integrity, and completeness
• Perform other duties as assigned

Qualifications

Who You Are

You are an experienced with Pharmaceutical data assets & vendors professional, with great practical knowledge of BI tools and ability to integrate reporting components from multiple data sources. You know how to optimize dashboards with focus on usability, performance, flexibility and standardization. You have effective analytical, conceptual, and problem-solving skills and you are passionate about data visualization.

Required Skills

• Min Bachelor’s degree in business or science related
• Proficient in English;
• Technical capabilities with MS Office, in particular PowerPoint and Excel (including Pivot Tables, Charts, and vLookup).
• 1 - 3 years of practical experience working directly with Power BI; experience in developing, publishing and scheduling Power BI reports as per the business requirements
• 1-3 years’ practical experience with writing and debugging SQL queries
• Ability to integrate reporting components from multiple data sources
• Effective analytical, conceptual, and problem-solving skills
• Experience in optimizing dashboards with focus on usability, performance, flexibility and standardization
• Analytical thinking for translating data into informative reports and visuals
• Experience with Pharmaceutical data assets & vendors; knowledge of commercial analytics (Sales, Marketing, Managed Markets) in small specialty markets is a plus
• Passionate about data visualization