Note: The job is a remote job and is open to candidates in USA. Boston Data Co. is a dynamic consultancy that helps businesses build and improve their data practices to enable data-driven decisions. The Senior BI Consultant will design and build scalable data solutions, develop data products and dashboards, create AI-driven solutions, and collaborate closely with clients to address their business needs.
Responsibilities
- Creating end-to-end data products for clients including: • Ingesting data from multiple sources into a data warehouse • Transforming raw data into clean and flexible data models via transformation tools including dbt • Modeling data in a BI tool and creating dashboards • Creating AI-driven solutions leveraging the data foundation
- Communicating and iterating with clients
- Performing ad-hoc analyses
- Researching the latest and greatest in data tooling
Skills
- 5+ years of experience in analytics engineering and business intelligence
- Expertise in SQL (including proficiency with window functions)
- Knowledge of data modeling best practices, with experience architecting medallion-style data environments
- Ability to create insightful dashboards in a BI tool such as Sigma, Looker, Tableau, or an equivalent
- Experience with leading cloud data warehouses including Snowflake, Databricks, BigQuery, or Redshift
- Strong critical thinking and communication skills
- Experience with EL/ETL tooling such as Fivetran, dlt, and Airbyte
- Python proficiency
- Strong experience with dbt (certification preferred)
Benefits
- Fully remote role (WeWork membership provided for an in-office workspace)
- Health & dental insurance (75% covered for employee + dependents)
- Lots of learning and growth opportunities — you’ll take ownership and grow fast.
Company Overview