Sr. Analytics Engineer

W.S. Connelly & Company; Virginia (MN); On-site; USD 110,000 - 160,000; Full time

Job summary

W.S. Connelly & Co., LLC is seeking a Senior Analytics Engineer to take ownership of data ingestion, modeling, and governance, consolidating work previously distributed among an MSP and external consultants.

The role starts by partnering with an interim analytics resource and transitions to full ownership as the backfill completes. You will evaluate platforms, design a modern data warehouse architecture, enforce data modeling standards, and build a governance framework to ensure trustworthy

Qualifications

• 5+ years of experience in data/analytics engineering with hands-on design/build of data warehouses or lakehouses on modern platforms (e.g., Microsoft Fabric, Snowflake, Azure Synapse, Databricks).
• Strong ETL/ELT development experience across multiple source systems, including ERP platforms.
• Demonstrated experience implementing data governance: data quality, access control, documentation, and lineage.
• Strong Power BI development skills (data modeling, DAX, report/dashboard design) to set enterprise standards.
• Experience transitioning outsourced or MSP-managed infrastructure in-house and/or transitioning knowledge during a handover.

Responsibilities

• Evaluate and recommend a modern data warehouse/lakehouse platform and design/maintain architecture.
• Own end-to-end ETL/ELT pipelines from source systems into a governed warehouse.
• Establish and enforce data modeling standards (dimensional/star schema) across the environment.
• Build and maintain a data governance framework with definitions, naming conventions, quality rules, access controls, and lineage.
• Consolidate reporting onto Power BI as the company standard and sunset legacy reporting tools.
• Manage data access and security models within the new architecture, with auditable controls.
• Collaborate with interim resources during transition to absorb existing logic and datasets, then assume full ownership.
• Partner with Power BI consultants and stakeholders to translate reporting needs into governed, reusable data models.
• Support integration of newly acquired entities into the unified data architecture as part of expansion.
• Document data architecture, pipelines, and governance policies to support audit readiness.

Skills

Data warehousing / lakehouses

ETL/ELT development

Data governance

Power BI development

MS Fabric / Snowflake / Azure Synapse

ERP / source systems integration

Multi-entity / multi-ERP experience

Stakeholder collaboration

Tools

Microsoft Fabric

Snowflake

Azure Synapse

Databricks

Sage 100

Acumatica

Job description

The Senior Analytics Engineer will take direct ownership of data ingestion, modeling, and governance work that is currently outsourced or distributed across an MSP, a project-based BI consultant, and prior internal contributors whose work was never unified under one owner. The role will begin by working closely alongside the interim PE-firm analytics resource to ensure continuity, then transition fully into ownership of the function as the backfill is completed.

Job Duties

• Evaluate and recommend a modern data warehouse/lakehouse platform (e.g., Microsoft Fabric, Snowflake, Azure Synapse, Databricks, or similar), then design, build, and maintain that architecture, replacing the current reliance on external MSP‑managed infrastructure.
• Own end‑to‑end ETL/ELT pipelines from source systems (Sage 100, Acumatica, Quick Books and other entity‑level ERPs, plus ancillary systems) into a governed warehouse.
• Establish and enforce data modeling standards (e.g., dimensional/star schema design) to replace inconsistent, duplicated, and conflicting table structures inherited from multiple prior contributors.
• Build and maintain a data governance framework: definitions, naming conventions, data quality rules, access controls, and lineage documentation, so that metrics are consistent and trustworthy across business units.
• Consolidate reporting onto Power BI as the company standard, sunsetting redundant report servers, shadow tools, and one‑off Excel/Access‑based reporting.
• Manage data access and security models within the new architecture, replacing ad hoc or MSP‑controlled access provisioning with a structured, auditable approach.
• Work alongside the interim PE‑firm analytics resource during the transition period to absorb existing reporting logic, data definitions, and stakeholder context, then assume full ownership of the function.
• Partner with a project‑based Power BI consultant and business stakeholders to translate reporting needs into governed, reusable data models rather than one‑off reports.
• Support integration of newly acquired entities into the unified data architecture as part of the company’s ongoing acquisition strategy.
• Document data architecture, pipelines, and governance policies to support audit readiness and reduce key‑person dependency.

Required Skills

• 5+ years of experience in data/analytics engineering, with direct, hands‑on experience designing and building data warehouses or lakehouses on one or more modern platforms (e.g., Microsoft Fabric, Snowflake, Azure Synapse, Databricks, or similar).
• Strong ETL/ELT development experience — building and maintaining pipelines from multiple source systems, including ERP platforms.
• Demonstrated experience implementing data governance practices: data quality, access control, documentation, and lineage.
• Strong Power BI development skills (data modeling, DAX, report/dashboard design) sufficient to set enterprise standards, not just build individual reports.
• Experience working with or migrating away from MSP‑managed infrastructure or otherwise transitioning outsourced technical functions in-house.
• Comfortable working in a multi‑entity, multi‑ERP environment with inconsistent legacy data (duplicate records, inconsistent coding structures, etc.).
• Strong collaboration skills and the ability to work effectively alongside an interim/transitional resource during a knowledge‑transfer period.
• Ability to objectively evaluate competing data platform options against the company’s scale, budget, and multi‑entity/multi‑ERP complexity, and make a clear, well‑reasoned recommendation.

W.S. Connelly & Co., LLC (WSC) is an Equal Opportunity Employer. WSC does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non‑disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.