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