Senior Business Analytics Consultant
Denver, Illinois, United States of America
Full Time
2 weeks ago
$90,000 - $120,000 USD
H1B Sponsor
Key skills
Amazon RedshiftAWSAzureCloudETLMS SQL ServerPythonSQLSSISData EngineeringAnalyticsBISnowflakeRedshiftDatabricksdbtSQL ServerGitHubCI/CDProject ManagementMentoring
About this role
Role Overview
- 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.
Tech Stack
- Amazon Redshift
- AWS
- Azure
- Cloud
- ETL
- MS SQL Server
- Python
- SQL
- SSIS
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