Data Modeler

Sparktek

Data Modeler - Enterprise Data Platform (BigQuery, Retail Domain)

Job Summary: We are seeking an experienced Data Modeler to support the Enterprise Data Platform (EDP) initiative, focusing on building and optimizing curated data assets on Google BigQuery. This role requires expertise in data modeling, strong knowledge of retail data, and an ability to collaborate with data engineers, business analysts, and architects to create scalable and high-performing data structures.

Key Responsibilities:

1. Data Modeling & Curated Layer Design

Design logical, conceptual, and physical data models for EDP's curated layer in BigQuery.
Develop fact and dimension tables, ensuring adherence to dimensional modeling best practices (Kimball methodology).
Optimize data models for performance, scalability, and query efficiency in a cloud-native environment.
Work closely with data engineers to translate models into efficient BigQuery implementations (partitioning, clustering, materialized views).

2. Data Standardization & Governance

Define and maintain data definitions, relationships, and business rules for curated assets.
Ensure data integrity, consistency, and governance across datasets.
Work with Data Governance teams to align models with enterprise data standards and metadata management policies.

3. Collaboration with Business & Technical Teams

Engage with business analysts and product teams to understand data needs, ensuring models align with business requirements.
Partner with data engineers and architects to implement best practices for data ingestion and transformation.
Support BI & analytics teams by ensuring curated models are optimized for downstream consumption (e.g., Looker, Tableau, Power BI, AI/ML models, APIs).

Required Qualifications:

5+ years of experience in data modeling and architecture in cloud data platforms (BigQuery preferred).
Expertise in dimensional modeling (Kimball), data vault, and normalization/denormalization techniques.
Strong SQL skills, with hands-on experience in BigQuery performance tuning (partitioning, clustering, query optimization).
Understanding of retail data models (e.g., sales, inventory, pricing, supply chain, customer analytics).
Experience working with data engineering teams to implement models in ETL/ELT pipelines.
Familiarity with data governance, metadata management, and data cataloging.
Excellent communication skills and ability to translate business needs into structured data models.

Preferred Qualifications:

Prior experience working in retail or e-commerce data environments.
Exposure to modern data architectures (data lakehouse, event-driven data processing).
Familiarity with GCP ecosystem (Dataflow, Pub/Sub, Cloud Storage) and BigQuery security best practices.

Apply

Vacancy posted 19 hours ago

Similar jobs that could be interesting for youBased on the Data Modeler in Freeport, ME vacancy

