Business Intelligence Specialist II

MEISSNER FILTRATION PRODUCTS; Camarillo (CA); On-site; USD 65,000 - 87,000; Full time

Benefits offered by this job

Medical, Dental and Vision coverage

HQ Onsite Gym

Free EV Charging Stations

401k, Profit Sharing

Life Insurance

Employee Assistance Program

Paid Time Off & Holidays

Job summary

Meissner Filtration Products in Camarillo, CA is seeking a Business Intelligence Specialist II to design, develop, and manage enterprise BI solutions. You will mentor junior team members and drive data modeling and optimization across projects.

This role requires advanced SQL, ETL, and experience with Azure Data Warehouse and Power BI. You will partner with stakeholders to translate needs into technical specs and ensure data quality.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Data Science or related field required.
• 4+ years of experience developing BI reports, dashboards, and data solutions.
• Advanced SQL skills and proficiency with multiple BI tools.
• Experience with ETL tools.
• Proficiency with Azure Data Warehouse or similar platforms.

Responsibilities

• Design and develop enterprise-level BI reports and dashboards supporting multiple business units using Microsoft technologies.
• Develop complex ETL processes and manage data warehouse objects.
• Create and optimize data models for improved report performance.
• Develop SQL queries to support reporting objectives.
• Lead requirements gathering sessions and translate business needs into technical specifications.
• Perform data quality audits and implement data validation frameworks.
• Optimize BI tool performance and manage system upgrades and migrations.
• Mentor level I Specialists and provide code review and quality assurance.
• Develop and maintain BI documentation and best practices standards.
• Troubleshoot complex technical issues and implement solutions.
• Recommend and implement enhancements to BI infrastructure and tools.

Skills

SQL

ETL

Azure Data Warehouse

Data Modeling

Python

Education

Bachelor’s degree in IT / CS / Data Science or related field

Tools

Power BI

Azure DevOps

ETL Tools

SQL Tools

Azure Data Platform

Job description

Design and deliver complex BI solutions that drive business insights across the organization while establishing yourself as a data modeling and optimization expert. Mentor junior team members and demonstrate technical ownership across moderate-to-complex projects.

Who is Meissner?

The goal at Meissner is to be more than simply good; it is to be extraordinary. Extraordinary performance comes from extraordinary people.

Meissner as a group is passionate about helping our clients manufacture lifesaving and life enhancing drugs, therapies, and vaccines. We develop, manufacture, supply and service advanced microfiltration products and single-use systems worldwide.

We know that when you are passionate about what you do, it’s more than just a job.

Meissner is focused on the development of the whole individual, and we have programs and tools in place to help us stay at our best mentally and physically. In alignment with our commitment to support the growth and development of the whole individual, Meissner has inaugurated a Learning and Development department to solely focus on cultivating our team. When you grow, we grow.

How you will make an impact:

The Business Intelligence Specialist II is responsible for designing, developing, and managing BI solutions. This role requires proficiency in multiple data tools and the ability to work semi-independently on moderate to complex BI projects. The Business Intelligence Specialist II demonstrates subject matter expertise in data modeling, report optimization, and stakeholder management, while also providing mentorship to junior team members.

• Design and develop enterprise-level BI reports and dashboards supporting multiple business units using Microsoft technologies.
• Develop complex ETL processes and manage data warehouse objects.
• Create and optimize data models for improved report performance.
• Develop SQL queries to support reporting objectives.
• Lead requirements gathering sessions and translate business needs into technical specifications.
• Perform data quality audits and implement data validation frameworks.
• Optimize BI tool performance and manage system upgrades and migrations.
• Mentor level I Specialists and provide code review and quality assurance.
• Develop and maintain BI documentation and best practices standards.
• Troubleshoot complex technical issues and implement solutions.
• Recommend and implement enhancements to BI infrastructure and tools.

The skills and experience you’ll need:

• Bachelor’s degree in Information Technology, Computer Science, Data Science or related field required.
• 4+ years of experience developing BI reports, dashboards, and data solutions.
• Advanced SQL skills and proficiency with multiple BI tools.
• Experience with ETL tools.
• Proficiency with Azure Data Warehouse or similar platforms.
• Strong understanding of database architecture, data modeling, and SQL optimization.
• Excellent communication skills to translate technical concepts to non-technical stakeholders in written and verbal formats in English.
• Working knowledge of Azure DevOps or a similar platform.
• Strong grasp on data visualization concepts and techniques.
• Project management experience and ability to work on multiple projects concurrently.
• Experience managing stakeholder relationships.
• Experience in manufacturing industry preferred.
• Demonstrated mentoring capacity.
• Microsoft certifications a Plus:
  • PL - 300 (Microsoft Power BI Data Analyst)
  • DP-600 Fabric Analytics Engineer (or equivalent Fabric credential)
• Familiarity with Python.

What we can offer you:

• Full Medical, Dental and Vision coverage with HSA Employer Contributions for eligible plans
• Additional Perks- HQ Onsite Full Gym, Ultramodern Coffee Bars, Free EV Charging Stations, Employee Discounts
• 401k, Profit Sharing, 401k Advisory Services
• Company Sponsored Life Insurance
• Employee Assistance Program
• Paid Time Off, Paid Holidays, Anniversary Holiday

Meissner is proud to be an Equal Opportunity Employer.

US BASE PAY SCALE $47.02- $63.22/hr

The base pay scale for this role is what Meissner reasonably expects to pay for the position although actual pay may vary from this scale depending on an applicant's experience.