POSITION OVERVIEW

We are seeking an experienced Lead Analytics Engineer with 10+ years in Data Engineering & Analytics to lead the design, development, and support of Snowflake-based data solutions with Power BI expertise. This role requires a hands-on leader who can work directly with clients on-site, manage day-to-day technical needs, and ensure that scalable, high-performance data and analytics solutions are delivered.
The ideal candidate will be equally comfortable with Snowflake development, Power BI reporting, solution design, stakeholder interaction, and mentoring junior resources.

REQUIRED SKILLS & QUALIFICATIONS

• 10+ years of experience in Data Engineering & Analytics, with 3+ years in Snowflake development & optimization.
• Strong hands-on expertise in Snowflake architecture, SQL, and stored procedures.
• Proven success in end-to-end data pipeline design and ETL/ELT implementation.
• Deep understanding of data modeling techniques (dimensional, OLAP, relational).
• Strong experience in Power BI dashboarding & enterprise productionalization.
• Proven track record of working directly with clients to gather requirements and deliver scalable solutions.
• Excellent problem-solving, stakeholder management, and communication skills.

PREFERRED QUALIFICATIONS

• Experience with Python development (transformations, automation, APIs).
• Exposure to web development concepts for embedding analytics.
• Experience with Azure deployment & integration with Snowflake/Power BI.
• Familiarity with CI/CD, DevOps, and Git-based workflows.
• Certifications: SnowPro Core/Advanced Architect and/or Microsoft Power BI Data Analyst.
• Experience with other BI tools (Tableau, Looker, Qlik) is an asset.

EDUCATION & EXPERIENCE

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
• 10+ years of Data Warehousing/Engineering experience, including client-facing leadership responsibilities.
  Job Type: Full-time
  Pay: $95,000.00-$105,000.00 per year

Experience:

• Analytics: 7 years (preferred)

Work Location: In person
Expected start date: 2025-09-0

Requirements & Solutioning

• Partner directly with business stakeholders & clients to gather requirements, refine solutions, and translate them into technical deliverables.
• Curate and evolve enterprise data models to support scalable reporting and analytics.
• Ensure solutions are aligned with business objectives and can scale for future needs

Requirements & Solutioning

• Partner directly with business stakeholders & clients to gather requirements, refine solutions, and translate them into technical deliverables.
• Curate and evolve enterprise data models to support scalable reporting and analytics.
• Ensure solutions are aligned with business objectives and can scale for future needs.

Snowflake Design & Architecture

• Architect and develop scalable Snowflake solutions, applying best practices for data modeling and optimization.
• Lead design of data warehousing structures (star, snowflake, data vault, normalized).
• Oversee compute and storage optimization to balance performance with cost efficiency.

Data Development & Integration

• Build and manage robust ETL/ELT pipelines using dbt, Python, Talend, Matillion, or custom SQL.
• Integrate Snowflake with various structured/unstructured sources (cloud services, APIs, on-prem systems).
• Implement data ingestion strategies for both batch and real-time processing.

Performance Tuning & Optimization

• Develop and optimize complex SQL queries, procedures, and transformations.
• Monitor and fine-tune Snowflake virtual warehouses, caching, and clustering strategies.
• Proactively identify and resolve bottlenecks in performance and data delivery.

Power BI Development & Productionalization

• Lead the design, development, and deployment of Power BI dashboards and datasets connected to Snowflake.
• Implement row-level security, refresh scheduling, and workspace governance.
• Drive enterprise adoption of Power BI dashboards through scalable productionization.

Data Governance & Security

• Establish and enforce role-based access controls, data privacy, and compliance frameworks.
• Support data quality and validation frameworks with automation where possible.
• Ensure regulatory compliance for sensitive and financial data.

Collaboration, Leadership & Client Engagement

• Act as the primary technical lead on-site, managing client expectations and daily technical needs.
• Provide mentorship and technical oversight to data engineers, BI developers, and analysts.
• Serve as the bridge between business stakeholders and technical teams, ensuring delivery of business-ready analytics.
• Promote best practices for Snowflake–Power BI integration (DirectQuery, Import, Hybrid).