• Location: United States, Colorado, Denver

• Location: United States, Illinois, Chicago

Make your mark. Our management consulting team focuses on our clients' critical business needs. From strategy to operations and everything in between, our integrated solution approach is designed to help enable and manage growth, leverage resources, and mitigate costs and risks. At Plante Moran, we have the privilege of serving clients and providing consultative services as they face challenges and seek new opportunities.

Plante Moran enjoys a "Workplace for Your Day" model which, simply put, means we strive for flexibility and balance while staying true to our principally in-person model. We believe that face-to-face interactions are paramount for individual and collective development, but also encourage individuals to work with their supervisor and team to determine their optimal working environment each day.

Your role.

Your work will include, but not be limited to:

• Be a technical expert in all aspects of Snowflake
• Work hands-on with customers at a deep technical level to successfully position and implement Snowflake using best practices, including knowledge transfer to customers.
• Guide customers and resolve customer-specific technical challenges with Snowflake
• Responsible for end-to-end data analytics design, data modeling, and development for Snowflake for multiple client projects.
• Provide database administration and architecture for cloud-based database technologies, e.g., Snowflake, Databricks, Azure, AWS
• Authoring internal and client-based training workshops related to cloud database technologies
• Establishing best practices for data architecture best practices for Snowflake and cloud platforms.
• Delivering robust and scalable solutions to clients
• Working with other data management technologies, e.g., ETL, data quality
• Build and manage client relationships, including practice development activities
• Managing client relationships and project management duties
• Mentor junior staff
• Learn quickly and stay on top of new technologies relevant in the marketplace
• Providing recommendations to management and driving future direction and pursuit paths

•The qualifications.

• Bachelor's degree or above
• 7-15 years of experience with data warehouse and analytics architecture.
• 5+ years' experience with Snowflake and related technology stack, ETL/ELT, and database administration
• 3+ years of hands-on Snowflake experience in development, modeling, and architecture.
• Advanced knowledge of Python programming and experience with Snowpark
• Possesses strong hands-on experience with SQL or Database Administrator
• Have proven experience with data modeling including dimensional data modeling and related technologies.
• Proven understanding of traditional analytics projects, such as data warehouses, data lakes, master data management, system integrations, etc.
• Prior experience with full data analytics stack from ETL to data platform architecture and design to BI and analytics tools.
• Prior consulting experience including new business development preferred.
• Minimal travel with approximately 20-25% overnight (note: currently

Our difference.

On the surface, we're one of the nation's largest audit, tax, consulting, and wealth management firms. But dig a little deeper, and you'll see what makes us different: we're a relatively jerk-free firm (hey, nobody 's perfect) with a world-class culture, consistent recognition as one of Fortune Magazine's "100 Best Companies to Work For," and an endless array of opportunities. At Plante Moran, diversity, equity and inclusion means that all staff members have equitable and fair opportunities to succeed, in an inclusive environment, with their individual, unique identities. So, what are you waiting for? Apply now.

This is an exempt position, so you may have to work hours that exceed the standard 40-hour work week.

Plante Moran is committed to a diverse workplace. We strive to create a culture where each person feels accepted and valued. We believe that each person's ultimate potential begins with first acknowledging their inherent dignity. When we can recognize - and celebrate - our many human differences, we're able to create a workplace where all staff feel a sense of belonging and an opportunity to succeed. This allows us to attract and retain the best talent, serve clients through diverse thinking, and better represent and support the various communities in which we live and work. Plante Moran is an Equal Opportunity Employer.

Plante Moran maintains a drug-free workplace.

Interested applicants must submit their resume for consideration using our applicant tracking system. Due to the high volume of applications received, only candidates selected for interviews will be contacted. Candidates must be legally authorized to work in the United States without sponsorship, with the exception of candidates that are bilingual in Japanese and English. Unsolicited resumes from search firms or employment agencies, or similar, will not be paid a fee and become the property of Plante Moran.

The specific statements above are not intended to be all-inclusive.

#LI-CD1

#LI-Hybrid

For Colorado Applicants click here

Salary Class

Salary

Colorado Equal Pay for Equal Work Act (SB 19-085) Information

Compensation is commensurate with technical skills and experience and is provided in accordance with the CO Equal Pay for Equal Work Act.

Compensation information posted is based on a position being located in the state of CO. Please review position location for applicable geographic location.

Colorado monthly base range is as follows:

$10,583.33 to $13,833.33

We are pleased to offer eligible staff a robust benefits package. Eligibility and contribution requirements for some of these benefits vary based on the number of hours staff work per week. Highlights include health, dental, vision, disability and life insurance. These standard offerings are effective on the first of the month following your start date. In addition to this, eligible staff are able to take advantage of our Flexible Time Off and various pre-determined holidays as well as a balance fund, 401(k) plan, flexible benefits plans, business-related travel expense, lodging and meal reimbursement for business-related use. A Pension plan is also available for eligible administrative and paraprofessional staff. A discretionary bonus plan is available for eligible staff. Plante Moran also offers Interns and Contractors the option to elect health insurance under our contingent staff medical plan as of the 1st of the month following 60 days of employment in addition to limited paid time sick time. Seasonal staff are not eligible for benefits.

Colorado Job Application Fairness Act

Under Colorado's Job Application Fairness Act, you have the right to redact from any documents that you submit in connection with your application information that identifies your age, date of birth, or dates of attendance at or graduation from an educational institution. Should you wish to exercise your right to redact such information, please redact it prior to submitting the documentation.