What are the responsibilities and job description for the Business Intelligence Analyst position at Pharma Logistics?
Job Title: Business Intelligence Analyst
Location: Libertyville, IL (Hybrid)
Job Summary: The Business Intelligence Analyst is responsible for building and maintaining reports that directly track company key performance indicators and customer facing reports that allow customers to obtain information directly pertaining to their accounts. The Business Intelligence Analyst will own and maintain all analytic data models and reports, including ad-hoc, regulatory and compliance reports. This role will analyze data sets, make insightful recommendations, and communicate strategic ideas to inform key decision makers about customer needs and where to invest future efforts, using data-driven insights to fuel strategic growth. They will also support data stewards with data governance and data quality assurance.
Job Duties and Responsibilities:
- Responsible for creating, maintaining, and delivering reports at executive, department, and customer level.
- Key contributor to the data planning, consolidation, and reporting processes.
- Responsible for delivering new, re-usable business intelligence solutions and demonstrating value proposition to business stakeholders.
- Advocate for improvements to data quality and performance
- Collaborate with development and architecture teams, internal employees, and external partners (wholesalers, manufacturers, other commercial partners)
- Serve as a liaison to IT for data needs/inquiries/requests/solutions along with any enhancements or updates that affect existing systems.
- Collaborate with architecture team to design and optimize our cloud-based data warehouse architecture.
- Ensure business recommendations are based on accurate data and thorough analyses by rigorously stress testing data and assumptions.
- Deliver ad-hoc reports requested by business leadership team.
Required Education, Skills and Experience:
- Minimum of 3 years in a Business Intelligence or equivalent role.
- Bachelors degree in business, Computer Science, or similar preferred.
- Experience using SQL, writing complex queries and stored procedures.
- Experience with automating ELT processes and report delivery in multiple data formats.
- Experience with business intelligence tools (Sigma preferred).
- Must have a solid understanding of data warehouse architecture and best practices.
- Significant experience developing and delivering data solutions.
- Strong written and verbal communication skills with the ability to collaborate across teams and organizational levels.
- Passion for solving problems using data and analytics.
Beneficial Education, Skills, and Experience:
- Masters in Data Science, Masters in Business Administration with an analytics emphasis, or equivalent advanced degree is preferred.
- Experience with Snowflake serving as the Data Warehouse production platform.
- Experience with other data visualization tools like Tableau, PowerBI, Looker, and Periscope.
- Experience in, or interest in learning: Design data models within data warehouse (Snowflake) based on reporting, analytics, and data science requirements, Manage data architecture and catalog for Snowflake.
- Review data load processes, which include the use of a third-party ETL tool (DBT Cloud).
- Analyze loads and performance and suggest solutions to bottlenecks.
- Experience with reading and understanding various coding languages.
Compensation Range and Benefits
The salary range for this position is $95,000.00-113,000.00 USD annually. Actual salary may vary based on factors including, but not limited to, Pharma Logistics business and organizational needs, as well as an individuals relevant experience, education, qualifications, certifications, skills, seniority, geographic location, and/or performance.
Pharma Logistics offers medical, Dental, and Vision insurance (Blue Cross Blue Shield). Group life, AD&D, and long-term disability insurance. 14 days of paid time off, Hybrid schedule, along with major holidays (New Years Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, Friday after Thanksgiving, Christmas Day). 401k with 3% company contribution after 1 year of service.
Disclaimer:This job description is not intended to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Other duties, responsibilities, and activities may change or be assigned at any time with or without notice.
Salary : $95,000 - $113,000
