Job Description :
Job Title: Senior Programmer Analyst
Location: Las Vegas, NV
Duration: 6 Months Contract to Hire

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.

The primary responsibility of this position is to provide expertise in the areas of system design and development, standardization, and support to solve complex business problems, primarily in the Enterprise Data Warehouse environment which is on a Teradata platform. The programmer will support multiple interfaces from diverse in-house developed to vendor-supplied applications. The position will focus on the day to day aspects of supporting our Teradata data warehouse and ETL jobs.

Responsibilities include, but may not be limited to the following:
Take part in an on-call rotation, providing 24-7 support for the Data Warehouse and applications which run in the environment.
Code, test, deploy, and maintain ETL processes using Teradata Utilities, IBM DataStage, Data Mover, and Control-M.
Demonstrate growth in technical leadership skills by influencing product interface direction, managing standards, supporting other developers with technical questions, and approving system modifications.
Formulate systems scope and objectives by devising procedures to solve technical problems using information systems.
Perform complex system technical design work. Provide strategic technical direction.
Prepare detailed specifications from which programmers write, design, code, test and debug the most complex programs.
Guide the efforts of co-workers and contract personnel in accomplishing assigned tasks.
Demonstrate problem-solving skills by defining and presenting technical systems solutions for identified technical issues.
Provide suggestions for improving the overall BI architecture. Work with the business users to ensure that the BI solution is improving analytical capabilities.
Assist with tasks such as application upgrades, proof of concepts, and software selection.
Document activities from design to completion to assist future analysts in understanding work solutions. Create data models, data/system flow documentation, design documents, and test documents.
Perform technical reviews with Project Leaders to maintain consistent technical direction and minimize system impact on projects.
Take complex technical ideas and bring them to a high-level to encourage understanding at all levels.
Deliver a complete solution to ensure thorough understanding of the system (documentation, procedures, training, escalation, error process, etc.
Proactively escalates to the next level of management and provides recommendation from available options.
Engage others with related code/products/etc to work together to understand root cause, ripple effects, and an integrated solution.
Provide input into capacity plans; able to assist with load tests.
Write efficient, reusable and stable code for complex application logic.
Perform complex code reviews.
Set high standards of performance for others. Hold others to the standards and help them achieve these standards, if necessary.
Clearly define expected outcome for the initiative and organization.

6 - 8 years programming experience preferred, with an additional two years of project leadership, systems design/analysis and user management. Must be competent in all aspects of programming and design with minimal direction.

Skills Mandatory:
6+ years work experience in job as database programmer OR 3+ years work experience in job as 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

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

Rarely requires guidance, even on most complex systems analysis.

Bachelor’s degree in Information Systems, Computer Science or technical training equivalent