Sr. Business Data Analyst

Want to help people and be part of a growing company? BioCare is a distributor of Specialty Pharmaceuticals that treat rare diseases, such as hemophilia, immune system deficiency and ALS. We are looking for an Sr. Business Data Analyst to join our team and develop solutions that support our ability to get the right medication into the right hands, at the right time. If you want to make a difference in people’s lives, apply today to be part of the BioCare family!

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
  • Competitive pay
Typical duties:
  • Designs and develops new reports based upon defined requests, following SOPs
  • Creates and runs daily, weekly and monthly sales, finance and transactional reports (both manual and automated)
  • Manages report request queue from initiation through completion, including detailed requirements, design and validations
  • Participates in business analysis activities to maintain reports and develop enhancements as needed
  • With knowledge of structured and unstructured data from ERP and other systems, creates simple and meaningful data representations supporting the data request from business users
  • Designs and implements new ETL processes and adapts current ETL processes to accommodate changes in source systems/new business user requirements
  • Researches and resolves data inquiries and requests
  • Advises on latest tools, frameworks and mechanisms for data analytics
  • Assists and develops report standards and best practices or guidelines for repeatable tasks
  • Works with other Business Analysts and IT personnel to ensure that business data requirements are met
  • Defines, creates and refines data models to meet existing and new data requests
  • Works with Director, Analytics to research and analyze the business requirements and develop technical solutions to meet them
  • 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:
  • Requires Bachelor's Degree in Computer Science, Management Information Systems/Business Information Systems, Engineering or equivalent combination of education and experience
  • Over 3+ years of experience with Microsoft SQL Server 2008/2012, SSIS/SSRS in OLTP and OLAP (Data warehousing) environments.
  • Extensive experience in BI Tech stack (ETL & Reporting) using Data factory, SSIS, SSAS, SSRS, T-SQL; programming for various business applications in Star schema; data lake and synapse experience is a plus
  • Working experience with MS Dynamics F&O and SCM is a plus
  • Experience in business analysis, business process definition, data analysis, data mapping, reporting analysis, requirement analysis, business modeling in Power BI/DAX and PBRS
  • Extensive ability in writing T-SQL queries and developing SQL stored procedures
  • Advanced skills in creating Reports, Dashboard and perform Data Visualization using Power BI
  • Experience on IDE Visual Studio 2010/2015/2017, X++, Azure DevOps is a plus
  • Proficient in software development lifecycles, namely Waterfall and Agile methodologies
  • Ability to think strategically and independently
  • Ability to design business flows, functional and technical documents (RDD, TDD and FDD)
  • Strong work ethic with a sense of urgency
  • Takes initiative and owns responsibilities in projects
  • Ability to organize, prioritize, and deliver results with a variable workload and multiple priorities
  • Successful when working independently and as an active participant in a team environment
  • Excellent interpersonal skills, including the ability to communicate effectively in both oral and written formats with customers, employees, and vendors at all levels
  • Ability to maintain confidentiality
  • Must pass background check within company standards
  • Must be able to pass pre-employment drug screen

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.