Data Analyst

Full Job Description
If you want to be part of a growing company that’s making a difference in people’s lives, BioCare may be just the place for you! BioCare is a distributor of Specialty Pharmaceuticals that treat rare diseases, such as hemophilia, immune system deficiency and ALS. We are looking for a Data Analyst to join our growing IT & Analytics team. Apply today to support our ability to get the right medication into the right hands, at the right time!
Why you should apply:
- Low cost and flexible medical, dental & vision plans
- 17 days (136 hours) Paid Time Off accrued during your first year
- Up to 40 hours Paid Sick Time accrued annually
- 401k with 5% employer match
- Company paid life and disability insurance
- Hybrid work schedule
- Competitive pay
Typical duties:
- Assess new reporting requests and enhancement to existing ones and complete them
- Designs and develops new reports and visualizations based upon defined request and follow laid out SOPs
- Lead and manage delivery of daily, weekly, and monthly sales, finance, and transactional reports both manual and automated.
- Create and manage data modelling, visualizations, and analysis for existing and new reports
- Follow data strategy for projects to onboard new trading partners and systems
- Create and manage delivery of routine and ad hoc reports needed to support business and trading partner requests
- Follow report standards and best practices or guidelines for reports development & repeatable tasks
- Understands structured and unstructured data from ERP and other systems. Use the knowledge into simple and meaningful data representations supporting the data request from business users.
- Support and implement continuous improvement processes across the reporting portfolio to incorporate automation.
- Work with rest of analytics team on various data projects, process improvement and technical innovations
- Extracts data from identified databases on both on premises and cloud. Transform data to a structure that is relevant to the problem by selecting appropriate techniques.
- Analyzes complex data elements, extract, filter and aggregate data through logical SQL queries and programming
- May provide maintenance support, including enhancements and production support activities
- Deliver quality customer service to all team members, customers, and stakeholders
- Actively listen and collaborate with end users to design effective solutions that resolve issues
What we are looking for:
- Bachelor’s degree in an IT or Computer Science discipline OR equivalent experience.
- 5+ years’ experience as a reports developer/analyst with the ability to read and write complex queries, ability to create database objects (tables, views, stored procedures, user-defined functions) and create complex visualizations and dashboards.
- Expertise in Power BI from creating complex dashboards, visualizations, DAX queries to managing data security
- Sound experience in designing and developing reporting solutions with SSRS/PBRS and other MSDN tools.
- Experience with Azure data factory, Azure data warehouse is a plus
- Expert in different SQL techniques for data transformation and data analysis
- Experience in working source control tools such as SVN and GitHub
- Certification in Power BI modeling, visualization and analyzing data is preferable
- Quality and Improvement focus to ensure data reliable, timely, and complete data
- Ability to multitask and prioritize completing tasks
- Possess an analytical mindset and problem-solving aptitude
- Familiarity with working in Agile environment leveraging DevOps, change management process and tool like Jira
- Ability to work independently and in a fast-paced, high growth environment
- Excellent organization skills and attention to detail
- Must be able to pass drug test and background check aligned with company and accreditation standards
We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, gender, marital status, national origin, ancestry, disability, genetic information, medical condition, military/veteran status, sexual orientation, gender identity, gender expression, or any other characteristic protected by law.