REQUIRED EDUCATION, SKILLS AND EXPERIENCE:

• Minimum of 3+ years in a Business Intelligence or equivalent role.
• Bachelor’s 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:

• Master’s in Data Science, Master’s 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 individual’s 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 Year’s 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

• 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.