Senior Programmer Analyst

BCforward; Las Vegas (NV); On-site; USD 92,299; Full time

Job summary

A leading IT staffing firm is seeking a Data Warehouse Programmer to join their team in Las Vegas, NV. The successful candidate will design and support applications for the Enterprise Data Warehouse while focusing on ETL processes to enhance data integrity and performance. They will need 6+ years of programming experience, expertise in SQL, and familiarity with ETL tools like IBM DataStage. This role offers an hourly pay of $67 and the chance to contribute to Business Intelligence applications.

Qualifications

• 6+ years work experience as a database programmer or equivalent education.
• 3+ years work experience with ETL tools such as IBM DataStage.
• 2+ years work experience in architecting data warehouse solutions.
• Expert level SQL expertise required.
• General knowledge of BI and Data Warehousing disciplines.

Responsibilities

• Design, test, maintain, and support applications on the EDW.
• Focus on developing and maintaining EDW ETL processes.
• Implement best practices for data integrity and performance.
• Work with project teams to ensure optimal data flow.

Skills

Database programming

ETL tools (IBM DataStage)

SQL expertise

Unix Operating System

Education

Master’s Degree in Information Systems or Computer Science

Tools

Teradata

KornShell Scripting

Hadoop

Control-M

MicroStrategy

Cognos

Tableau

Job description

About BCforwardBCforward began as an IT business solutions and staffing firm. Founded in 1998, BCforward has grown with our customers’ needs into a full service personnel solutions organization. BCforward’s headquarters are in Indianapolis, Indiana and also operates delivery centers in 17 locations in North America as well as Hyderabad, India and Puerto Rico. We are currently the largest consulting firm and largest MBE certified firm headquartered in Indiana. With 14+ years of uninterrupted growth, the addition of two brands (Stafforward and PMforward) and a team of more than 1400 resources our teams deliver services for multiple industries from both public and private sectors. BCforward’s team of dedicated staffing professionals has placed thousands of talented people over the past decade, with retention rates that are consistently higher than the industry average.

Job Description

Date: 11/07/2016 - 05/06/2017

Location: Las Vegas, NV

Pay: $67/hr

Role Summary

The Data Warehouse Programmer is a key member of the Enterprise Data Warehouse (EDW) team responsible for designing, testing, maintaining and supporting applications on EDW and validating source system data loads. This position will have a focus on developing, maintaining, and supporting EDW ETL processes. This position will also focus on implementing best practices and procedures to ensure improved performance of data loads, integrity of data movement within the organization, and enhanced data architecture to support Business Intelligence (BI) applications and analytics. In addition, this position will work with various project teams to ensure optimal data flow through systems, designing flexible and supportable data models, and contributing to the overall data architecture of EDW. This role works directly with other IT application groups and end-users to analyze, troubleshoot, test and enhance applications.

Mandatory Qualifications

• 6+ years work experience in the role of database programmer OR 3+ years work experience in the role of database programmer plus Master’s Degree in Information Systems or Computer Science
• 3+ years work experience with ETL tools such as IBM DataStage is required
• 2+ years work experience with architecting data warehouse solutions
• Experience with Unix Operating System is required
• Expert level expertise with Structured Query Language (SQL) is required
• General knowledge of the BI and Data Warehousing disciplines including Physical and Logical Database Modeling, as well as OLAP, ROLAP and MOLAP concepts is required

Desired Qualifications

• Technical experience with Teradata (including Teradata-specific training) and Teradata Utilities is strongly preferred
• Experience with KornShell Scripting preferred
• Experience with scheduling tools such as Control-M is preferred
• Experience with Hadoop is preferred
• Experience with Active Data Warehousing, trickle feeds and the TIBCO toolset is preferred
• Experience with MicroStrategy, Cognos, Tableau, or other Business Intelligence tools is preferred