Data Warehouse Analyst

company banner
Robert Half Technology
.Net, Analysis, Analyst, Architecture, Business Intelligence, Data Analysis, Data Architecture, Database, Database Administration, Data Modeling, Data Warehouse, Development, Manager, Modeling, OLAP, Programmer, Project, Project Manager, SDLC, Security, Shell Script, Shell Scripting, SQL, SQL Server, Unix
C2H Independent, C2H W2
$57.00 to $66.00 per hour
Telecommuting not available Travel not required

Job Description

r. Data Warehouse Specialist - Job Description

Essential Duties and Responsibilities Include:

1. Develop software solutions for safety and security applications through periodic software releases utilizing Microsoft technologies such as SQL Server, SharePoint, .Net Framework, Reporting Services (SSRS), SSIS and ETL.

2. Perform SQL Server database administration in redundant infrastructure, data analysis, develop relational data models and OLAP models by safety subject areas to support reporting and business intelligence needs.

3. Provide database administration production support as needed.

4. Perform other duties as directed by the Project Manager and Business Owners.

5. Development experience in MS SharePoint version 2010 and 2013 preferred.

6. Solid understanding of Software Development Life Cycle (SDLC)

7. Ability to design and size SQL server databases and data warehouses or supporting development, test and production regions.

8. Ability to install, configure SQL server database in clustered/highly available environment.

9. Hands on experience of using SQL server native ETL tool and non SQL server ETL tool.

10. Hands on experience in Report design/development in Data Warehousing/Business Intelligence implementations.

11. Strong knowledge of one or more Business Intelligence toolsets, preferably MOLAP (Microsoft SSRS etc.).

12. Hands on experience in relational and non-relational data modeling.

13. Strong knowledge of MS SQL Server, SSAS, and SSRS.

14. Data architecture, data modeling, Complex ETL mappings, design and development experience using SQL and SSIS.

15. Experience with ETL development in database environments (SQL Server)

16. Create best practices for data loading and extraction and query optimization.

17. Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers.

18. Design, build, and maintain UNIX shell script processes.

Requirements and Qualifications:

Bachelor's degree in a Technical discipline or equivalent. Master's degree preferred.

A minimum of 8 years of experience as a Data Warehousing Programmer using SQL Server.

Proven experience with T-SQL and UNIX shell scripting.

HealthCare experience.

Tableau experience preferred.

Strong interpersonal skills and comfort interacting with and briefing senior leaders and specialists.

Strong written and oral communications.

Must be a team player who can contribute to team success.

Job Requirements

ETL - Extract Transform Load, SQL - Structured Query Language, SQL/DS - Structured Query Lang/Data Sys

Posted By

Job #: 04510-0010197007

WASHINGTON, DC, 20003-3302


Company Information

Robert Half Technology is committed to the industries we serve and to assisting them with their IT hiring needs. Our connections and strategic partners within the technology industry are second to none. We are proud members of the Microsoft Partner Network with gold and silver competencies, we have gold membership in the Oracle Partner Network, and we have exclusive relationships with The Wall Street Journal, HDI and the Association of IT Professionals. For job seekers, these connections can lead to top-rate opportunities within the IT recruitment arena. Our collaborative relationships around the world translate into support for all kinds of careers in IT, including IT support, software engineering, analytics and many other information technology areas of expertise.
Dice Id : rhalfint
Position Id : 04510-0010197007

Similar Positions at Robert Half Technology

Data Warehouse Developer
  • Baltimore, MD
  • 2 days ago
Data Reporting Analyst
  • Washington, DC
  • 2 days ago
Data Warehouse Developer
  • Richmond, VA
  • 2 days ago
Dynamics AX Business Analyst
  • Arlington, VA
  • 2 days ago
Business Intelligence Analyst
  • Hanover, MD
  • 2 days ago
Data Systems Analyst
  • Baltimore, MD
  • 2 days ago
Data Warehouse Analyst
  • Grand Rapids, MI
  • 2 days ago
Data Warehouse Analyst
  • Oklahoma City, OK
  • 2 days ago
Business Analyst
  • Hunt Valley, MD
  • 2 days ago
Business Intelligence (BI) Consultant
  • Baltimore, MD
  • 2 days ago