Sr. BI Specialist - Executive Reporting

Daimler Truck North America•Charlotte, NC

5d•Hybrid

About The Position

The Senior Business Intelligence Specialist will be responsible for driving the data analytics and domain strategy at DTFS. This includes consulting with business areas on business information needs, translating business needs into analytics/BI requirements, developing the analytics/BI solution and interfacing with the business area to ensure successful customer outcomes. The Senior BI Analyst position is a Lead within the team and will include mentorship, training, and direction of other BI (Band 91s) and contractors within the team. This position will also create/maintain technical design documentation to ensure capture of relevant meta data in support of the data management domain. We provide a scheduled posting end date to assist our candidates with their application planning. While this date reflects our latest plans, it is subject to change, and postings may be extended or removed earlier than expected. We Take Care of Our Team Pay offered dependent on knowledge, skills, and experience Benefits include annual bonus program; 401k company contribution with company match up to 8% as well as non-elective company contribution of 3 - 7% depending on age; starting at 4 weeks paid vacation; 13+ calendar holidays; 8 weeks paid parental leave; employee assistance program; comprehensive healthcare plans and wellness programs; onsite fitness (at some locations); tuition assistance and volunteer paid time off; short-term and long-term disability plans. What You Drive at DTFS The position will support the management reporting needs of business areas in both U.S. and Canada, including the preparation of Reporting outputs (dashboards, PowerPoint presentations etc.) for DTFS Executives. Travel time is estimated at no more than 5%. In depth knowledge of the availability of data beyond the US in DWH, OPI/KPI metrics, and an understanding of the portability of US metrics to other markets is required. Data Insights Solution Development and Customer Support - using various BI and Visualization tools, work with business areas to provide leadership on independent initiatives, facilitate information gathering, develop structured documentation, and present findings to all levels of management. Develop/maintain dashboards, analytics, and other data visualizations that provide business insight. This includes gathering and analyzing requirements from business users and developing BI solutions. This includes advanced support for SQL/reports/End User Computing (EUC) applications for internal customers. Collaborate with IT partners and business partners in support of month end processes where applicable. Data Mart and Cognos Framework Design - This role may include the Data Mart design and Cognos Framework Management. If so, this position will manage the framework for the reporting environment. Architect and model existing data to be easily consumed by customers and reports. Optimize performance of BI solutions through working with ETL and DBA resources. Data stewardship – Partner with the business, IT, and the DIAA to drive the BI environment to meet future business needs. Work with business SMEs to identify and close existing data gaps in the BI environment. Develops and writes business information requirements for the changes to the BI landscape. Analyze and assess impacts to the data warehouse and BI landscape for key project initiatives. Collaborate with IT partners to translate business requirements into technical specifications for IT supported system solutions. Project management - Lead EPM and Data Domain owned projects. Drive data management domain initiatives and projects to assess impact to BI domain. Meet project schedules, identify potential issues and develop workarounds as needed to ensure continuity of BI solutions. Data Preparation/Executive Reporting support/Ad Hoc BI Support- Develop and maintain curated data sets needed to support the Advanced Analytics group use cases. Provide advanced technical support to the business analysts as needed using various BI tools including usage review and performance tuning. Support the business as necessary to clear audit/compliance conditions. Strategy/BI Governance: Contribute to the short- and long-term strategic approach for the Data Domain. As new technology and tools are identified, support the development of strategy for associated BI products, models, visualizations, governance, etc.

Requirements

BS/BA and prefer 5-7 years of relevant experience or 8 years of relevant experience in lieu of degree
3 years working in Data, Analytics, and reporting
SQL(non RDBMS Specific)
Data Visualization
Reporting
Working with Structured Data stored in a RDBMS
MS Office suite
In depth knowledge of the availability of data beyond the US in DWH, OPI/KPI metrics, and an understanding of the portability of US metrics to other markets is required.

Nice To Haves

Experience with Python, SAS Programming, Alteryx, AI, Cognos Analytics, Cognos Framework, Cognos Transformer, Tableau, MS Power BI, Data Management and Governance, Finance (automotive industry)

Responsibilities

Consulting with business areas on business information needs
Translating business needs into analytics/BI requirements
Developing the analytics/BI solution
Interfacing with the business area to ensure successful customer outcomes
Mentorship, training, and direction of other BI (Band 91s) and contractors within the team
Create/maintain technical design documentation to ensure capture of relevant meta data in support of the data management domain
Preparation of Reporting outputs (dashboards, PowerPoint presentations etc.) for DTFS Executives
Data Insights Solution Development and Customer Support
Develop/maintain dashboards, analytics, and other data visualizations that provide business insight
Gathering and analyzing requirements from business users and developing BI solutions
Advanced support for SQL/reports/End User Computing (EUC) applications for internal customers
Collaborate with IT partners and business partners in support of month end processes where applicable
Data Mart design and Cognos Framework Management
Manage the framework for the reporting environment
Architect and model existing data to be easily consumed by customers and reports
Optimize performance of BI solutions through working with ETL and DBA resources
Partner with the business, IT, and the DIAA to drive the BI environment to meet future business needs
Work with business SMEs to identify and close existing data gaps in the BI environment
Develops and writes business information requirements for the changes to the BI landscape
Analyze and assess impacts to the data warehouse and BI landscape for key project initiatives
Collaborate with IT partners to translate business requirements into technical specifications for IT supported system solutions
Lead EPM and Data Domain owned projects
Drive data management domain initiatives and projects to assess impact to BI domain
Meet project schedules, identify potential issues and develop workarounds as needed to ensure continuity of BI solutions
Develop and maintain curated data sets needed to support the Advanced Analytics group use cases
Provide advanced technical support to the business analysts as needed using various BI tools including usage review and performance tuning
Support the business as necessary to clear audit/compliance conditions
Contribute to the short- and long-term strategic approach for the Data Domain
Support the development of strategy for associated BI products, models, visualizations, governance, etc.

Benefits

annual bonus program
401k company contribution with company match up to 8% as well as non-elective company contribution of 3 - 7% depending on age
starting at 4 weeks paid vacation
13+ calendar holidays
8 weeks paid parental leave
employee assistance program
comprehensive healthcare plans and wellness programs
onsite fitness (at some locations)
tuition assistance and volunteer paid time off
short-term and long-term disability plans