Data Modeler
...Data Modeler – Enterprise Data Platform (BigQuery, Retail Domain) We are seeking an experienced Data Modeler to support the Enterprise Data Platform (EDP) initiative, focusing on building and optimizing curated data assets on Google BigQuery. This role requires expertise...
Suggested
Samprasoft
Freeport, ME
3 days ago
Data Platform Architect
...client, a leader in the retail and consumer sectors, is seeking a Data Platform Architect to join their team. As a Data Platform... ...scalable solutions. Define and promote enterprise standards for data modeling, security, and governance. What's Needed? 8+ years of overall IT...
Suggested
Weekly pay
Temporary work
Remote work
Flexible hours
Experis/Manpower Group
Freeport, ME
1 day ago
Revenue Analyst
...hotel portfolio. Overall Summary of Position This role is responsible for advancing our revenue strategy through precise forecasting, data interpretation, and performance optimization. The Revenue Analyst will play a key role in maximizing room revenue, strengthening...
Suggested
Full time
Work at office
Remote work
Socket
Freeport, ME
4 days ago
Multi-Office Leader
$53.8k - $64k
...Strong communication and problem-solving skills, including handling client escalations and complex issues ~ Ability to interpret data, identify trends, and translate insights into action ~ Ability to climb ladders and lift, carry, and move boxes, supplies,...
Suggested
Minimum wage
Temporary work
Work experience placement
Seasonal work
Work at office
Local area
Night shift
Afternoon shift
H&R Block
Pownal, ME
7 days ago
Data Analyst
DescriptionAre you passionate about transforming raw data into actionable insights? As an Operations Support Data Analyst, you’ll play... ...a new report, advising colleagues, or managing the data model, you’re committed to identifying opportunities for operational growth...
Suggested
Work at office
3 days per week
Tyler Technologies
Yarmouth, ME
1 day ago
Lead / Supervisory Transportation Security Officer - No Experience Required for Entry-Level TSA Careers
$25 - $50 per hour
Role Overview TSA is accepting applications for Lead and Supervisory Transportation Security Officers at airports in Freeport. These roles are ideal for individuals looking to step into leadership positions within airport security operations. TSA provides training to...
Shift work
Night shift
Weekend work
Airport Security Careers
Freeport, ME
more than 2 months ago
Farm Camp Buds Lead Counselor
$17.5 - $19 per hour
...and expectations that help foster an environment of mutual respect, safety, support, and engagement for all campers Act as a role model and support for Junior Counselors and co‑counselor Participate in staff training, weekly staff meetings, and miscellaneous duties that...
Hourly pay
Full time
Contract work
Work experience placement
Summer work
Summer holiday
Seasonal work
Local area
Monday to Friday
Seeds of Peace Camp
Freeport, ME
5 days ago
Lead Supervisor I
$16 - $24.75 per hour
...throughout the organization to promote a fair, positive experience, and an inclusive culture amongst the team. Monitor and analyze sales data, identify trends, and make recommendations to enhance store performance and implement individualized team development to increase...
Minimum wage
Shift work
Tapestry
Freeport, ME
3 days ago
Project Engineer - NE Highway
$47 - $60 per hour
Job Description Job Description At McFarland Johnson (MJ), you?ll own your future . We're a 100% employee-owned firm with 80 years of experience delivering innovative engineering, planning, environmental, technology and construction solutions that make a lasting...
Hourly pay
Work at office
Flexible hours
McFarland Johnson
Freeport, ME
22 days ago
Drainage / Stormwater Engineer
$85k - $120k
...construction plans, specifications, and cost estimates. Use H&H modeling, CAD, and GIS tools to support analysis, design, documentation,... ...investigations, site assessments, drainage evaluations, and data collection efforts. Support local, state, and federal permitting...
Work at office
Local area
Flexible hours
McFarland Johnson
Freeport, ME
22 days ago
Meat/Produce Team Supervisor
$18 - $34 per hour
Hourly Wage: $18 - $34 per/hour *The actual hourly rate will equal or exceed the required minimum wage applicable to the job location. Additional compensation includes annual or quarterly performance incentives. Additional compensation in the form of premiums may...
Hourly pay
Minimum wage
Full time
Temporary work
Part time
Shift work
Walmart
Brunswick, ME
6 hours ago
Meat & Seafood Department Lead
Hannaford Supermarkets in Topsham, ME is seeking a Meat/Seafood Department Lead to guide operations in the absence of managers. You will oversee daily tasks, ensure safety, and maintain product knowledge. The role requires strong communication, customer service, and the...
Hannaford Supermarkets
Topsham, ME
3 days ago
FT Meat Seafood Lead
$21.75 - $31.6 per hour
...variety of substances associated with cleaning materials, packaging materials, and food products. PREFERRED REQUIREMENTS * Role model outstanding, friendly customer service and use skills and knowledge to offer solutions that meet or exceed customer's expectations....
Local area
Hannaford Supermarkets
Topsham, ME
19 hours ago
Assets Protection Team Leader
$22.5 - $24.5 per hour
...and approaches, being authentic and respectful, and creating equitable experiences Lead and demonstrate a safety culture through modeling and recognizing safe behaviors, identifying and correcting hazards in partnership with store leaders, holding team accountable to...
Hourly pay
Full time
Temporary work
Work experience placement
Local area
Flexible hours
Shift work
Night shift
Day shift
Afternoon shift
Early shift
Target
Topsham, ME
19 hours ago
Resident Engineer
$45 - $50 per hour
Overview Colliers Engineering & Design is seeking a Resident Engineer to join our Construction Engineering & Inspection team in Maine! When you join our Construction Engineering & Inspection team, you'll help deliver the infrastructure that keeps communities moving...
Hourly pay
Daily paid
Temporary work
For contractors
Local area
Colliers Engineering & Design
Brunswick, ME
3 days ago
Resident Engineer
$101.6k - $152.4k
TYLin is a globally recognized, full-service infrastructure consulting firm committed to providing innovative, cost-effective, constructible designs for the global infrastructure market. With over 3,000 employees throughout the Americas, Asia, and Europe, the firm provides...
Contract work
For contractors
Work at office
Local area
Remote work
Dar Group
Brunswick, ME
3 days ago
Business Analyst
...State and Federal government environments, exceptional process modeling skills, and a proven ability to lead requirements gathering and... ...business rules, and supporting project documentation. Perform data analysis using Microsoft Excel to identify trends, validate data...
3B Staffing LLC
Brunswick, ME
3 days ago
Engineer
...Infrastructure EngineerII and Trusted Advisor Data Defined, LLC is a leading Managed IT Services provider serving businesses, healthcare organizations, nonprofits, and public sector clients throughout Maine and Northern New England. Since 1998, we have helped organizations...
Full time
Temporary work
Casual work
Work at office
Local area
Exceptional Dental
Brunswick, ME
2 days ago
Senior Identity Engineer
DescriptionResponsibilitiesServe as the technical owner and subject matter expert for Okta (Workforce Identity + Identity Governance), Microsoft Entra ID, and Active Directory.Architect and operate the UKG Okta AD identity lifecycle pipeline, including UKG Pro connector...
For contractors
Tyler Technologies
Yarmouth, ME
2 days ago
Lead Mitigation Technician
When a basement floods at 2 a.m. or a fire leaves a family unsure where to start, someone has to step in immediately — and lead the way. That someone is you. LEAD MITIGATION TECHNICIAN (Crew Chief Level) Insurcomm Restoration | Fortify Companies Field-Based | Full-Time...
Full time
Local area
Immediate start
Fortify Companies
Topsham, ME
4 days ago
Lead Licensed Veterinary Technician
$27 - $30 per hour
Lead Licensed Veterinary Technician We invite you to join the highly respected team at Bath-Brunswick Veterinary Associates in beautiful Brunswick, ME. This is a clinic where your professional contributions are genuinely valued and exceptional patient care is the central...
Hourly pay
Local area
Relocation package
Mission Pet Health
Brunswick, ME
1 day ago
Electrical Engineering Intern
Electrical Engineering Intern Dashiell, an operating unit of Quanta Services (trading as PWR), is a leading national provider of technical and construction services supporting critical electric infrastructure. We serve electric utilities, power generation, industrial...
Permanent employment
Temporary work
Work experience placement
Internship
Work at office
Immediate start
Visa sponsorship
Dashiell
New Gloucester, ME
4 days ago
Lead / Supervisory Transportation Security Officer - No Experience Required for Entry-Level TSA Careers
$25 - $50 per hour
Role Overview TSA is accepting applications for Lead and Supervisory Transportation Security Officers at airports in Cumberland Center. These roles are ideal for individuals looking to step into leadership positions within airport security operations. TSA provides training...
Shift work
Night shift
Weekend work
Airport Security Careers
Cumberland Center, ME
more than 2 months ago
Electrical Engineering Internship
Electrical Engineering Intern Wright-Pierce, an award-winning, multi-discipline environmental engineering firm specializing in water, wastewater and civil infrastructure, is seeking an Electrical Engineering Intern to join our company for the Summer of 2027. The position...
For contractors
Summer work
Internship
H1b
Work at office
Local area
Wright-Pierce
Topsham, ME
2 days ago
Mechanical Design Engineer
...environment. Responsibilities & Duties: Design parts & equipment to meet customer specifications and requirements. Generate 3D models, drawing packages, bills of materials and O&M Manuals. Perform necessary engineering calculations to validate or improve designs...
Vantage Point Recruiting
New Gloucester, ME
1 day ago
Restaurant Assistant Manager — Growth, Team Leader
Ontario Trillium Foundation is seeking an Assistant Manager to oversee the restaurant's daily operations in Freeport, Maine. You will drive sales and profitability while fostering a positive team environment. Responsibilities include managing a team, ensuring exceptional...
Ontario Trillium Foundation
Freeport, ME
2 days ago
Sr. / Principal Quality Engineer
$83.6k - $132.3k
.../processes are safely executed. Communicate safety concerns and model safe behaviors. Project Execution:Utilize BIW’s business operating... ...lab audits as well as others.Collect and review quality data for trends, patterns, anomalies and make recommendations for corrective...
Apprenticeship
Flexible hours
General Dynamics - Bath Iron Works
Brunswick, ME
1 day ago
Sr. / Principal Electrical Engineer
$88.1k - $142k
...specification development, and management of budget and schedule.Perform modeling, simulation, and calculations to validate designs and ensure... ...is preferred, including network communication and protocols and data collection.Experience working on power systems and power system...
Contract work
For subcontractor
Interim role
Work at office
Flexible hours
General Dynamics - Bath Iron Works
Brunswick, ME
1 day ago
Lead Teller
...to detail. ~ Excellent mathematical skills. ~ Competence with computers and other office machinery. ~ Proficient alpha/numeric data entry skills. ~ Excellent customer service skills, attentiveness, information retention, tact and diplomacy in dealing with both...
Work at office
Local area
Night shift
Northeast Bancorp
Brunswick, ME
2 days ago
Community Program Manager
...collaborative team member. Strong attention to detail and the ability to maintain accurate records. The ability to collect, understand, and use data to evaluate program outcomes. Experience preparing written reports and maintaining documentation. Proficiency with Microsoft Office...
Work at office
Local area
Remote work
Flexible hours
Weekend work
Afternoon shift
Big Brothers Big Sisters of Bath/Brunswick
Brunswick, ME
4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Modeler. Be the first to apply!