Senior Snowflake / Superset Data Engineer Needed for Phase 1 Data Modernization Project

Job Description We are looking for an experienced data engineer / BI modernization consultant to assist with a Phase 1 data modernization implementation for a mid-market company moving from legacy reporting tools into a modern Snowflake-based analytics environment. The project involves building out a Snowflake data foundation, supporting ingestion planning and implementation, helping replace legacy Qlik dashboards and Excel refreshables, and assisting with the setup and development of dashboards in Apache Superset hosted through Preset. This is not a simple dashboard-only role. We need someone who can work across data discovery, source inventory, data modeling, ingestion, dashboard migration, and documentation. The ideal candidate is comfortable working in partially discovered environments where some of the work involves identifying what exists, documenting it clearly, and then helping migrate or replace it. Core Responsibilities The selected contractor will assist with some or all of the following: Data Source Inventory Develop and maintain an itemized inventory of data sources relevant to reporting and analytics, including source name, owner, business function, access method, refresh frequency, downstream dependencies, and recommended ingestion method. Refreshables Inventory and Replacement Inventory Excel refreshables and similar spreadsheet-based reports, including file location, use case, owner, refresh method, dependencies, embedded formulas/macros/Power Query logic, and recommended disposition. Assist with replacing, consolidating, redesigning, or retiring these refreshables as part of the modern reporting environment. Dashboard Inventory and Migration Inventory current dashboards, especially Qlik dashboards, including current purpose, audience, source dependencies, embedded logic, refresh schedule, metrics, required migration work, and final destination. Assist with rebuilding, redesigning, consolidating, or retiring dashboards in Preset/Superset. Snowflake Data Modeling Help design and implement the initial Snowflake database structure and data model, including landing, staging, core, and mart layers where appropriate. Support development of initial fact/dimension structures, reporting marts, canonical definitions, and naming conventions. Data Ingestion Planning and Implementation Help document and implement data import methods by source, including Airbyte, Snowpipe, Snowflake-native loading, file-based ingestion, API-based ingestion, or custom connector approaches. Microsoft Access Replacement Assessment Help identify Access databases or Access-based reporting assets that need to be replaced, retired, rebuilt, or replicated in Snowflake and Superset. Preset / Apache Superset Dashboard Development Assist with configuring Superset / Preset, connecting it to Snowflake, building datasets, creating charts and dashboards, validating outputs, and documenting dashboard logic. Documentation and Knowledge Transfer Create clean, client-ready documentation, including source inventories, dashboard registers, data import method plans, data model notes, known-issues registers, and migration disposition trackers. Required Skills Strong candidates should have experience with: * Snowflake database design and implementation * SQL data modeling for analytics * Building reporting marts or semantic layers * Data ingestion into Snowflake * Airbyte or similar ELT tools * Snowpipe or file-based ingestion patterns * Apache Superset and/or Preset * BI dashboard migration or modernization * Qlik dashboard analysis or migration experience * Excel reporting, Power Query, ODBC connections, macros, or refreshable reporting workflows * Microsoft Access reporting/database analysis * Data documentation and technical inventory creation * Translating business reporting needs into data models and dashboards Nice-to-Have Experience * Epicor Prophet 21 / P21 data experience * ERP reporting migration experience * Finance, sales, operations, inventory, or supply-chain reporting experience * Experience replacing Qlik with Superset, Power BI, Tableau, Looker, or similar tools * Experience working with messy legacy reporting environments * Experience supporting executive reporting or KPI standardization * Git-based analytics development workflows * Data quality testing and reconciliation experience Work Style Required We need someone who is: * Detail-oriented and highly organized * Comfortable documenting unknowns and dependencies * Able to work independently with limited handholding * Strong at asking precise technical questions * Practical and implementation-focused * Able to communicate clearly with both technical and business stakeholders * Comfortable working in an environment where the current-state architecture may be incomplete or poorly documented Expected Deliverables The contractor may contribute to the following deliverables: * Itemized data source inventory * Itemized refreshables inventory * Itemized dashboard inventory * Qlik dashboard migration / disposition register * Access reporting replacement assessment * Snowflake database design notes * Snowflake schemas, tables, views, and reporting marts * Data import method plan * Ingestion pipeline setup or implementation support * Preset/Superset datasets, charts, and dashboards * Dashboard validation and reconciliation notes * Documentation for handoff and knowledge transfer Project Duration and Availability Estimated duration: 8–12 weeks, with potential for follow-on work. Expected availability: approximately 10–25 hours per week, depending on skillset and project phase.