Business Intelligence Engineer II

. Crane Worldwide Logistics . • Houston, TX

1d

About The Position

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.

Requirements

• Bachelor's degree or equivalent experience
• Four+ 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
• Warehousing industry experience, with a strong understanding of warehouse operations, inventory management, and distribution processes
• Experience with Warehouse Management Systems (WMS), including platforms such as Footprint and/or Softeon

Nice To Haves

• A highly quantitative background
• Experience with dbt
• Deep knowledge of SQL
• 2+ years of experience with Power BI
• Experience with Python or R

Responsibilities

• Act as part private investigator, part anthropologist as you work to map real-world activity and processes to systems and data
• 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
• Use dbt, a SQL-based framework for defining data transformations, to build and extend core data models in our Snowflake data warehouse
• Develop the backend models for Power BI datasets, using DAX and the full range of tooling available to you in the Power BI service
• Make apps and dashboards in Power BI, targeting hundreds to thousands of users globally
• Automate, test, use version control, optimize performance, and measure outcomes
• Spend time on learning new data skills: attend trainings, try new technologies, or work on side projects

Benefits

• Quarterly Incentive Plan
• 136 hours of Paid Time Off which equals 17 days for the year, that can be used for Sick Time or for Personal Use
• Excellent Medical, Dental and Vision benefits
• Tuition Reimbursement for education related to your job
• Employee Referral Bonuses
• Employee Recognition and Rewards Program
• Paid Volunteer Time to support a cause that is close to your heart and contributes to our communities
• Employee Discounts
• Wellness Incentives that can go up to $100 per year for completing challenges, in addition to a discount on contribution rates

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level