Back to Job Listings

Data Modeler

Contract Freeport, Maine
  • Location: Freeport, Maine
  • Type: Contract
  • Job #20102
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
  1. Design logical, conceptual, and physical data models for EDP’s curated layer in BigQuery.
  2. Develop fact and dimension tables, ensuring adherence to dimensional modeling best practices (Kimball methodology).
  3. Optimize data models for performance, scalability, and query efficiency in a cloud-native environment.
  4. Work closely with data engineers to translate models into efficient BigQuery implementations (partitioning, clustering, materialized views).
2. Data Standardization & Governance
  1. Define and maintain data definitions, relationships, and business rules for curated assets.
  2. Ensure data integrity, consistency, and governance across datasets.
  3. Work with Data Governance teams to align models with enterprise data standards and metadata management policies.
3. Collaboration with Business & Technical Teams
  1. Engage with business analysts and product teams to understand data needs, ensuring models align with business requirements.
  2. Partner with data engineers and architects to implement best practices for data ingestion and transformation.
  3. 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:
  1. 5+ years of experience in data modeling and architecture in cloud data platforms (BigQuery preferred).
  2. Expertise in dimensional modeling (Kimball), data vault, and normalization/denormalization techniques.
  3. Strong SQL skills, with hands-on experience in BigQuery performance tuning (partitioning, clustering, query optimization).
  4. Understanding of retail data models (e.g., sales, inventory, pricing, supply chain, customer analytics).
  5. Experience working with data engineering teams to implement models in ETL/ELT pipelines.
  6. Familiarity with data governance, metadata management, and data cataloging.
  7. Excellent communication skills and ability to translate business needs into structured data models.
  Preferred Qualifications:
  1. Prior experience working in retail or e-commerce data environments.
  2. Exposure to modern data architectures (data lakehouse, event-driven data processing).
  3. Familiarity with GCP ecosystem (Dataflow, Pub/Sub, Cloud Storage) and BigQuery security best practices.
About ProSearch ProSearch, Inc. was established in Portland, Maine, in 1994 to provide companies with a full range of search, staffing and contracting services, specializing in the functional areas of information technology, accounting and finance, sales and marketing, customer service, human resources, and office support utilizing a consultative approach.  Today, ProSearch serves companies across Maine, New Hampshire, and the Greater Boston area, and is expanding to support clients nationwide, with employees at work across the entire country. ProSearch, Inc. strives to develop true partnerships with client companies and candidates to fully understand and satisfy their employment needs.ProSearch is proud to be an affirmative action / equal opportunity employer. All qualified applicants will receive consideration without regard to race, creed, gender, sex, marital status, sexual orientation, citizenship status, color, religion, national origin, age, disability, veteran status, or any other protected status under local, state, or federal law.

Apply to: Data Modeler

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.
Review our Terms of Service for more information.

We are uploading your application. It may take a few moments to read your resume. Please wait!

ProSearch is Maine’s premier staffing and recruiting firm. Our job is to connect great people with great opportunities. Established in 1994, ProSearch helps Maine’s top employers build their teams by recruiting just the right people – from temp/temp-to-hire, to IT consulting, to direct hire- for just the right positions.

ProSearch is proud to be an affirmative action/equal opportunity employer. All qualified applicants will receive consideration without regard to race, creed, gender/sex, marital status, sexual orientation, citizenship status, color, religion, national origin, age, disability, veteran status, or any other status protected under local, state or federal laws.

Let’s get to work! Browse Jobs