Role Summary
Snowflake Data Platform Architect will own the architecture, design, and modernization of Riveron’s enterprise data foundation. This role will be responsible for building scalable, governed, and AI-ready data infrastructure across Snowflake, Power BI (Microsoft Fabric experience a plus), Salesforce, Alteryx migration, APIs, and shared data access patterns.
This role is central to Riveron’s future-state data strategy. The person should be both a hands-on architect and a platform owner who can create durable enterprise patterns rather than one-off reporting solutions.
Key Responsibilities
Own the architecture and technical roadmap for Riveron’s enterprise data platform.
Lead Snowflake datawarehouse / lakehouse design, including data modeling, ingestion, transformation, access controls, performance tuning, and cost optimization.
Design reusable data models, semantic layers, and governed datasets for enterprise reporting and AI-enabled use cases.
Partner with reporting and analytics teams to modernize Power BI models (Microsoft Fabric experience a plus) and reduce dependency on manual or fragmented reporting processes.
Support Alteryx modernization and migration where appropriate, replacing manual workflows with scalable data pipelines.
Design data integration patterns across Salesforce, SharePoint / Microsoft 365, finance systems, operational platforms, spreadsheets, APIs, and third-party data sources.
Establish data quality, lineage, reconciliation, documentation, and observability standards.
Partner with AI product engineers to make Riveron’s data architecture AI-ready for pilots, agents, retrieval-augmented generation, and natural language analytics.
Provide technical leadership to data engineers, BI developers, analysts, and AI engineers.
Required Experience
6-9 years of experience in data architecture, data engineering, cloud data platforms, or analytics engineering.
Deep hands-on experience with Snowflake, SQL, data modeling, ELT / ETL, and enterprise data warehouse design.
Experience with Power BI semantic models required; Microsoft Fabric or similar enterprise BI platform experience a plus but not required.
Strong understanding of data governance, security, role-based access, data quality, and lifecycle management.
Experience integrating data from SaaS platforms, APIs, finance systems, Salesforce, and flat-file sources.
Ability to design scalable architecture while still contributing hands-on when needed.
Preferred Experience
Experience with SQL, Python, Airflow, Azure Data Factory, Fivetran, Matillion, or similar tools.
Experience modernizing Alteryx or spreadsheet-heavy processes.
Exposure to AI / ML data readiness, vector databases, semantic search, RAG architecture, or LLM application patterns.
Experience in finance, consulting, professional services, or Office of the CFO analytics.
About Riveron:
At Riveron, we partner with clients—from global multinationals to high-growth private entities—to solve complex finance challenges, guided by our DELTA values: Drive, Excellence, Leadership, Teamwork, and Accountability. Our entrepreneurial culture thrives on collaboration, diverse perspectives, and delivering exceptional outcomes. We are committed to fostering growth, both for our clients and our people, through mentorship, integrity, and a client-centric approach. This inclusive environment offers flexibility, progressive benefits, and meaningful opportunities for impactful work that supports well-being in and out of the office.
Want to stay connected with Riveron? Join our Talent Community to learn more about our growing firm and be considered for future opportunities.
Check us out on social media:
LinkedIn Glassdoor Instagram Facebook
Riveron Consulting is an Equal Opportunity Employer and believes that we are stronger together through our diversity. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law.
Full time roles are eligible for a full range of benefits including medical, dental, and vision insurance, 401(k) with company match, and PTO. A complete description of all available benefits can be found at Riveron's Benefits page at https://riveron.com/riveron-life/. Contract roles are not eligible for benefits.
Fraud AlertPlease beware of fraudulent schemes or impersonations when going through the job application process. A Riveron employee will never recruit via text or extend unsolicited employment offers. Additionally, a Riveron employee will never ask you to exchange money or purchase anything as part of the recruiting process.
Artificial intelligence (AI) tools are used to support the hiring process in screening, assessing, and/or selecting applicants for this position. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.Skills Required
- 6-9 years of experience in data architecture, data engineering, cloud data platforms, or analytics engineering
- Deep hands-on experience with Snowflake, SQL, data modeling, ELT or ETL, and enterprise data warehouse design
- Experience with Power BI semantic models
- Strong understanding of data governance, security, role-based access, data quality, and lifecycle management
- Experience integrating data from SaaS platforms, APIs, finance systems, Salesforce, and flat-file sources
- Ability to design scalable architecture while contributing hands-on when needed
- Experience with SQL, Python, Airflow, Azure Data Factory, Fivetran, Matillion, or similar tools
- Experience modernizing Alteryx or spreadsheet-heavy processes
- Exposure to AI or ML data readiness, vector databases, semantic search, RAG architecture, or LLM application patterns
- Experience in finance, consulting, professional services, or Office of the CFO analytics
- Microsoft Fabric or similar enterprise BI platform experience
Riveron Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Riveron and has not been reviewed or approved by Riveron.
-
Healthcare Strength — Medical, dental, and vision coverage are paired with an HSA match, unlimited mental-health services, an EAP, and optional supplemental protections. Feedback suggests this breadth is strong for a mid-sized consulting firm.
-
Parental & Family Support — Fully paid maternity leave (12–14 weeks) and up to 6 weeks fully paid primary‑caregiver leave are offered alongside fertility, surrogacy, and adoption benefits. Additional supports like pet insurance and unlimited outpatient therapy visits reinforce family care.
-
Flexible Benefits — Flexible paid vacation and sick leave, 10 paid holidays, and a hybrid “design your own day” model indicate meaningful flexibility in when and where work happens. Commuter benefits and gym discounts further expand choice in how benefits are used.
Riveron Insights
What We Do
Riveron is a business advisory firm specializing in accounting, finance, technology, and operations. We partner with our clients to elevate performance and expand possibilities across the transaction and business lifecycle. Our thoughtfully integrated, multi-disciplinary teams bring deep functional expertise, first-hand industry knowledge, and experience-based creativity and perspective to generate tailored solutions to address any challenge. Founded in 2006, Riveron is headquartered in Dallas, Texas and has offices across the country.
