Sr. BI Specialist - Executive Reporting

Inside the Role

The Senior Business Intelligence Specialist will be responsible for driving the data analytics and domain strategy s 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.

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.

• 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 data availability beyond the U.S. in DWH, OPI/KPI metrics, and an understanding of the portability of U.S. 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, and 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. Develop and write 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.

• Stra…