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 2 days ago

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

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... ...solutions. Define and promote enterprise standards for data modeling, security, and governance. What's Needed? ~8+ years of overall...
Suggested
Weekly pay
Temporary work
Remote work
Flexible hours
Manpower Group Inc.
Freeport, ME
3 days ago
Supply Chain OCM Lead
$89k - $111.2k
...a safe manner. Those in a leadership role are also expected to model safe behaviors, evaluate risk, and ensure that risks are reduced... ...formatsAbility to define success measures, track adoption, and use data to adjust and improve outcomesProven ability to work across...
Suggested
Full time
Work at office
L.L.Bean
Freeport, ME
1 day ago
Material Handling Specialist
$20 per hour
Adecco is assisting our client in Freeport, ME , seeking Warehouse Associate/ Material Handler's for 1st shift See position details below! Schedule / Shifts / Pay Rates: 1st Shift - Monday - Friday & Sunday- 7:00AM - 3:30PM - $20/HR Entry Level Roles...
Suggested
Hourly pay
Full time
Temporary work
Part time
Work at office
Local area
Monday to Friday
Flexible hours
Shift work
Day shift
Adecco
Freeport, ME
5 days ago
Lead / Supervisory Transportation Security Officer - No Experience Required forEntry-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...
Suggested
Shift work
Night shift
Weekend work
Airport Security Careers
Freeport, ME
13 days ago
Lead Pastor
$50k
We are a Christ-centered, Bible-believing, Bible-teaching church in Pownal, Maine. Pownal is a growing bedroom community to Portland. We are the only church in our town. We want to reach Pownal and beyond with the Gospel of Jesus Christ. We are conservative in doctrine...
Suggested
Full time
Live out
Local area
Day shift
Pownal, ME
27 days ago
Territory Field Lead
$50k - $56k
...collaboration. Our mission is to empower businesses to achieve new heights in sales and customer engagement through cutting-edge technology and data-driven strategies. With us, you'll join a vibrant community where your ideas matter, your growth is encouraged, and every day brings...
Local area
The Revenue Optimization Companies (T-ROC)
Bustins Island, ME
1 day 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
1 day 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
14 hours ago
Lead Licensed Veterinary Technician
$27 - $30 per hour
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 mission. We are proud to be AAHA Accredited...
Hourly pay
Private practice
Local area
Relocation package
Monday to Friday
Bath-Brunswick Veterinary Associates, Inc.
Brunswick, ME
14 hours ago
Supervisory Team Lead - Recruiting
...Effective championship of change and achievement of process improvements with a natural ability to drive multiple projects simultaneously through influence and relationshipsHighly organized, with a detail orientedAbility to analize data, set clear goals, and measure outcomes
Tyler Technologies
Yarmouth, ME
4 days ago
Business Analyst
Overview We are seeking a full-time Business Analyst at Garmin's location in Yarmouth, ME. This role requires you to currently live in ME. No relocation available. In this role, you will be responsible for gathering, documenting and effectively communicating user requirements...
Full time
Live in
Relocation
Garmin
Yarmouth, ME
3 days ago
Shift Lead
...Completes product returns, order voids, customer refunds, cash drops to the safe, and provides change as requested to cash registers. Models and delivers a distinctive and delightful customer experience. Customer Experience Engages customers and patients by...
Work experience placement
Seasonal work
Local area
Shift work
Walgreens Boots Alliance
Yarmouth, ME
2 days ago
Shipping & Receiving Lead
$20 - $25 per hour
Adecco is recruiting for a Shipping & Receiving Lead in Mechanic Falls, ME. This role is ideal for an experienced warehouse professional with shipping, receiving, and forklift experience who enjoys leading a team and supporting daily operations. Weekly Pay! Pay: ...
Hourly pay
Weekly pay
Temporary work
Local area
Adecco USA
New Gloucester, ME
5 days ago
Team Captain Endzone & Loyalty (Front End)
$49.5k - $63.5k
Join Our Team at DICK'S Sporting Goods At DICK'S Sporting Goods, we believe in how positively sports can change lives. On our team, everyone plays a critical role in creating confidence and excitement by personally equipping all athletes to achieve their dreams. We ...
DICK'S SPORTING GOODS INC
Topsham, ME
3 days ago
Team Leader
Burger King® Team Leader Bring the flavor. Bring the fire. Ignite the passion. Welcome to the Flame-Grilled Life At Burger King®, we keep it real - real food, real fire, real people. As a Team Leader, you'll set the gold standard for delivering exceptional guest...
Hourly pay
Weekly pay
Minimum wage
Local area
Flexible hours
Shift work
Burger King
Brunswick, ME
2 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
Yarmouth, ME
2 days ago
Sr. Sales Operations Analyst
$90.26k - $125k
...Sr. Sales Operations Analyst Apply Online A Sr. Sales Operations Analyst collects, cleans, and interprets complex sales data to identify trends, enhance performance, and drive revenue growth. They create actionable reports, build dashboards, and support forecasting...
Work at office
Local area
Remote work
Tyler Technologies
Yarmouth, ME
3 days 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
2 days ago
Configuration and Logistics Data Analyst I, II, III, Engineering
...Responsibilities for this Position Configuration and Logistics Data Analyst I, II, III, Engineering US-ME-Brunswick Req ID: 2... ...(BOS), daily work is predominantly conducted in the Navys Model Based Product Support (MBPS) cloud platform which is the new Program...
Full time
Apprenticeship
Interim role
Work at office
Shift work
Bath Iron Works
Brunswick, ME
2 days ago
Lead Mitigation Technician
$23 - $26 per hour
$1,500 SIGN-ON BONUS 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...
Hourly pay
Full time
Local area
Immediate start
Relocation package
Insurcomm Restoration
Topsham, ME
1 day ago
Echo Technologist
Echo Technologist Job Type: Travel Profession: Allied Specialty: Echo Technologist Shift Details: Shift Day - 8 hours Job Order Details: Start Date 08/24/2026 End Date 11/23/2026 Duration 13 Week(s) Client Details: City Brunswick State ME
Shift work
MaineHealth
Brunswick, ME
1 day ago
Echo Technologist
Echo Technician MedPro Healthcare Staffing, a Joint Commission-certified staffing agency, is seeking a quality Echo Technician for a contract with one of our top healthcare clients. Requirements Successful completion of an accredited training course in cardiac...
Weekly pay
Contract work
MedPro Healthcare Staffing
Brunswick, ME
3 days 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
1 day ago
Systems Engineer
...management information systems, or equivalent industry experience. 5–7 years of experience as a system engineer in an enterprise or data center setting. Experience with on‑premises hosting platforms (vSphere/Hyper‑V), storage (NetApp) and backup. Proficiency with code,...
Local area
Flexible hours
STACK Infrastructure US
Lisbon Falls, ME
1 day ago
Lead / Supervisory Transportation Security Officer - No Experience Required forEntry-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
13 days 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! In...
Hourly pay
Daily paid
Temporary work
For contractors
Local area
Colliers Engineering & Design
Brunswick, ME
2 days ago
Team Leader, Night Crew
Night Team Leader Our Night Team Leaders are key players in managing the Overnight Team. These departments can include Center Store, Prepared Foods, Produce, Bakery, and Meat. In addition to providing unparalleled guest service, you'll be the one we look to stay on ...
Work experience placement
Night shift
Giant Eagle
Brunswick, ME
3 hours ago
Lead Merchandiser
$48.5k - $58.5k
Are you ready to take your merchandising skills to the next level? At Viking Coca-Cola in River Falls, WI, our Full-Time Lead Merchandiser position offers a thrilling opportunity to shape the in-store experience for customers while leading a vibrant team. Embrace an energizing...
Full time
Flexible hours
Viking Coca-Cola
Lisbon Falls, ME
15 hours ago
Lead Licensed Veterinary Technician
Bath-Brunswick Veterinary Associates, Inc., a small animal hospital serving Midcoast Maine, is seeking a Lead Licensed Veterinary Technician. In this on-site role, you will provide advanced nursing care, anesthesia monitoring, dentistry, radiology, and diagnostics while...
Bath-Brunswick Veterinary Associates, Inc.
Brunswick, ME
4 days ago
Quality Assurance Analyst
..., create, and implement custom reports that effectively present data in a clear and actionable manner. In this role, you’ll collaborate... ...professional consultations to analyze client business models, identify technical requirements, and facilitate comprehensive knowledge...
Contract work
Temporary work
Summer work
Internship
Work at office
Local area
Tyler Technologies
Yarmouth, ME
4 days ago

Do you want to receive more vacancies?

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