Senior Product Specialist 1

Short Description:
The Senior Product Specialist (SPRS) is the leading expert for a technical development or execution environment product or set of products.

Complete Description:
The State of Delaware, Department of Technology and Information is seeking a Senior Product Specialist (SPRS) to be an expert in the Microsoft BI stack of products (PowerBI, SSRS, SSAS, SSIS) to assist the agency with rolling out an enterprise data analytics program. This position will assist with the administration of this stack of Microsoft tools and provide technical assistance to developers utilizing these tools. The position will also be used to work with end users on gathering business requirements and creating dashboards and reports to meet those requirements.

Please note that this position requires the resource to have a strong prior experience with the DW Side as well as ETL and reporting. A Reporting expert will not suffice.

ESSENTIAL DUTIES and RESPONSIBILITIES:
1. Works with business partners to plan and implement enhancements to the existing BI infrastructure, Report Server and the Data Gateway.
2. Serve as subject matter expert in data warehousing and BI solution design, development and implementation.
3. Designs, develops and maintains data models, PowerBI datasets, ETL and other reporting infrastructure components for the Data Gateway, BI and reporting environments.
4. Creates, enhances, and performance tunes reports to support BI and Data Gateway administration.
5. Responsible for the administration, maintenance, operational support, configuration management, and manages security for Enterprise BI tools.
6. Serves as subject matter expert in BI tools working on problems of diverse scope and complexity.
7. Creates, enhances, and performance tunes reports.
8. Provides training and support to enterprise reporting community.
9. Accountable for maintaining the security and confidentiality of any proprietary or sensitive information or data in any medium regarding the State, employees of the State and customers/citizens. Accessing or disclosing such information or data must be deemed necessary for the performance of one's job responsibilities and must be authorized by the employee's supervisor.
10. Responsible for following the defined SDLC, ensuring solution development adheres to the process controls.
11. Availability to work after hours and/or weekends and on-call, as specified by supervisor.

REQUIRED SKILLS and COMPETENCIES:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

1. Bachelor's degree with 5-8 years of related experience, or an equivalent combination of education and experience Do we want to specify a specific field/degree?
2. Strong understanding of BI best practices
3. Strong experience in business analysis, systems analysis, and data analysis in transactional and data warehousing environments
4. Advanced knowledge of and experience with data warehousing and Business Intelligence tools.
5. Strong experience working with SQL and Oracle
6. Strong experience with query languages such as T-SQL and DAX
7. Some experience with Python preferred
8. Strong experience working with integration tools (SSIS, DataStage etc.)
9. Strong report writing experience using BI tools (preferably Power BI).
10. Experience with the entire Microsoft BI stack preferred (Power BI, SSRS, SSAS, SSIS.)
11. Knowledge of superior customer service standards and practices
12. Ability to work independently to determine methods and procedures on new assignments
13. Receives no instruction on routine work, general instructions on new assignments
Skills:

Skill
Required /Desired
Amount
of Experience
 
Current and prior Business Intelligence-related development experience
Required
5
Years
Strong understanding of Business Intelligence best practices
Required
5
Years
Current and prior experience involving data management AND transformation
Required
5
Years
Advanced experience with data warehousing and Business Intelligence tools.
Required
5
Years
Strong experience working with SQL Server 2012 and above in a Data Warehouse environment
Required
5
Years
Current and prior report writing experience using BI tools
Required
3
Years
Experience creating data models
Required
2
Years
Experience providing training and support to end users
Required
3
Years
Experience working with customers to define business requirements and design a solution to meet those requirements
Required
5
Years
Strong experience with query languages such as T-SQL and DAX
Highly desired
3
Years
Strong experience working with Oracle 10g and above in a Data Warehouse environment
Highly desired
3
Years
Experience working with integration tools (ie. SSIS, DataStage, etc.)
Highly desired
3
Years
Experience with the entire Microsoft BI stack (PowerBI, SSRS, SSAS, SSIS)
Highly desired
3
Years
MS PowerBI Development and integration
Highly desired
2
Years
Prior experience with one or more of the following (PowerBI, Cognos, Tableau)
Highly desired
2
Years
Experience programming in Python
Desired
2
Years
Expereince with Data Modeling tools (ie. Erwin/Powerdesigner)
Desired
1
Years