Are you an operational, hands-on business intelligence professional? If so, Elevation is actively seeking a Power BI Developer for a leading PE-backed, fast growing sterile injectable pharmaceutical manufacturing company, and we would love to speak with you!
Overview:
Reporting directly to the Vice President of IT, the Business Intelligence Developer will support the data reporting and analysis of the company by collecting, compiling, analyzing, and reporting information using various system tools and techniques. The position will work with internal (Operations, Sales, Production, Quality, Finance, Accounting) and external (third-party vendors) clients to identify analytical requirements, create and provide business data analytics and produce standardized and ad hoc data, reporting & dashboarding.
What You Will Be Doing:
Data Management
- Working with internal customers to identify the data sets and metrics needed to support key business decisions with data management, automation and analysis via reporting and dashboards
- Creating and maintaining the ETL solution to populate analytical data models from a variety of source systems within the business
- Owning stability of designed solutions and data refreshes (nightly updates for most reports, but some reports might require more frequent updates) without impacting performance of underlying source systems.
- Ensuring data quality by working with internal customers, application vendors, and IT resources to define data validation rules and manage (daily/weekly/monthly) the timely resolution of data accuracy/quality issues
Reporting and Data Visualization
- Gathering user requirements for data access, reporting, and dashboard development including frequency, format, and route of access
- Creating data access, reports, and dashboards using tools and techniques for data visualization that is timely, relevant, and accurate
- Working effectively with third-party vendors and various software publishers to improve and enhance data capture and visualization
- Utilizing available tools, such as Power BI, Azure pipelines / data factories, Power Automate / flow, SharePoint, email groups to develop and distribute reports and dashboards to users.
- Managing the backlog of report and dashboard requests by facilitating discussions of scope, feasibility, and prioritization with business users
What You Need to Have:
- BA/BS degree in Information Systems, Computer Science, Business Administration, or similar field preferred
- 3+ of years of related BI experience
- 2+ years of experience in Power BI and SQL Server Management Studio
- Strong SQL & DAX language skills
- Azure Data Factory Experience preferred
- Experience collaborating with multiple stakeholders including business users, technical application specialists and other team members
- Ability to adjust to changing priorities and participation in multiple projects
- Ability to communicate with multiple levels of management and collaborate with a variety of individuals to understand current issues and achieve business results
- Solid communication, analytical, and problem-solving skills
- Desire to work in a team-oriented environment and willingness to cross-train colleagues (and vice versa) on critical support tasks
- Balanced focus on technical solution development as well as documenting what was developed to ensure long term maintainability.
- A service-oriented mindset and desire to make a difference to support the company’s growth journey