Snowflake Data Platform Architect

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 Alert

Please 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.