Business Intelligence Engineer

ESSENTIAL JOB FUNCTIONS

• Work directly with executive and operational staff to design and validate reports, dashboards, and other data products to improve business
• Tune Microsoft SQL Server databases and queries for our data warehouse
• Build, monitor, and troubleshoot SQL Server Integration Services (SSIS) packages that move data from and between a variety of sources
• Develop and optimize Paginated Reports in SQL Server Reporting Services (SSRS) reports or Power BI Premium
• Work with other team members to optimize development approaches and team processes
• Perform code reviews and evaluate reports and packages for best practices
• Contribute to development standards for the team
• Coach internal business partners to develop self-service analytics capabilities throughout the organization
• Develop Power BI reports and the associated infrastructure, utilizing Power BI Premium and Azure services
• Assist in migrating reporting workloads from SQL Server + SSRS to Snowflake + Power BI/Paginated Reports
• Influence our strategic roadmap for data engineering, BI, and analytics
• Drive quality and reliability throughout our data stack
• Other duties as assigned
• 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.

 OTHER SKILLS/ABILITIES

• Advanced SQL and Excel skills, familiarity with statistics or other analytical techniques
• Knowledge of BI reports and dashboards and ability to design or update reports to meet the needs of business teams.
• Excellent verbal and written communication skills
• Ability to coach junior team members and lead group initiatives
• Ability to work with non-technical stakeholders to translate business needs into requirements for data solutions
• Ability to work on a distributed team with people in multiple time zones and with diverse cultural backgrounds
• Ability to plan ahead, test, and make reasoned trade-offs
• Ability to work in a high-trust, high-autonomy environment
• Meticulous about correctness and the quality of work
• Ability to automate to reduce errors and eliminate unnecessary work
• Comfortable working in an Agile/Scrum environment

PHYSICAL REQUIREMENTS

• Talking, hearing and using hands to operate and install computers
• Vision abilities required by this job include close vision and the ability to adjust focus
• The employee may be required to push, pull, lift or carry up to 60 pounds

 PHYSICAL REQUIREMENTS

• Talking, hearing and using hands to operate and install computers
• Vision abilities required by this job include close vision and the ability to adjust focus
• The employee may be required to push, pull, lift or carry up to 60 pounds

EDUCATION AND EXPERIENCE

• Bachelor's degree or equivalent experience
• Four+ years of relevant professional experience as a Business Analyst, Data Analyst, or Analytics Engineer
• Experience working in an Agile/Scrum environment
• Experience in data mining (SQL, ETL, data warehouse, etc.) and using databases in a business environment with large-scale, complex datasets

Certifications & Licenses

• Professional certification may be required in some areas.

MUST COMPLETE PI ASSESSMENT IN ORDER TO BE CONSIDERED FOR THE POSITION:

https://assessment.predictiveindex.com/bo/28w/Candidate_Link

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: http://www.dhs.gov/e-verify 

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