Job Descriptions

Job purpose/summary

This role serves as a data expert, working with a set of 3-4 areas of the organization to identify opportunities to make data-driven decisions and improve performance. This role would have an immediate business impact and would provide insights based on research and analysis to aid key business decisions across different areas. This role will be a key member of functional teams and will focus on areas where there is a significant reliance on data to drive business performance.

Duties and responsibilities

The ideal candidate will be responsible for:

• Supporting business analysts, technical teams, and developers to define the data requirements and data structure for business intelligence solutions
• Implementing strategic performance marketing solutions that use best of breed analytical and big data technologies to build consumer insight and driving additional transactions through digital channels
• Building standard tools such as data quality monitors and customer exploration tools as well as more client-specific prototypical and decision support apps
• Determining business information needs and working towards fulfilling those needs by gathering data from internal or external sources
• Providing reporting analysis, programming, and problem resolution to facilitate reporting process improvement of complex systems
• Assisting other team members with SQL queries necessary to extract, transforming, or load data as part of integration and analysis development
• Leading an exciting data environment to support data analysts and data scientists from a multitude of different business groups
• Gathering business reporting requirements to produce useful solutions
• Producing job aids and other materials to be utilized by various departments to assist in managing and operating SQL reporting tools
• Collaboration with business leaders to design new analytical tools

Competencies

The ideal candidate will demonstrate competencies in the following areas:

• A deep understanding of business goals, metrics, processes, systems, and data
• Having a strong understanding of models
• A solid understanding of the target operating model and the current and future connectivity, data flow, and organizational design
• Analyzing complex business problems and issues using data from internal and external sources to provide insight to decision-makers
• Participating in business and data analysis activities with cross-functional teams to gather required reporting and dashboard requirements
• Analyzing complex business problems and issues using data from internal and external sources to provide insight to analysts and decision-makers
• IT Management
• Business Process Development
• IT Service Management
• Process Management
• Business Process Improvement
• IT Project Management
• Product information management
• Time Management
• Quality Management System
• Change Management
• Data Management
• Business Process Changes
• Technical Management
• Information Management
• Human Resource Management

Tools and technologies

• Web-based Software
• Embedded Services
• Microsoft SQL Server
• SQL Server Management Studio
• SQL Server Master Data Services
• SQL Server Analysis Services
• SQL Server Integration Services
• Microsoft Team Foundation Server
• Microsoft Applications
• Microsoft Access
• Oracle SQL Developer
• Oracle Enterprise Manager
• Microsoft Technologies
• Microsoft Project
• Microsoft Excel
• Microsoft Active Directory
• Oracle Database

Reporting relationship

To be completed by the user of this job description as appropriate

Direct reports (if appropriate)

To be completed by the user of this job description as appropriate

Qualifications

Education

To be completed by the user of this job description as appropriate

Certifications

To be completed by the user of this job description as appropriate

Other relevant qualifications

To be completed by the user of this job description as appropriate

Key Attributes

To be completed by the user of this job description as appropriate

Experience

To be completed by the user of this job description as appropriate

Working conditions (if required)

If the job requires a person to work in special working conditions this should be stated in the job description. Special working conditions cover a range of circumstances from regular evening and weekend work, shift work, working outdoors, working with challenging clients, and so forth.

Physical requirements (if appropriate)

If the job is physically demanding, this should be stated in the job description. A physically demanding job is one where the incumbent is required to stand for extended periods, lift heavy objects regularly, do repetitive tasks with few breaks, and so forth.