Data Engineer

Build a modern analytics environment that leaders and stakeholders can trust. 123NET is a Michigan-based fiber infrastructure and connectivity provider, founded in 1995 and headquartered in Southfield. In this hybrid role, you will help establish a Snowflake-centered, governed data foundation and a Power BI reporting layer used for executive, accounting, and investor-facing metrics. The work is hands-on and highly visible, with direct support for monthly executive reporting and quarterly sponsor reporting. What you’ll be building includes reliable pipelines into Snowflake, governed reporting with consistent metrics, address and location master data that standardizes how the business thinks about customers and serviceability, and analytics that support commercial scoring, market models, churn-risk, customer lifetime value, and forecasting. This position also includes applied data science work integrated into production workflows. Responsibilities Design, build, and maintain pipelines into Snowflake from operating and financial systems including CRM, ERP, billing, network inventory, call center, and third-party datasets, with data quality checks, validation, and reconciliation. Develop and govern an address master data product: standardization, deduplication, geocoding accuracy, unit normalization, and serviceability logic to support sales, network planning, and finance. Develop and govern Power BI semantic models , executive dashboards, and functional scorecards, including maintaining the metric dictionary, source-to-metric mapping, and dashboard standards for company-wide consistency. Build revenue , recurring revenue, churn, and product reporting for accounting, and support close-cycle reporting with reconciliation between operating systems and the system of record. Automate recurring KPI reporting used in monthly executive reviews and quarterly sponsor and board reporting. Create commercial prospect and territory scoring, TAM/SAM and FTTH market models, churn-risk and CLV analytics, and forecasting, and deliver usable outputs into Power BI and CRM workflows . Support critical data mapping and migration as legacy internal systems are replaced with commercial platforms, helping retire duplicate or conflicting legacy reporting. Requirements 4+ years in data engineering, analytics engineering, or data science building production data products. Strong, current Snowflake experience: warehouse and data-mart design, dimensional modeling, performance and cost management, and ELT pipeline development. Strong Power BI experience including semantic model design, DAX , governed workspaces and datasets, row-level security , and executive-facing dashboards. Expert SQL and strong scripting abilities. Hands-on experience with address and location data , including standardization, geocoding, deduplication, spatial joins, and challenges of matching addresses across systems. Experience building finance or accounting reporting such as revenue, recurring revenue, churn, or close-cycle reporting with strong reconciliation discipline. Comfort working with imperfect, evolving business data, plus communication skills to explain data issues and insights to non-technical executives. Bachelor’s degree in a quantitative field (or equivalent demonstrated capability). Technologies Snowflake , Power BI , DAX, SQL, PostGIS, Esri, QGIS, H3, dbt, Fivetran, Airflow, Git, HubSpot, Salesforce, Intermedia, Sage Intacct, Sonar, ELT, CRM, ERP, OSS/BSS, Power BI semantic models, row-level security Benefits Paid vacation, sick time, and holidays 401(k) - Savings plan with Company Match Health insurance - For you and your family on day 1 of employment Dental insurance - For you and your family on day 1 of employment Vision insurance - For you and your family on day 1 of employment Organization & Culture 123NET is part of a Grain Management portfolio company. The organization has an entrepreneurial and technical culture where people are expected to make decisions, work across teams, and take ownership of outcomes . First-Year Outcomes At the end of the first year, Snowflake should be the trusted analytical source for core metrics and Power BI the primary reporting tool. Executive and accounting dashboards should be published, governed, and regularly used. The address master and serviceability logic should be in production. Recurring sponsor reporting should be automated rather than assembled manually. Location Southfield, MI (hybrid). Candidates based in or near the market are preferred. The company is also open to a remote arrangement for candidates based in the U.S., with periodic travel to Southfield for planning and time with the team. Preferred Qualifications Experience in telecommunications, broadband, fiber, or another subscription-infrastructure business, especially with OSS/BSS data, network inventory, serviceability, or market-expansion analytics. Experience in a private-equity-backed company, including maintaining metric definitions and building KPI packages, board decks, or lender/sponsor reporting. Strong geospatial experience with tools such as PostGIS , Esri, QGIS, H3, or equivalent, and familiarity with parcel, census, and demographic data. Experience with modern data-stack tools such as dbt, Fivetran, Airflow, Git-based workflows, and data quality frameworks. Applied machine learning experience with propensity, churn, CLV, segmentation, or forecasting models used in production workflows. Experience with CRM, billing, call-center, or ERP data including HubSpot, Salesforce, Intermedia, Sage Intacct, Sonar, or similar systems. #J-18808-Ljbffr