Business Analytics Senior Consultant

Count on us. Our “we-care” culture is more than just a motto; it’s a promise. From day one, we prioritize your growth, well-being, and success. You can count on us to support your career journey and help you achieve your professional goals. Join us.

Your role.

Your work may include, but not be limited to:

• Gathering requirements from client stakeholders
• Architecting client data and analytics environments
• Designing, developing, and deploying data warehouses
• Performing advanced SQL scripting and data engineering
• Facilitating the conceptual/logical data modeling process
• Developing advanced ETL processes and data pipelines
• Performing API integration, deployment, and support
• Developing and deploying reports and BI solutions
• Mentoring and coaching less experienced staff
• Participating in firm/client innovation projects
• Supporting practice development activities
• Supporting project management

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 2+ years of experience with data engineering and analytics deployment
• Demonstrated ability to diagnose and resolve complex technical challenges
• Ability to manage multiple concurrent projects and data development projects
• Hands-on experience SSIS, Azure Data Factory, Fabric or similar ETL technologies
• Cloud data platform experience (Fabric, Synapse, AWS Redshift, Snowflake, Databricks)
• Experience configuring, deploying, and or administering a cloud data platform is desired
• Experience working within DevOps CI/CD tools and processes is desired (ADO, GitHub, dbt)
• Strong SQL skills (e.g. stored procedures, CTEs, window functions, DDL / DML)
• Experience developing and deploying Python ETL scripts and APIs a plus
• Experience construction and / or manufacturing industry a plus
• Microsoft SQL Server / Azure / Fabric certification(s) a plus
• Experience developing reports in BI tool
• Approximately, Interested applicants must submit their resume for consideration using our applicant tracking system. Due to the high volume of interest in our positions, 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 qualified candidates who are bilingual in either Japanese and English or Chinese 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., Amazon Web Services (AWS), Application Programming Interface (API), Business Analysis, Business Intelligence, Business Intelligence Software, Business Plan, Chinese Language, Cloud Computing, Coaching, Community Support, Compensation and Benefits, Computer Science, Construction, Consulting, Continuous Deployment/Delivery, Continuous Integration, Customer/Client Research, Data Administration, Data Analysis, Data Description Language (DDL), Data Management, Data Modeling, Data Processing, Data Warehousing, Database Extract Transform and Load (ETL), DevOps, Diversity, Employee Retention, English Language, Establish Priorities, Geography, GitHub, Identify Issues, Information Technology & Information Systems, Insurance, Japanese Language, Manufacturing, Mentoring, Microsoft ADO (ActiveX Data Object), Microsoft SQL Server, Microsoft Windows Azure, Multilingual, Multitasking, Process Modeling, Project/Program Management, Python Programming/Scripting Language, Reimbursement, Reporting Skills, Resume Search, Retirement Plan, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Stored Procedures, Wealth Management

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. 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 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 some contingent staff positions the option to elect health insurance in addition to limited paid sick time.

The compensation range reflects the base salary we reasonably expect to pay for this position across our offices in the following regions: CO, IL, OH, and MA. Please review the position description for the applicable geographic location. Generally, experienced hires are not hired at or near the maximum salary range, as compensation decisions take into account a wide variety of factors, including but not limited to: responsibilities, education, experience, knowledge, skills, and geography. For early career roles, including campus hires, we offer standardized, market-based starting salaries among individuals within the same hiring group. This approach ensures fairness and reflects current industry benchmarks for entry-level talent.

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

The compensation range for this role in CO, IL, OH, and MA is: $90,000.00 - $120,000.00

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.

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.

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.