Data Engineer

Build trusted data and reporting that leadership can act on. As a Data Engineer at 123NET, you will help create a modern analytics environment built around Snowflake for the analytical foundation and Power BI for governed reporting. This hands-on role combines data engineering with applied data science to support executive visibility, accounting close-cycle needs, and investor-ready metrics. The work is highly visible and directly tied to monthly executive reporting and quarterly sponsor updates.

What you’ll do

• Design, build, and maintain reliable 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 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 use a consistent addressable universe.
• Create and maintain Power BI semantic models, executive dashboards, and functional scorecards. Maintain the metric dictionary, source-to-metric mapping, and dashboard standards to support company-wide consistency.
• Build revenue and recurring revenue reporting used by accounting, including churn and product reporting, and support close-cycle reporting with reconciliation between operating systems and the financial system of record.
• Automate recurring KPI reporting used in 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 forecasting. Publish outputs into Power BI and CRM workflows.
• Support critical data mapping and migration as legacy internal systems are replaced with commercial platforms, and help 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: standardization, geocoding, deduplication, spatial joins, and practical cross-system matching challenges.
• Experience building finance or accounting-dependent reporting (for example: 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).

Technologies 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) - 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

First-year outcomes

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

About 123NET

Founded in 1995, 123NET is one of Michigan’s leading fiber infrastructure and connectivity providers, headquartered in Southfield, operating one of the largest privately owned fiber networks in Michigan. The organization is a portfolio company of Grain Management and maintains an entrepreneurial, technical culture where people are expected to make decisions, work across teams, and take ownership of outcomes.

Location and work model

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.