123Net Data Engineer
Company: 123NET
Role: Data Engineer
Reports to: EVP, Data Engineering
Organization: Technology, Data, Security, Software & Transformation
Location: Southfield, Michigan or remote within the U.S.
The Organization
Founded in 1995, 123NET is one of Michigan’s leading fiber infrastructure and connectivity providers, delivering fiber internet, data center, colocation, voice, and network solutions to businesses, carriers, municipalities, and residential customers across the state. Headquartered in Southfield, the company operates one of the largest privately owned fiber networks in Michigan.123NET is a portfolio company of Grain Management and is positioned to continue growing with demand for high-speed connectivity while retaining the agility and customer focus of a founder-built company. The culture is entrepreneurial and technical, and people are expected to make decisions, work across teams, and take ownership of outcomes.
The Opportunity
A fiber network is a geographic asset. Every prospect, customer, building, and network element ties back to a location, and the quality of that address data affects some of the company’s most important decisions: where to build, where to sell, what is serviceable today, and what a market is worth. As 123NET grows, better data helps the company prioritize markets, understand customers, improve sales execution, reduce churn, and compete with much larger providers.
123NET is building a modern analytics environment centered on Snowflake as the warehouse and Power BI for reporting. The goal is to create reliable, governed data and a consistent set of metrics that the executive team, accounting, company leadership, and investors can trust. This role will build and maintain the pipelines, models, address and location data, semantic layer, and core dashboards and reports. It is a hands-on role that combines data engineering with applied data science. The work is highly visible and directly supports monthly executive reporting and quarterly sponsor reporting.
What You’ll Do
- Build and operate the data pipelines. Design, build, and maintain reliable pipelines into Snowflake from the company’s operating and financial systems (CRM, ERP, billing, network inventory, call center, and third-party datasets), with data quality checks, validation, and reconciliation built in.
- Own the address and location data. Develop the address master data product, including standardization, deduplication, geocoding accuracy, unit normalization, and serviceability logic, so sales, network planning, and finance are working from the same addressable universe.
- Build and govern reporting. Develop and govern Power BI semantic models, executive dashboards, and functional scorecards. Maintain the metric dictionary, source-to-metric mapping, and dashboard standards so reporting is consistent across the company.
- Partner with accounting and finance. Build the revenue, recurring-revenue, churn, and product reporting the accounting team relies on, and support close-cycle reporting and reconciliation between operating systems and the financial system of record.
- Support investor and board reporting. Automate and maintain the recurring KPI reporting used in monthly executive reviews and quarterly sponsor and board reporting.
- Apply data science to business problems. Build commercial prospect and territory scoring, TAM/SAM and FTTH market models, churn-risk and customer-lifetime-value analytics, and forecasting, and put useful outputs into Power BI and CRM workflows.
- Support the transformation program. Help with critical data mapping and migration as legacy internal systems are replaced with commercial platforms, and help retire duplicate or conflicting legacy reporting along the way.
Required Qualifications
- 4+ years in data engineering, analytics engineering, or data science building production data products.
- Strong, current Snowflake experience, including 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 dashboards built for executive audiences.
- Expert SQL and strong scripting abilities.
- Hands-on experience with address and location data, including address standardization, geocoding, deduplication, spatial joins, and the practical challenges of matching addresses across systems.
- Experience building reporting that a finance or accounting team relied on, such as revenue, recurring revenue, churn, or close-cycle reporting with strong reconciliation discipline.
- Comfort working with imperfect, evolving business data, and the communication skills to explain data issues and insights to non-technical executives.
- Bachelor’s degree in a quantitative field, or equivalent demonstrated capability.
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 building or maintaining KPI packages, board decks, or lender/sponsor reporting and keeping metric definitions consistent under review.
- Strong geospatial experience with tools such as PostGIS, Esri, QGIS, H3, or equivalent, and 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 that were used in production workflows.
- Experience with CRM, billing, call-center, or ERP data (HubSpot, Salesforce, Intermedia, Sage Intacct, Sonar, or similar systems).
The First Year
At the end of the first year, Snowflake should be the trusted analytical source for core metrics and Power BI should be the primary reporting tool. Executive and accounting dashboards should be published, governed, and in regular use; the address master and serviceability logic should be in production; and recurring sponsor reporting should be automated rather than assembled manually.
Location
123NET is headquartered in Southfield, Michigan. Candidates based in or near the market are preferred, but 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.
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
Work Location: Hybrid remote in Southfield, MI 48075
