Logo
Motion Recruitment Partners LLC

Software Engineer - Semantic Modeling

Motion Recruitment Partners LLC, Portland, Maine, us, 04122

Save Job

Job Description Our client is seeking a Senior Software Engineer to join the team responsible for building and scaling a Semantic Data Modeling Layer. This is a full-time role focused on transforming raw, domain-ingested data into structured, trusted, and semantically meaningful entities that represent core business concepts. The platform enables analytics, business intelligence, and data-driven decision-making across the organization, leveraging modern cloud data technologies.

This opportunity sits at the center of the company’s data strategy. You’ll play a critical role in creating a single source of truth by consolidating fragmented data sources into unified, governed, and reusable semantic models. The team is looking for an engineer who is passionate about data quality, ownership, and building systems that scale and endure.

Required Skills & Experience

4–8 years of experience as a software engineer or data engineer

Strong programming skills in Python, Java, or another backend language used for data services

Advanced SQL skills and experience modeling large-scale, complex datasets

Solid understanding of engineering fundamentals, including version control, modular design, testing, and performance optimization

Experience working in high-volume or distributed systems environments

Strong sense of ownership and accountability

Desired Skills & Experience

Experience with modern cloud data platforms such as Snowflake, BigQuery, or Databricks

Background in analytics, business intelligence, or metric-driven platforms

Experience partnering closely with product or data teams to translate business requirements into technical solutions

What You Will Be Doing

Design and build modular, reusable semantic definitions for business entities, metrics, and hierarchies

Implement business rules, calculations, and aggregations within the semantic layer

Define and enforce data governance principles to ensure consistent, compliant metric definitions

Develop robust data models that ensure data quality, interoperability, and reliability across the organization

Implement validation, testing, and monitoring to ensure accuracy of semantic models

Partner with data product teams to align semantic models with business needs

Participate in code reviews, design discussions, and incident resolution to promote high engineering standards

Tech Breakdown

45% SQL & Semantic Data Modeling

30% Backend Development (Python / Java)

25% Cloud Data Platforms (Snowflake, BigQuery, Databricks)

Daily Responsibilities

65% Hands-on development and data modeling

20% Cross-functional collaboration (data products, analytics, platform teams)

15% Design reviews, governance, and operational support

The Offer

Bonus eligible

Benefits

Medical Insurance

Dental Benefits

Vision Benefits

Paid Time Off (PTO)

401(k)

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.

#J-18808-Ljbffr