Sr. BI Specialist - Executive Reporting

Daimler Truck North America•Charlotte, NC

21h•Hybrid

About The Position

Inside the Role 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. Posting Information 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 Typically requires a Bachelors Degree Typically requires 5-7 years of relevant experience or 8 years of relevant experience in lieu of degree Requires in-depth knowledge and expertise in job field and working knowledge of related disciplines Uses analytical thought to independently solve complex problems with minimal guidance and identify solutions May lead team or department projects or work streams within broader projects Acts as an advisor to management and key external stakeholders on job field related projects Acts as a resource and guide for colleagues with less experience Uses experience to contribute to standards in which others will operate 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. Knowledge You Should Bring BS/BA and prefer 5-7 years of relevant experience or 8 years of relevant experience in lieu of degree Recommended major(s): Accounting, Business Administration, Computer/Information Science, Economics, Finance, Information Technology, Mathematics, Statistics, Data Science

Requirements

Typically requires a Bachelors Degree
Typically requires 5-7 years of relevant experience or 8 years of relevant experience in lieu of degree
Requires in-depth knowledge and expertise in job field and working knowledge of related disciplines
Uses analytical thought to independently solve complex problems with minimal guidance and identify solutions
May lead team or department projects or work streams within broader projects
Acts as an advisor to management and key external stakeholders on job field related projects
Acts as a resource and guide for colleagues with less experience
Uses experience to contribute to standards in which others will operate
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
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

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 and Cognos Framework Design
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
Support the development of strategy for associated BI products, models, visualizations, governance, etc.