Note: The job is a remote job and is open to candidates in USA. Boston Data Company is a consultancy that helps clients build and improve their data practices. The Senior BI Consultant designs and builds scalable data products, works with clients to understand business needs, and delivers analytics and business intelligence solutions.

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
• Strong experience with dbt
• 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, or BigQuery
• Strong critical thinking and communication skills
• Experience with EL/ETL tooling such as Fivetran, dlt, and Airbyte
• Python proficiency
• 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