Sr. Business Intelligence Engineer - Warehouse Analytics - Remote

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