Apply Now

Data Modeler / Data Architect

• Posted 18 hours ago • Updated 16 hours ago

Contract W2

Contract Corp To Corp

Contract Independent

CCS Global Tech

Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Analytics
Collaboration
Data Security
Data Modeling
SQL
Dimensional Modeling
Data Warehouse
Data Quality
Reporting
Communication
Stakeholder Management
Modeling
PeopleSoft
HR Management
FSCM
ELM
Enterprise Resource Planning
Finance
Learning Management
Analytical Skill
Data Marts
Semantics
Data Engineering
ELT
Testing
Documentation
Snow Flake Schema
Access Control
Microsoft Power BI
Data Governance
Public Sector
Data Architecture
Oracle Linux

UI
Information Technology
Network
Microsoft
Tier 1
Cloud Computing
Recruiting
Training
Partnership
Analytics
Collaboration
Data Security
Data Modeling
SQL
Dimensional Modeling
Data Warehouse
Data Quality
Reporting
Communication
Stakeholder Management
Modeling
PeopleSoft
HR Management
FSCM
ELM
Enterprise Resource Planning
Finance
Learning Management
Analytical Skill
Data Marts
Semantics
Data Engineering
ELT
Testing
Documentation
Snow Flake Schema
Access Control
Microsoft Power BI
Data Governance
Public Sector
Data Architecture
Oracle Linux

Summary

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.

we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.

We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.

If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Key Responsibilities:

Review and assess the existing PeopleSoft data model and modeling progress in Snowflake.

Identify modeling gaps, data-quality concerns, architectural risks, and improvement opportunities.

Design or refine scalable data marts using facts, dimensions, relationships, hierarchies, keys, and appropriate data grain.

Develop conceptual, logical, and physical data models supporting HCM, FSCM, and ELM analytics.

Recommend a target-state architecture optimized for Snowflake and future Power BI reporting.

Document data models, business definitions, source-to-target mappings, risks, dependencies, and implementation recommendations.

Collaborate with Controller's Office, DataSF, technical, and business stakeholders to validate proposed model.

Provide architectural guidance for the future citywide data-security model.

If authorized, assist with initial Snowflake data-engineering and transformation activities.

Required Qualifications and Experience

Strong hands-on experience (preferably 8+ years) designing enterprise analytical data models and data marts.

Strong Snowflake data-modeling, data-architecture, and SQL experience (5+ years).

Advanced dimensional-modeling expertise (5+ years), including facts, dimensions, star schemas, grain, keys, hierarchies, relationships, and historical data.

Demonstrated experience (3+ years) assessing existing or partially completed data models and recommending scalable target-state designs.

Experience (3+ years) developing conceptual, logical, and physical data models, data dictionaries, and source-to-target mappings.

Strong understanding (5+ years) of data warehousing, semantic modeling, data lineage, data quality, and performance considerations.

Ability (5+ years) to translate complex business and reporting requirements into implementable technical designs.

Strong communication and stakeholder-management skills (3+ years), with the ability to work independently during a short-term engagement.

Preferred Qualifications and Experience

Experience modeling PeopleSoft data, particularly HCM, FSCM, or ELM.

Experience converting complex ERP, HR, financial, or learning-management data into analytical data marts.

Familiarity with designing Snowflake data marts and semantic models for Power BI.

Hands-on Snowflake data-engineering and ELT implementation experience.

Working knowledge of dbt, including transformations, testing, documentation, and lineage.

Experience with Snowflake role-based access control, Power BI security, data governance, and sensitive-data handling.

Public-sector or large, federated-enterprise data-architecture experience.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10290999
Position Id: 2026-7675
Posted 18 hours ago

Company Info

About CCS Global Tech

Headquartered in Poway, California and eight international offices, CCS Global Tech is a Certified Minority Business Enterprise (MBE) and a leading provider of enterprise solutions. We provide solutions that cover the full business spectrum from application development, data warehouse software, real time data warehousing, business analysis software, and web-based application development. Our clients span the globe and benefit from our comprehensive support capabilities.

Our tools and technical expertise have repetitively proven to reduce the time and costs associated with software and custom solution development. CCS Global Tech begins each project with quality analysis and business due diligence in order to deliver quality solutions for our clients. Our team of international talent asks critical questions that illuminate the fine details of the project scope. Once we have a clear and comprehensive view of the objectives sought, we set to work to bring your vision to life.

We have a complementary matrix of skills and talents across multiple platforms that allow us to identify, target and bridge technical gaps. Regardless of the size and scope of your business application, data warehouse initiative, or enterprise-wide project, our team supports service, technical capabilities and cost effective solutions that are unmatched by our competition. We focus on delivering state-of-the-art technology, application development, warehousing and support to our clients. With the scope and flexibility to optimize development schedules and products to fit any budget requirements, CCS Global Tech is aptly positioned to not only meet unique, strategic IT objectives of diverse organization, but also complement organizational goals.