Power BI Developer

Lantheus is headquartered in Bedford, Massachusetts with offices Billerica as well as in Canada and Sweden.  For more than 60 years, Lantheus has been instrumental in pioneering the field of medical imaging and has helped physicians enhance patient care with its broad product portfolio.

Lantheus is an entrepreneurial, agile, growing organization that provides innovative diagnostics, targeted therapeutics, and artificial intelligence (AI) solutions that empower clinicians to find, fight and follow disease.  At Lantheus our purpose and values guide our behaviors in all interactions and play a vital role in creating a dynamic environment that contributes to our success.  Every employee is crucial to our success; we respect one another and act as one knowing that someone’s health is in our hands.  We believe in helping people be their best and are seeking to bring together a diverse group of individuals with different viewpoints and skill sets to be a part of a productive and inclusive team.

Summary

The Power BI Developer will partner with Lantheus Core IT team and business users to design, develop and maintain business intelligence (BI) solutions using Microsoft’s Power BI platform.  He/she will work closely with business analysts and data architects to convert raw data into meaningful insights and help the business make sense of their data.

The Power BI Developer will create, manage and deploy interactive reports and dashboards, using Power BI’s suite of tools, primarily transforming large data sets into visually compelling interactive insights that can influence strategic business decisions.  This involves data modeling, creating complex calculations and KPIs using DAX (Data Analysis Expressions), and designing visually appealing and intuitive reports.

The Power BI Developer will maintain and support the BI system, including troubleshooting performance issues, ensuring data accuracy, and implementing necessary updates or enhancements.  He/she will also work with stakeholders to understand their business needs and tailor the BI solutions accordingly, while also providing training and support to end-users, helping them make the most of the tools and reports available.  Additionally, the Power BI Developer will work to ensure the security of data by implementing appropriate access permissions and data protection measures.

Key Responsibilities

• Interact with business stakeholders and subject matter experts to understand their data visualization and business intelligence needs

• Translate business needs to technical specifications

• Design, develop, test, and deploy Power BI scripts and generate visually appealing and insightful reports

• Integrate Power BI reports into other applications to provide enhanced business capabilities

• Create custom visualization and implement row level security on data

• Build data models and develop dashboards using Power BI desktop

• Develop tabular and multidimensional models that are compatible with warehouse standards

• Work with application developers to design and develop Power BI data visualizations

• Use advance level calculations on the data set using DAX functions in Power BI

• Test formulas and visualizations to ensure their functionality

• Document the processes used and the methodologies implemented

Other Functions

• Maintain and support data analytics platforms (e.g. Azure Analytics)

• Create tools to store data (e.g., OLAP cubes)

• Evaluate and improve existing BI systems

• Collaborate with teams to integrate systems

• Develop and execute database queries and conduct analyses

• Provide guidance in other areas projects requiring visualization capabilities

• Experience with OTC (Orders to Cash) and Manufacturing Logistics & Inventory datasets preferred.

• Experience extracting data from SAP S/4 HANA or similar ERP systems.

Qualifications

• Proven experience as a BI Developer or Data Scientist

• 5-7 years’ reporting experience is preferred

• Background in data warehouse design (e.g., dimensional modeling) and data mining

• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

• Familiarity with BI technologies (e.g., Microsoft Power BI, Oracle BI)

• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

• Proven abilities to take initiative and be innovative

• Analytical mind with a problem-solving aptitude

• BS/BA in Computer Science, Engineering or relevant field

Lantheus is committed to equal employment opportunity and non-discrimination for all employees and qualified applicants without regard to a person's race, color, sex, gender identity or expression, age, religion, national origin, ancestry, ethnicity, disability, veteran status, genetic information, sexual orientation, marital status, or any characteristic protected under applicable law. Lantheus is an E-Verify Employer in the United States. Lantheus will make reasonable accommodations for qualified individuals with known disabilities, in accordance with applicable law.