Dev/Ops Consultant

Data Warehouse Consultants is seeking a Consultant for our Dev/Ops team that is responsible for executing daily, weekly and monthly processes. Data Warehouse Consultants operates many automated processes for our clients. This lead in this role will be responsible for setting and maintaining the operations schedule and scheduling or executing the required processes. The successful candidate will have an eye for making improvements to those processes and implementing new methods of automation. Our consultants add value by continuing to improve the processes we maintain and by achieving a high level of process automation.

Responsibilities

– Develop and maintain multiple operational process schedules
– Coordinate with the development team to help set priorities and report issues
– Provide direction to other dev/ops personnel on assignments and responsibilities
– Help identify optimal projects for improving and automating existing processes
– Identify, diagnose and correct typical operational errors
– Create new processes to improve ETL automation when necessary

Required Skills

– Project experience running production operational processes in a database environment
– Strong written and oral communication skills
– Self-motivation and the willingness to set goals and deadlines
– Willingness to research and learn new technologies as the situation requires
– Ability to work well in a team environment and stay self-motivated on several assignments
– Prior experience working with databases and SQL

Preferred Skills

– Project experience with Oracle
– Experience with enterprise scheduling tools
– 4-year Bachelor’s degree

To Apply
Email resume and salary requirements. Please reference “Dev/Ops Consultant” in the subject line.

Please submit resume and cover letter to info@dwconsultants.com.

 

Senior Consultant

Job Status: Full Time/Direct Hire

Location: Pittsburgh, PA

Amount of Travel: Position is local to the Pittsburgh Area

Data Warehouse Consultants (DWC), LLC is a consulting firm based in Pittsburgh, Pennsylvania, focusing on business intelligence and data warehouse projects. We provide services in strategy, design, architecture, development and implementation of data warehouse and other business intelligence solutions. Our superior expertise on a focused market segment allows us to provide well-rounded professionals for business intelligence needs in any industry.

DWC is currently seeking to fill a senior consultant position. The position requires a strong leader who is comfortable working directly with the client throughout the SDLC in a technical environment. Applicants must have previous consulting experience. This is an excellent position for a Big 4 consultant who is looking to make a stable home in Pittsburgh.

The successful candidate will:

  • Work directly with the client to define project requirements
  • Collaborate with DWC designers in order to design the database, programs, and processes based on the client requirements
  • Participate in, and manage the development, testing, and implementation of programs and processes
  • Supervise the project team in order to deliver a timely and quality product

Position Requirements:

  • 2-4 years of project experience working in a technical, database driven environment
  • A minimum of 2 years consulting experience (Big 4 consulting experience is desired)
  • Database expertise (Oracle / SQL Server)
  • Experience reading and writing SQL Queries is desired
  • Experience leading requirements sessions
  • Manage a development team to implement client solutions
  • Interview and observe client staff in order to evaluate business processes
  • Determine computer hardware / software requirements to support the system architecture
  • Working knowledge of data warehousing and dimensional modeling concepts
  • Project experience writing java-based applications
  • Project experience working with Oracle and writing Oracle PL/SQL
  • Experience with Hadoop and HDFS-related toolsets

Education Requirements:

  • Bachelor’s or Master’s Degree

To Apply: Please submit resume and cover letter with your salary requirements via email to info@dwconsultants.com.