BI Analyst

Title: Business Analyst (Power BI)
Duration: 3 months
Location: Princeton, NJ, 08540
 
Qualifications:

• A successful candidate will be a key member of the Commercial Excellence team, who will combine strong technical skills with business acumen and effective communication skills to bring complex data-driven solutions to life.
• The role requires an individual who has built end-to-end BI solutions and is highly motivated to take the responsibility for BI solutions from conception through to successful delivery.
• The BI expert will engage with multiple stakeholders within the organization to collect, organize, analyze and disseminate significant amounts of information with unparalleled attention to detail and accuracy.
• A natural self-starter, you have a passion for using data to drive business decisions, are comfortable with writing SQL queries, data mining and visualization techniques, and are at home partnering with end users to deliver solutions.
• You will provide us with crucial insight into how we are performing as an organization, and if we are on track with our strategic goals.

 
Position Responsibilities

• Responsible for designing, developing, and deploying Business Analytics Dashboards using Microsoft BI technologies including SQL Server, Power BI, Excel etc.
• Analyze external data sources like Salesforce, Global BI, Cognos, and Informatica to integrate with existing datasets and relate a comprehensive BI story.
• Build compelling, interactive and actionable reporting on top of structured data models that helps in deriving meaningful business insights from large, complex datasets.
• Supporting the full BI lifecycle from requirements analysis through design & development, and through release and support/maintenance phases
• Gather requirements and design reports/custom sales analysis tools for the Commercial Operations, Marketing & Sales teams.
• Some of the reports that will be required but not limited to this set are:
• Daily/weekly/monthly performance reports for key performance indicators and provide analytics on them.
• Sales reports for monthly/quarterly/annual forecasting for area wise Business Reviews.
• Gather, publish & maintain information related to historical, current and future performance.
• Compile and analyze data on historical sales and trends to forecast future trends.
• Collaborate on identified ad hoc business problem-solving requests.
• Train team members/ users on Power BI tool, dashboards and reports, as required by Commercial Excellence team.
• Complies with U.S. Food and Drug Administration (FDA) regulations, other regulatory requirements, Company policies, operating procedures, processes, and task assignments.

 
 
Position Requirements

• Four-year degree in Business, Accounting or Finance. Advanced degree preferred.
• 5+ years of combined experience in business, accounting, or finance.
• Experience with Data Analysis and Visualization of Power BI Dashboards
• Experience with data integration of Power BI with Salesforce.com, Oracle DBs, SQL Server, and Excel.