Data Warehouse Specialist

The Mission Matters

Your skills and experience could be mission critical for our Powder River Industries, LLC team supporting the Federal Government in their mission to protect and defend our nation, and transform the way government agencies manage information and improve responsiveness to their customers. As a member of our inclusive team, you’ll gain valuable career-enhancing experience as we support the design, development, testing, implementation, training, and maintenance of our federal government’s critical systems. 

 

Apply today to become mission critical and help our nation meet the growing need for IT security, improved infrastructure, big data, and advanced analytics.

Job Description

We are currently seeking a motivated, career and customer oriented SQL Reports Specialist/DBA to begin an exciting and challenging career with Powder River Industries, LLC.

Duties:

Need a candidate that is very strong with SQL reporting, analyzing and troubleshooting existing jobs and packages. Strong background in SSRS and SSIS. Needs to have DBA experience but strong reporting and troubleshooting are essential. Thinks on their feet and out of the box.

  • Improve the efficiency of existing queries in SSIS packages

  • Troubleshoot existing data warehouse issues and come up with solutions

  • Experience in designing, developing and maintaining SSRS reports

  • Knowledge and understanding of relational databases

  • Familiarity with various database design and architectural patterns

  • Strong knowledge of Transact SQL

  • Strong communication, critical-thinking, and problem-solving skills

  • Design and implement data warehouses using SSIS

  • Strong Critical thinking skills are a must

  • Translate business rules into technical solutions

  • Design, build, and maintain efficient, reusable, and reliable SQL code

  • Integrating SharePoint with SQL Server Reporting Service (SSRS)

  • Identify bottlenecks and bugs, devise solutions to mitigate these issues

  • Designing, developing and maintaining SSRS reports

  • Assist developers with complex query and tuning

  • Design and develop data warehouse structure

  • Maintain data warehouse

  • Work as part of a cross functional team of developers

  • Create and maintain documentation

 

Required:

 

  • Bachelor's Degree – IT, Bus, Engr; Minimum Required Years of Experience 10 of experience

  • Must be US Citizen

  • Extensive knowledge of SQL 14

  • Extensive experience with trouble shooting SQL Queries, Stored procedures, and SSIS packages

  • SQL Server Reporting Service (SSRS)

  • Knowledge of Web Services – nice to have

  • Net (Proficient)

  • Database Administration

  • Understanding of fundamental database design principles for building scalable applications

  • Bacheor's degree and 10 years of related work experience

 

 

Does the mission matter to you?

Powder River Industries is an Equal Opportunity Employer - Minorities/Females/ Veterans/Individuals with Disabilities/ Sexual Orientation/Gender Identity

Powder River Industries

1938 E Harney St Suite 216, Laramie, WY 82072, USA

(307) 314-2431

©2019 by Powder River Industries LLC. All rights reserved. Website created by Annie Warnock