Data Strategist

Summary of: Data Strategist

In this role, you will work with key members of CFSP’s business units, other members of the IT Department, and external partners to architect and mature all facets of CFSP’s data analytics program to increase commercial and operational insights across the organization. This will be accomplished through aggregation and standardization of disparate data sources, design of data models, use of state-of-the-art analytics techniques, and application of market leading analytics tools. Examples of this work include discovering new trends and anomalies in customer buying and behavior patterns, uncovering resource allocation and optimization opportunities, utilizing machine learning tools, and authoring predictive data models.

Keys to success include strong hands-on technical skills (database design, ETL principles, etc.), analytics knowledge, high levels of creativity and innovation, the ability to collaborate and communicate across the organization, good project management and time management skills, and the ability to simultaneously work on multiple projects of varying complexity.

Performance of duties with a positive attitude, in a cooperative manner, and promotion of a “team first” environment throughout CFSP is expected of all employees.

Essential Duties:

• Lead organizational change efforts that will advance the organization’s data driven decision making abilities, including creating roadmaps and organizational standards.
• Lead the functional / technical design and implementation of business intelligence and analytics frameworks using Microsoft technologies, such as Microsoft SQL Server, Microsoft Power BI, Microsoft SQL Server Integration Services, and Microsoft SQL Server Reporting Services.
• Work closely with functional areas to identify insight gaps and data / reporting related challenges and mentor functional area analysts in their use of Power BI, visualization approaches, and intermediate DAX code development.
• Develop solutions to complex data modeling use cases making use of Python, R, Azure Machine Learning, or other advanced methods.
• Define the organizational metadata strategy and roadmap. Lead organizational change efforts to enable implementation of data governance policies and data quality standards across the organization.
• Architect, develop, operate, and maintain ELT and ETL solutions focused on moving internal and external data sources from highly diverse data landscape into a centralized data warehouse, including real-time and batch integrations.
• Architect solutions to acquire semi / unstructured data sources, such as sensors, machine logs, click streams, etc.
• Stay current with vendor/product roadmaps and make recommendations for adoption.
• Assist with group / role creation and privileges in Power BI visualization tool.
• Evaluate progress / results of the analytics program and recommend opportunities for improvement.
• Manage project budgets and timelines to ensure projects are on track by providing transparency to projected spend and calendar events and effectively communicate project status to all team members.
• Maintain compliance with all company policies and procedures.
• Other duties as assigned.

Education Required:

• Bachelor’s Degree in the field of Computer Science, Information Systems, Engineering, or Business Administration. A Master’s degree is preferred.
• Certifications in Microsoft Data Platform, Data Science, R and/or Python, and relevant Microsoft technologies are strongly desired.

Skills Required:

The type of skills and experience required to effectively perform the essential functions and responsibilities of this position are:

• At least five years hands-on experience with SQL Server and database design.
• At least five years hands-on experience writing advanced SQL queries.
• At least five years hands-on experience with software design, implementation, and testing.
• At least five years hands-on experience with dimensional data modeling and schema design in data warehouses.
• At least five years hands-on experience with custom or structured ETL design, implementation, and maintenance.
• At least five years hands-on experience with front end analytics and visualization tools, data query platforms, reports, dashboards, etc.
• At least one year hands-on experience writing DAX in Microsoft Power BI, Excel PowerPivot, or Microsoft SQL Server Tabular Models.
• Demonstrated problem solving skills, business acumen, and ability to develop actionable insights from data.
• Excellent communication skills, with the ability to effectively convey analytic insights to both IT and business audiences.
• Ability to collaborate effectively in a team environment, with all levels of work colleagues, management, and external parties.
• Understanding of sales, channel, and eCommerce buying processes.
• Understanding of major business systems such as ERP systems, CRM systems, HRIS systems, warehouse management systems, and manufacturing / shop floor systems.
• Ability to use Microsoft Office tools, especially Microsoft Excel.
• Demonstrated knowledge and experience with project management methodologies.
• Highly self motivated and directed with a high attention to detail.
• Ability to effectively prioritize and execute tasks in a fast-paced environment.
• Willingness and ability to work extended hours when necessary to meet deadlines.

Skills Preferred:

• Experience designing and creating OLAP cubes with Microsoft SQL Server Analysis Services Tabular Models.
• Experience creating reports in SQL Server Reporting Services.
• Experience training end users in-person and online.
• Experience with other modern BI tools and platforms.

Travel Requirements:

• Up to 10% travel to training events or in support of multiple projects and corporate initiatives

Job Type: Full-time

Experience:

• SQL Server and Database Design: 5 years (Required)
• Software design, implementation, and testing: 5 years (Required)
• dimensional modeling and schema design in data warehouses: 5 years (Required)

Education:

• Bachelor’s (Required)