Sr. Analytics Engineer

Basic Function

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.
• Conglomerate 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.
• Solid grounding in data modeling principles (dimensional modeling, normalization/denormalization tradeoffs, slowly changing dimensions).
• 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.
• Able 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.

Benefits

• 401(K) Matching
• Dental Insurance
• Health Insurance
• Paid Time Off
• Vision insurance

Qualifications

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.