Note: The job is a remote job and is open to candidates in USA. W.S. Connelly & Company is seeking a Senior Analytics Engineer to take ownership of data ingestion, modeling, and governance work. The role involves evaluating and implementing a modern data warehouse, managing ETL/ELT pipelines, and establishing data governance frameworks.
Responsibilities
- 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
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
- 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
Benefits
- 401(K) Matching
- Dental Insurance
- Health Insurance
- Paid Time Off
- Vision insurance
Company Overview