Business Analytics Senior Consultant
About The Position
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
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 SSIS, Azure Data Factory, Fabric or similar ETL technologies
- Cloud data platform experience (Fabric, Synapse, AWS Redshift, Snowflake, Databricks)
- Strong SQL skills (e.g. stored procedures, CTEs, window functions, DDL / DML)
- Experience developing reports in BI tool
Nice To Haves
- 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)
- 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
Responsibilities
- 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
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, 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
