Senior Business Analytics Consultant
Plante Moran
full-time
Posted on:
Location Type: Hybrid
Location: Denver • Colorado • Illinois • United States
Visit company websiteExplore more
Salary
💰 $90,000 - $120,000 per year
Job Level
About the role
- 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
Requirements
- 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 with SSIS, Azure Data Factory, Fabric or similar ETL technologies
- Cloud data platform experience (Fabric, Synapse, AWS Redshift, Snowflake, Databricks)
- Experience configuring, deploying, and 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 is a plus
- Experience in construction and/or manufacturing industry is a plus
- Microsoft SQL Server / Azure / Fabric certification(s) is a plus
- Experience developing reports in BI tool
- Approximately < 20% overnight travel
- Candidates must be legally authorized to work in the United States without sponsorship.
Benefits
- health, dental, vision, disability, and life insurance
- Flexible Time Off
- various pre-determined holidays
- 401(k) plan
- flexible benefits plans
- business-related travel expense reimbursement
- lodging and meal reimbursement for business-related use
- pension plan for eligible administrative and paraprofessional staff
- discretionary bonus plan for eligible staff
- health insurance for contingent staff positions with limited paid sick time
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLETLdata engineeringdata modelingAPI integrationdata warehousingPythonreport developmentdata pipelinesadvanced SQL scripting
Soft Skills
mentoringcoachingproject managementproblem-solvingcommunicationinnovationorganizational skillsstakeholder engagementteam collaborationtime management
Certifications
Microsoft SQL Server certificationAzure certificationFabric certification