Business Intelligence Engineer

About the role

ESSENTIAL JOB FUNCTIONS   Designs, develops, and maintains enterprise BI solutions. Utilizes Business Intelligence technology to meet operational and business needs through modern reporting solutions.   Use s an engineering-driven approach: automate, test, use version control, optimize performance, measure outcomes. Working in three main modes on our Business Intelligence team: Problem-solving and solution design Act as part private investigator, part anthropologist while working to map real-world activity and processes to systems and data. Act as an internal consultant while working collaboratively with business partners to design the best way to make people's decisions better and their lives easier. Data modeling 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 in the Power BI service. Extend existing datasets to generate data for BI projects.   Visualization and product development Make apps and dashboards in Power BI, targeting hundreds to thousands of users globally. Have the freedom to explore other solutions as needed, even if they're not part of our core stack. Develop high quality visuals using best practices.   Other duties as assigned.   PHYSICAL REQUIREMENTS   Job may require extended sitting or standing, use of standard office equipment. Job requires the ability to use vision, adjust focus and work on a standard computer screen. Use of audio-visual equipment is required.   OTHER SKILLS/ABILITIES   Proficient in SQL: Write correct, well-structured queries following team style guides   Proficient in Power BI: Understand core concepts including data modeling, Power Query, and DAX fundamentals   Familiarity with dbt: Able to extend existing data models and follow established patterns   Experience designing and communicating KPIs, including trade-offs between measurement approaches   Analytical thinking: Consider costs, benefits, risks, and trade-offs when approaching data and design problems   Proactive: Take ownership of tasks with energy and enthusiasm, escalating blockers appropriately   Effective collaboration: Build working relationships with peers, stakeholders, and senior teammates   Clear communication: Can explain data concepts and metric decisions to non-technical stakeholders   Focus on quality: Apply engineering discipline including testing, version control, and documentation to all deliverables   EDUCATION AND EXPERIENCE Bachelors in Relevant field such as Computer Science, Management Information Systems, Mathematics, Statistics, Business Analytics required. 2+ years of experience in a quantitative or highly technical role (data analyst/scientist, BI engineer/developer, data or software engineer, etc)   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 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 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. More Information:    Company benefits are contingent upon meeting eligibility requirements and plan conditions.