Skip to main content

This job has expired

Business Intelligence Engineer

Employer
Solstice Consulting Group
Location
Houston, Missouri
Closing date
Oct 7, 2021

View more

Position Type
Other
Hours
Full Time
Specialty
Business Anthropology
Organization Type
Business
Job Description
Solstice Consulting Group is seeking a Business Intelligence Engineer for a client in North Houston.

• $90k - $120k annually with quarterly bonus opportunity and full benefits

• Hybrid - in office option (40% in office / 60% WFH)

The opportunity

As a BI Engineer, you will join a fast-growing data organization at a global company that values insight and problem solving, focusing on solutions over just delivering reports. You will work directly with internal and external clients to deliver data products that drive decision-making-building data models, designing metrics & KPIs, and creating dashboards & data apps.

You'll work in three main modes on our Business Intelligence team:

Problem-solving and solution design

· You'll act as part private investigator, part anthropologist as you work to map real-world activity and processes to systems and data

· You'll act as an internal consultant as you work collaboratively with business partners to design the best way to make people's decisions better and their lives easier

Data modeling

· You'll use dbt, a SQL-based framework for defining data transformations, to build and extend core data models in our Snowflake data warehouse

· You'll also develop the backend models for Power BI datasets, using DAX and the full range of tooling available to you in the Power BI service

Visualization and product development

· You'll make apps and dashboards in Power BI, targeting hundreds to thousands of users globally

· You will have the freedom to explore other solutions as needed, even if they're not part of our core stack

No matter what mode you're working in at the time, you'll use an engineering-driven approach: you'll automate, you'll test, you'll use version control, you'll optimize performance, you'll measure outcomes.

You'll also spend time on learning new data skills: we'll specifically allocate time for you to attend trainings, try new technologies, or work on side projects, so that you can grow with the team.

You should have

Required:

· 3+ years using SQL

· Experience building dashboards or with visualization & designing user experiences

· Experience designing KPIs: you understand and can communicate the impacts of selecting one metric over another

· 2+ years of experience with Power BI Experience with Python or R

· A highly quantitative background Experience with dbt

Our stack

· dbt, a SQL-based framework for defining, testing, and documenting transformations and data models

· Snowflake as our primary storage and compute engine

· Azure Data Lake for archival and staging

· Prefect (think superior Airflow), a Python-based orchestrator

· Terraform for infrastructure configuration and provisioning

· git for version control

· GitHub Actions and Azure DevOps for CI/CD

· HVR for CDC (change data capture) from relational data stores

· Airbyte and custom integrations for batch-based integrations

· Power BI for rapidly building dashboards
Company Descriptionwww.solcongrp.com

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert