Job Seekers, Please send resumes to resumes@hireitpeople.comComplete Description: *local candidates strongly preferred
*mgr will ONLY conduct in-person interviews, NO Skype, NO exceptions
The Department of Behavioral Health and Developmental Services’ Office of
Quality Management is seeking a skilled professional to provide expertise in many areas of data
management including but not limited to data warehouse reporting , data analysis, data
integration, and data warehousing.
Provide these services in support of DBHDS and external agency goals such as program
performance, process compliance, data quality, and data governance. Provide expertise with
SQL-Server Reporting Services (SSRS), SQL-Server Analytical Services (SSAS), and Tableau.
Duties include, but are not limited to: Designs, develops, and delivers SSAS reporting cubes and
SSRS reports; provides expert level data and process analyses data for data warehouse and
systems integration projects; provides expertise in the use of business intelligence tools such as
Microsoft Analysis Services and Microsoft Reporting Services; and works closely with Data
Architect and ETL staff to ensure proper design and compliance with database and development
standards.
QUALIFICATIONS: Extensive experience with applications using both relational and
multidimensional design models. Extensive experience with Transact SQL including stored
procedures and user defined functions. Experience working with programming languages (SQL,
PL/SQL, .NET, VBscript, MDX).
Extensive experience with the Microsoft data architecture and reporting tools required: SQL
Server, SSRS, SSAS, and exposure to SSIS. Experience with a variety of reporting tools
including SSRS, Tableau, Business Objects, Crystal Reports, and others.
Considerable experience in performing data analyses in project as well as ad hoc settings.
Demonstrate excellent written and verbal communication skills. Ability to work in a structured
environment, to deliver quality systems within a management-approved schedule, and to work on
technical teams as required.
College degree in Computer Science, Information Systems or related field or equivalent training
and experience. Working knowledge of n-tier application development tools and techniques
(MS Framework, .NET, VB .NET, Python, etc.) is preferred.
DELIVERABLES: Developing several analytical cubes and associated reporting for several
lines of business including DOJ, CSB, Licensing, and REACH reporting. Other areas may be
assigned as needed. Provide training to new users for SSRS report development and SQL basics.
Skill | Required / Desired | Amount | of Experience |
Extensive experience with the Microsoft data architecture and reporting tools required: SQL Server, SSRS, SSAS, and exposure to SSIS. | Required | 3 | Years |
Experience with a variety of reporting tools including SSRS, Tableau, Business Objects, Crystal Reports, and others. | Required | 3 | Years |
Extensive experience with Transact SQL including stored procedures and user defined functions | Required | 5 | Years |
