The Role
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.
Summary Generated by Built In
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.
Skills Required
- 3+ years of experience in a data-focused role such as Data Analyst, Analytics Engineer, BI Developer, or Data Governance Analyst
- Strong SQL skills and hands-on experience with cloud data warehouses, ideally Snowflake
- Experience with customer, account, CRM, or 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 technical teams and business stakeholders
- Strong organizational skills, attention to detail, and ability to manage multiple priorities in a consulting environment
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Main Digital is a consulting firm focused on digital transformation services. We empower people to create new possibilities for themselves and their organizations by reimagining business processes to leverage intelligent technologies. Our Main () Method engagement framework includes Intelligent Automation, Agile Product Management, and Total Experience best practices to deliver scalable solutions. Our clients engage with us because we focus on achieving immediate results while always keeping an eye on the digital ecosystems of the future. We provide innovative engagement models to accelerate time to value for our clients. We work in diverse teams that blend management consulting, digital design, and product engineering connected by the six core values that drive our award-winning culture. Our workplace recognition includes the Washington Business Journal Best Places to Work, Great Place to Work-Certified™, and Best Places to Work in Virginia. Main Digital is proud to be a Certified Women-Owned Small Business (WOSB) and Certified Women Business Enterprise (WBE). Learn how intelligent technology can transform your business at www.maindigital.com
.jpg){kind=logo}
