Data Warehouse Architecture Consultant

Job Description

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  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.



Extensive experience with the Microsoft data architecture and reporting tools required:
SQL Server, SSRS, SSAS, and exposure to SSIS. (3 years)

Experience with a variety of reporting tools including SSRS, Tableau, Business Objects,Crystal Reports, and others. (3 years)

Extensive experience with Transact SQL including stored procedures and user defined functions (5 years)

Additional Information

All your information will be kept confidential according to EEO guidelines.