Data Engineer

Build trusted analytics that leadership and finance can rely on. 123NET is growing its analytics environment with Snowflake as the warehouse and Power BI as the reporting layer. This is a hands-on role focused on designing governed pipelines, creating an address master data product, and delivering the semantic models and dashboards that support monthly executive reporting and quarterly sponsor and board reporting. You will also combine data engineering with applied data science to power commercial scoring, market models, and forecasting.

What you’ll do

• Design, build, and maintain reliable ELT pipelines into Snowflake from operating and financial systems (CRM, ERP, billing, network inventory, call center, and third-party datasets) with data quality checks, validation, and reconciliation built in.
• Develop and govern an address master data product, including standardization, deduplication, geocoding accuracy, unit normalization, and serviceability logic so sales, network planning, and finance work from a consistent addressable universe.
• Build and govern Power BI semantic models, executive dashboards, and functional scorecards, maintaining a metric dictionary, source-to-metric mapping, and dashboard standards for company-wide consistency.
• Create revenue and retention reporting used by accounting, including revenue, recurring revenue, churn, and support close-cycle reporting with reconciliation between operating systems and the financial system of record.
• Automate recurring KPI reporting for monthly executive reviews and quarterly sponsor and board reporting.
• Develop commercial prospect and territory scoring, TAM/SAM and FTTH market models, churn-risk and customer lifetime value analytics, and deliver useful outputs into Power BI and CRM workflows.
• Support critical data mapping and migration as legacy internal systems are replaced, including helping retire duplicate or conflicting legacy reporting.

What you bring

• 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: 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: address standardization, geocoding, deduplication, spatial joins, and matching challenges across systems.
• Experience building reporting relied on by finance or accounting (revenue, recurring revenue, churn, or close-cycle reporting) with strong reconciliation discipline.
• Comfort working with imperfect, evolving business data, plus the communication skills to explain data issues and insights to non-technical executives.
• Bachelor’s degree in a quantitative field (or equivalent demonstrated capability).

Tools you’ll work with

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 and support

• Paid vacation, sick time, and holidays
• 401(k) with Company Match
• Health insurance for you and your family starting day 1
• Dental insurance for you and your family starting day 1
• Vision insurance for you and your family starting day 1

About the organization and culture

123NET was founded in 1995 and is one of Michigan’s leading fiber infrastructure and connectivity providers. Headquartered in Southfield, the company operates one of the largest privately owned fiber networks in Michigan and is a portfolio company of Grain Management. The culture is entrepreneurial and technical, with expectations to make decisions, work across teams, and take ownership of outcomes.

Location and work arrangement

This role is based in 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.

What success looks like in the first year

• Snowflake becomes the trusted analytical source for core metrics, and Power BI becomes the primary reporting tool.
• Executive and accounting dashboards are published, governed, and in regular use.
• The address master and serviceability logic are in production.
• Recurring sponsor reporting is automated rather than manually assembled.