RICHMOND, VA, USA
9 days ago
DW Architect
Job Seekers, Please send resumes to resumes@hireitpeople.com Complete 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 ofQuality Management is seeking a skilled professional to provide expertise in many areas of datamanagement including but not limited to data warehouse reporting , data analysis, dataintegration, and data warehousing.
Provide these services in support of DBHDS and external agency goals such as programperformance, process compliance, data quality, and data governance. Provide expertise withSQL-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 andSSRS reports; provides expert level data and process analyses data for data warehouse andsystems integration projects; provides expertise in the use of business intelligence tools such asMicrosoft Analysis Services and Microsoft Reporting Services; and works closely with DataArchitect and ETL staff to ensure proper design and compliance with database and developmentstandards.
QUALIFICATIONS: Extensive experience with applications using both relational andmultidimensional design models. Extensive experience with Transact SQL including storedprocedures 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: SQLServer, SSRS, SSAS, and exposure to SSIS. Experience with a variety of reporting toolsincluding 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 structuredenvironment, to deliver quality systems within a management-approved schedule, and to work ontechnical teams as required.
College degree in Computer Science, Information Systems or related field or equivalent trainingand 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 severallines of business including DOJ, CSB, Licensing, and REACH reporting. Other areas may beassigned as needed. Provide training to new users for SSRS report development and SQL basics. 

SkillRequired / DesiredAmountof ExperienceExtensive experience with the Microsoft data architecture and reporting tools required: SQL Server, SSRS, SSAS, and exposure to SSIS.Required3YearsExperience with a variety of reporting tools including SSRS, Tableau, Business Objects, Crystal Reports, and others.Required3YearsExtensive experience with Transact SQL including stored procedures and user defined functionsRequired5Years
Confirm your E-mail: Send Email