Client-facing consultant responsible for designing, documenting, governing, and improving enterprise customer and account data models in Snowflake. The role translates business requirements into data structures, maintains data dictionaries and lineage documentation, validates integrations and data quality, and coordinates issue resolution across CRM, marketing, analytics, and operational systems. It requires strong SQL, data modeling, governance, stakeholder engagement, and consulting skills.
This is a remote position.
WHO ARE WE LOOKING FOR?
We are seeking a client-facing Customer Data Governance & Modeling Consultant who can bridge the gap between business stakeholders, analytics teams, and data engineering organizations. This individual is passionate about creating trusted customer data assets and has experience working with customer, account, and CRM data within modern cloud data environments. You are comfortable translating business requirements into data structures, documenting complex data ecosystems, and ensuring data is reliable and accessible across the organization.
The ideal candidate combines strong analytical and technical skills with excellent consulting and communication abilities. You can collaborate effectively with both technical and non-technical audiences, drive data governance initiatives, and help organizations improve the quality, consistency, and usability of customer data. You thrive in cross-functional environments and bring a detail-oriented approach to data quality, documentation, and stakeholder engagement.
WHAT YOU'LL DO:
Reporting to our Delivery Operations Manager, as a Full-Time Specialist on our team, you will work remotely to support the design, documentation, and ongoing management of enterprise customer and account data models within Snowflake. Working closely with client stakeholders, data engineers, architects, and analytics teams, you will help ensure customer data is structured, governed, and aligned with business objectives. You will contribute to defining entity relationships, documenting source-to-target mappings, validating data flows, and supporting enhancements to customer data assets.
You will also play a key role in data governance and quality initiatives by establishing business definitions, maintaining data documentation, validating integrations, and helping resolve data issues across systems such as Salesforce, marketing platforms, analytics tools, and downstream activation solutions. Your work will help ensure customer data remains accurate, trusted, and ready for reporting, analytics, and operational use cases.
QUALIFICATIONS:
- 3+ years of experience in a data-focused role such as Data Analyst, Analytics Engineer, BI Developer, Data Governance Analyst, or similar roles.
- Strong SQL skills and hands-on experience working with cloud data warehouses, ideally Snowflake
- Experience working with customer, account, CRM, or other complex relational datasets
- Ability to document and analyze data flows across multiple systems and platforms
- Experience creating and maintaining data dictionaries, business glossaries, data lineage documentation, and source-to-target mappings
- Strong understanding of data quality principles, governance frameworks, and data stewardship practices
- Experience validating data integrations, data transformations, and business rule implementation
- Familiarity with Salesforce or similar CRM platforms and their underlying data structures
- Working knowledge of data modeling concepts including entity relationships, primary and foreign keys, normalization, and dimensional modeling
- Exposure to ETL, ELT, reverse ETL, or customer data activation tools
- Experience supporting analytics, reporting, or business intelligence initiatives
- Excellent verbal and written communication skills with the ability to engage technical teams and business stakeholders
- Strong organizational skills, attention to detail, and ability to manage multiple priorities in a consulting environment
RESPONSIBILITIES:
- Support the design, maintenance, and enhancement of enterprise customer and account data models within Snowflake
- Partner with business stakeholders to gather requirements and translate them into logical data model enhancements
- Document customer data entities, relationships, hierarchies, identifiers, and business definitions
- Create and maintain source-to-target mappings, data lineage documentation, and integration diagrams
- Analyze and document data movement between CRM, marketing, analytics, enrichment, and operational systems
- Collaborate with data engineers to define, validate, and monitor data contracts and integration requirements
- Perform data validation activities, including reconciliation, quality checks, referential integrity testing, and completeness reviews
- Establish and maintain data quality standards, governance processes, and data stewardship practices
- Develop and maintain data dictionaries, business glossaries, and standardized field definitions
- Coordinate investigation and resolution of customer data quality, consistency, and completeness issues
- Support analytics and reporting teams by ensuring customer data assets meet business and operational needs
- Promote data standards, naming conventions, and governance best practices across teams
- Educate business users and analysts on available customer data assets and their intended use
- Facilitate collaboration among business stakeholders, architects, engineers, and analytics teams to improve customer data management and governance outcomes
WHAT WE OFFER:
Celebrated by Inc. 5000 for our rapid growth and award-winning workplace, Main Digital invites you to be a part of our collaborative and forward-thinking team. As a Certified Women-Owned Small Business, we champion diversity in tech. Our diverse teams combine management consulting expertise, innovative digital design, and advanced product engineering. Driven by our six core values, we lead in intelligent automation, platform technologies, and Agile methodologies to create unparalleled digital experiences. Join us as we empower people to create new possibilities through process and technology, reimagining the ways of work and enhancing experiences with digital transformation.
Ready to innovate? Explore a career offering competitive compensation, comprehensive benefits, and extensive development opportunities. Apply today and shape the future with us!
Main Digital is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment that is free of harassment, discrimination, or retaliation because of age, race, color, national origin, ancestry, religion, sex, sexual orientation (including transgender status, gender identity or expression), pregnancy (including childbirth, lactation, and related medical conditions), reproductive health decisions, marital status, personal appearance, matriculation, political affiliation, credit information, employment status, physical or mental disability, genetic information (including testing and characteristics), veteran status, uniformed service member status, status as a victim or family member of a victim of domestic violence, a sexual offense, or stalking, homeless status, or any other status protected by federal, state, or local laws.
Similar Jobs
Fintech • Real Estate • Software • Financial Services • PropTech
Manage inbound homeowner leads through the full sales cycle for Hometap's home equity investment: qualify and educate homeowners, maintain pipeline in Salesforce and Hometap's Hub, coordinate with internal teams, collect documentation, close deals, and meet monthly and quarterly sales targets while ensuring regulatory compliance.
Top Skills:
Hometap HubSalesforce
Fintech • Real Estate • Software • Financial Services • PropTech
Own a full inbound sales pipeline for Hometap's home equity investment product: educate homeowners, guide applications from first call to close, coordinate with internal teams, use Salesforce and proprietary tools, meet monthly and quarterly sales goals, and maintain compliance and high-quality homeowner communication.
Top Skills:
Hometap Proprietary HubSalesforce
eCommerce • Enterprise Web • Information Technology • Software • Database • Analytics • Business Intelligence
Leads technical strategy for complex enterprise sales opportunities across the Americas. Designs solution demonstrations, architectures, proof-of-concepts, and ROI-based value propositions for digital analytics and agentic AI solutions. Partners with account executives, customer success, product, and engineering; manages executive stakeholders; mentors Solutions Engineers; leads RFP responses; and influences the product roadmap. The role requires 20–25% travel and strong web technology, presentation, and enterprise pre-sales expertise.
Top Skills:
Agentic AiAndroidCSSEnterprise Data ArchitectureHTMLiOSJavaScriptSalesforce
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
