Analytics Engineer Level II

Join Our Team!

The Analytics Engineer II independently designs, develops, and supports enterprise BI solutions. This role is responsible for designing, developing, and maintaining analytics pipelines and data marts that deliver trusted, high-quality data to support BI dashboards, reporting environments, and data-informed business decisions.

BI Development

• Develop and maintain workflows by building dimensional models that support data mart(s) for dashboards, reports, and other visualizations.
• Optimize visualizations for usability and performance.
• Use advanced features in Qlik and MS SQL for BI.

Data Analysis

• Analyze trends, KPIs, and business drivers.
• Conduct deep-dive analysis for operational and strategic needs.

Data Integration

• Develop ETL processes integrating APIs, databases, and flat files.
• Collaborate with Data Engineers on data pipelines.

Data Quality & Governance

• Enforce data quality controls and validation routines.
• Maintain consistent business definitions and reporting logic.

Performance Optimization

• Tune SQL queries, dashboards, and reporting performance.
• Identify bottlenecks and implement improvements.

Collaboration

• Gather requirements directly from stakeholders.
• Train users on dashboards and self-service analytics.

Qualifications

Education

• Bachelor’s degree required; Master’s preferred.

Technical Skills

• Strong SQL and data warehousing knowledge.
• 4+ years with BI tools and ETL platforms.
• Experience with Azure data services.
• Knowledge of star/snowflake schemas, OLAP.
• Python, R, or DAX experience preferred.

Soft Skills

• Strong analytical and communication skills.
• Ability to manage multiple priorities.

Our Mission is: “We make everyday celebrations better while enriching the lives of team members and by contributing to organizations that benefit families in the communities we serve.”

Come join this family-owned, growth-oriented organization today!

• PAID VACATION AND PTO
• TUITION REIMBURSEMENT
• ABC UNIVERSITY - GREAT WINE, SPIRITS, BEER, CIGAR TRAINING
• EXCELLENT WELLNESS-BASED HEALTH INSURANCE FOR INDIVIDUAL + FAMILY
• DENTAL AND VISION PLANS
• COMPANY-MATCH 401K PROGRAM
• EMPLOYEE DISCOUNTS ON WINE AND SPIRITS
• EMPLOYEE ASSISTANCE PROGRAM (EAP)
• PET INSURANCE

Equal employment opportunity ABC is an equal-opportunity employer and is committed to providing a workplace free from harassment and discrimination. We are committed to recruiting, hiring, training and promoting qualified people of all backgrounds, and we make all employment decisions without regard to race, ethnicity, color, age, sex, gender, gender identity or gender expression, sexual orientation, religion, creed, marital status, pregnancy, national origin/ancestry, citizenship, physical/mental disability, genetic information, medical condition, military status, or any other basis prohibited by law (“protected status”).

ABC is an alcohol-free, drug-free workplace.

#AlwaysBeCelebrating