Data Warehouse Architect
VTechSolution1
Posted: March 24, 2017
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Data Warehouse Architect
Required Skills
Job Description
vTech can help you avoid the daunting task of writing and posting job offers, shifting through resumes and laboring through the lengthy interview process. Our Staffing solutions will allow you to elude those tasks and place topnotch, high-caliber professionals in the position you need to fill.
We use our expertise, knowledge, and global resources to deliver top-quality candidates and tailor our IT and Non-IT recruitment services to your needs. This allows us to deliver the required results in a timely manner that meets your schedule at a substantially reduced cost.
We pride ourselves for having one of the fastest growth rate and also the lowest turnover rates in the industry just 2.5 percent annually. We focus on the training and retaining qualified professionals with high personal and work ethics. With the help of our extensive database of internal candidates and CATS applicants tracking system, we can provide quality resources within the limited time frame.
We have also successfully placed hundreds of candidates in the areas related to Information Technology, Engineering, professional, Scientific & Clinical, etc. for both our commercial and government clients.
Source: A recruiter sources candidates from various sources; the search starts from our proprietary database. Using advanced sourcing methods like social media, professional networking media, internal, and 3rd party job boards, we identify qualified candidates.
Validate: A recruiter validates the candidates’ experience and skill sets against our client’s position.
Initial Screening: Based on the position and the client’s work culture, the recruiter uses initial screening questions to determine the most suitable candidates.
Submit: the recruiter will submit to the technical team qualified candidates who have passed the initial screening.
Technical Screening: The technical team then prepares a matrix of the particular requirements and required experience for the position and using a list of questions and the results, re-validates the candidates’ technical skills.
Background Check: Administrative personnel will provide a detailed background check, as required, per client agreement.
On board: On successfully completing the above steps, the candidates are welcomed on board and assisted to ensure a smooth integration at the client’s location.
• Client 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 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.
Required Skills:
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.
Extensive experience with Transact SQL including stored procedures and user defined functions
All your information will be kept confidential according to EEO guidelines.