Business Intelligence Engineer (GR 31)

PACCAR•Lewisville, TX

2d•$104,100 - $162,900

About The Position

PACCAR Financial is looking for a seasoned Business Intelligence Engineer to join the team. You will analyze various key data sources, transform the data to its most useful form, and then help present using valuable reports or dashboards for PFC business to make key decisions on the daily basis.

Requirements

7+ years of experience in large-scale software development with emphasis on data modeling and database development
3-5 years of experience with BI Tools (e.g. Power BI, Tableau)
3-5 years of experience with relational databases (e.g. SQL Server, Oracle) as well as cloud data platforms (e.g. Snowflake) and SQL coding
Ability to communicate effectively (both orally and in writing) with business users, project team leaders and application developers
Experience participating in Agile/Scrum projects in a highly collaborative, multi-discipline team environment
Proficiency with ETL tools and techniques (e.g. SSIS, Attunity, Informatica, Power Query)
Strong command over SQL programming (e.g. PL/SQL, T-SQL)

Responsibilities

Analysis and visualization of structured and unstructured data
Understanding of data models and how they support key decisions and key performance indications (KPI’s).
Creating ad-hoc reports and visualizations for executive leadership, enabling data driven decisions in sales, marketing and operations.
Development of Tableau Reports with a strong understanding of advanced Tableau features and capabilities.
Communicate with stakeholders to gather business requirements and translate them into technical designs
Building interactive, customizable reports and designing and creating data visualizations and maintaining complex Tableau dashboards.
Creating analytical reports by blending data from multiple sources on a single worksheet in Tableau.
Building, defining, executing and Interpreting SQL queries.
Analyzing data, defining requirements and developing documentation.
Optimizing performance of Tableau dashboards by enhancing data models and streaming complex queries.
Leading complex projects and mentor/helping Interns and contribute strategic planning.
Providing training users on how to navigate and use Tableau dashboards and support to resolve issues.
Managing Tableau administration tasks, such as setting permissions, managing user ownership, and adding users to appropriate groups.
Supporting ad hoc requests from PFC business units.

Benefits

401k with up to a 5% company match
Fully funded pension plan that provides monthly benefits after retirement
Comprehensive paid time off – minimum of 10 paid vacation days (additional days are provided with additional seniority/years of service), 12 paid holidays, and sick time
Tuition reimbursement for continued education
Medical, dental, and vision plans for you and your family
Flexible spending accounts (FSA) and health savings account (HSA)
Paid short- and long-term disability programs
Life and accidental death and dismemberment insurance
EAP services including wellness plans, estate planning, financial counseling and more
This position is also eligible for a holiday gift