Sr. Business Intelligence Engineer

Ultipro; Houston (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Quarterly Incentive Plan

Paid Time Off 17 days

Medical, Dental and Vision benefits

Tuition Reimbursement

Employee Discounts

Volunteer Time

Wellness incentives

Job summary

Crane seeks an Analytics Engineer to join our Business Intelligence team in Houston. You will design solutions, map real-world activity to data, and help partners make better decisions through dashboards and data models.

You will build data models in Snowflake, develop Power BI datasets with DAX, and use dbt for transformations. Ideal candidates have 4+ years in analytics, strong SQL, and Python or R; on-site with strong benefits.

Qualifications

• 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
• Applicants must be legally authorized to work in the United States on a full-time, ongoing basis without the need for current or future employer sponsorship

Responsibilities

• You'll contribute to problem-solving and solution design for BI
• You'll map real-world activity and processes to systems and data
• You'll serve as an internal consultant with business partners to improve decision-making
• You'll build and extend data models in Snowflake
• You'll develop backend models for Power BI datasets using DAX and related tooling
• You'll create dashboards and apps in Power BI for hundreds to thousands of global users
• You'll explore other solutions as needed while using an engineering-driven approach

Skills

Problem solving

Data modeling

KPI design

SQL

Power BI

Python

Education

Bachelor's degree or equivalent experience

Tools

Power BI

dbt

Snowflake

Azure Data Lake

Prefect

Terraform

Git

GitHub Actions

Azure DevOps

HVR

Fivetran

Stitch

Job description

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.

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
• 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
• Applicants must be legally authorized to work in the United States on a full-time, ongoing basis without the need for current or future employer sponsorship

Ideal:

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

WHY SHOULD YOU WORK FOR CRANE?

At Crane, we believe in providing our employees with excellent benefits at a Great Place to Work.

We offer:

• 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 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

Come join the leader in logistics and take your career in the right direction.

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

We maintain a drug-free workplace and perform pre-employment substance abuse testing.

This position requires the final candidate to successfully pass an E-Verify Check.

Company benefits are contingent upon meeting eligibility requirements and plan conditions.

Qualifications

Education

Required

Bachelors or better.

High School or better.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.