Job Title: Senior Business Intelligence (BI) Developer
Reports To: Director of Business Intelligence and Advanced Analytics
Location: Columbia, MD (hybrid – 3 days in the office per week)
Summary:
We are looking for a Senior Business Intelligence (BI) Developer to create and manage BI and analytics solutions that turn data into insights. The ideal candidate will have a background in data and business analysis, as well as solid experience in data modelling and reporting using Power BI.
This is a recent expansion to the existing BI team and is a great opportunity for profiles who are particularly strong in leveraging data to inform business decisions. You will likely thrive in driving change and user adoption of our BI solutions. A background in finance – or a strong understanding of financial processes and terminology – is a distinct advantage.
You will play a key role in our large-scale transition from legacy BI platforms to our new Microsoft Azure data platform, helping the business strengthen data-driven decision-making, performance management, and advanced analytics capabilities.
In this role, you will support BI initiatives in the U.S. with a particular focus on finance reporting and analytics, while serving as part of the global BI & Advanced Analytics team based at our headquarters near Copenhagen, Denmark.
Essential Functions / Responsibilities:
- Gather business needs across functions, however with primary focus on Finance, and translate these requirements into technical specifications
- Analyze and understand data and dataflow across source systems like ERP (M3/Infor), CRM (Salesforce), Financial Consolidation (TM1) and other systems like Success Factor etc.
- Ensure that best practices for data modelling and reporting are consistently applied within Ambu USA, while maintaining a strong global perspective across the entire Ambu organization.
- Design, develop and maintain Power BI semantic models and reports
- Take active part in migrating legacy reporting and data from our old data platforms to our newly established MS Azure platform
- Collaborate with the backend team, handing over technical specifications and ensuring good, solid and well performing end to end data and reporting solutions to business
- Ensure high level of data trust and integrity
- Maintain and support data analytics platforms, including testing, troubleshooting and ensuring updated technical documentation
- Train users in Power BI reporting on all levels from report consumer to advanced report builder using DAX
Qualifications / Education:
- Proven experience as a BI Developer with 5-7 years of experience in data modeling and report building
- Excellent in user adoption activities like hosting BI community calls, Power BI training and other broad communication of BI news and updates
- Strong technical understanding of multiple reporting tools such as Power BI and Salesforce Analytics
- BS/BA in Computer Science, Engineering, Business Administration and Analytics or other relevant field preferred
- Experience analyzing and documenting different systems, processes, and workflows
- Accustomed to support and work in a project heavy environment with the ability to diagnose and solve problems quickly
- Strong stakeholder and change management skills at all levels of the organization
- Interest or experience in more advanced analytics using Python, Spark, R as well as how to leverage the use of AI in the space of BI and analytics
- Proven abilities to take initiative and be innovative and proactive
- Analytical mind with a problem-solving and service minded attitudeStrong knowledge and experience across the full Microsoft suite
- Good base knowledge of the ETL process and data warehousing as well as experience with SQL
- Stay updated with technological developments in the BI areas
- Basic understanding of database management systems, online analytical processing (OLAP), ETL (Extract, transform, load) framework and dimensional modeling
- Experience in medical device or pharmaceutical industry preferred