NAVA Software solutions is looking for a Sr. Business Intelligence Engineer - Warehouse Analytics
Details:
Sr. Business Intelligence Engineer - Warehouse Analytics
Location: Remote
Duration: Full time /Direct Hire
Responsibilities:
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.
Must have / Required skills:
Preferred: WMS, footprint or Softeon experience
Must be great with data modeling and Power BI
Must be ambitious - a lot of dashboards that need to be rebuilt
Must produce high quality work and can be in front of a client
Must: Sr. level - 7+ years of professional BI experience
Must: Strong SQL
Must: DBT
Data modeling
Power BI
Snowflake
Experience working with stakeholders and presenting in front of clients
Project ownership
OUR STACK
Power BI for rapidly building dashboards
Snowflake as our primary storage and compute engine
dbt, a SQL-based framework for defining, testing, and documenting transformations and data models
Azure Data Lake for archival and staging
Prefect for orchestration
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
Fivetran, Stitch, and custom integrations for batch-based integrations
EDUCATION AND EXPERIENCE
Required:
Bachelor's degree or equivalent experience
10+ years of relevant professional experience as a Business Analyst, Data Analyst, or Analytics Engineer
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
Ideal:
A highly quantitative background
Experience with dbt
Deep knowledge of SQL
2+ years of experience with Power BI
Experience with Python or R