Position Title: ETL Developer,Ld

Employee Classification: Enterprise Progrmr Analyst,Ld

College/Division: Information Technology

Department: 450474-IT ANALYTICS AND DECISION SUPPORT

Internal or External Search: External - Open to all applicants

Location: Las Cruces

Offsite Location (if applicable):

Target Hourly/Salary Rate:  To commensurate with qualifications

Appointment Full-time Equivalency:  1.0

Exempt or Non-Exempt:  Exempt

Summary:  Join our dynamic team as an ETL Developer! We are seeking a talented individual to design, develop, and implement data extraction, transformation, and loading processes.

Classification Summary:
Provides team leadership in support of a university enterprise system. Plans assignments and trains subordinates in technical aspects of work. Analyzes and evaluates existing or proposed systems, devises computer programs, systems and procedures to process data. Prepares charts and diagrams to assist in problem analysis, and submits recommendations for solution. Prepares program specifications and diagrams, and develops coding logic flowcharts. Encodes, tests, debugs, and installs the operating programs and procedures.

Classification Standard Duties:
Under general supervision, plans, conducts and may supervise assignments. Reviews progress and evaluates results. May train Associate level personnel in technical complexities of assigned work. Recommends changes in procedures. Operates with substantial latitude for unreviewed action or decision. Reviews progress with management. Guides users in formulating requirements; advises on alternatives and on the implications of new or revised computer systems/applications technology. Analyzes user project proposals, identifies omissions and errors in requirements, and conducts feasibility studies; recommends optimum approach and develops system design for approved projects. Develops new and maintains existing complex systems and subsystems such as inventory control, payroll, or financial/cost analysis in which transactions are automatically processed through the full system of records; ensures reliability of cross-university applications. Informally arbitrates between system users when conflicts arise. Uses all phases of system analysis concepts, techniques, and methods; knowledge of available system software, computer equipment, and the regulations, structure, techniques, and management practices of one or more subject areas to design complex systems or subsystems. Reviews design, analysis, and code for quality and adherence to standards. Prepares and gives presentations to user management. Provides on-call support and problem resolution for computer applications. May serve as lead analyst in a design subgroup, directing and integrating the work of analysts, each responsible for several programs.Maintains current knowledge with respect to relevant state-of-the-art technology, equipment, and/or systems. Performs miscellaneous job-related duties as assigned.

Required Education, Experience, Certification/License, Equivalency
Required Education: Bachelors degree: Five (5) years of experience directly related to the standard duties as outlined;
Equivalency: Completion of a post-secondary degree or certificate may substitute for years of experience.; Required Certification/License:
Equivalency: Associates Degree: Completion of a two-year degree may count as two years of experience, with an additional seven years of relevant work experience. GED: with nine years of directly related work experience.

Knowledge, Skills and Abilities
KNOWLEDGE:Knowledge of current technological developments/trends in area of expertise. Comprehensive knowledge of multiple computing systems, applications, and architectures. In-depth knowledge of and leadership expertise in one or more computer languages and/or databases. Knowledge of computer flow charts and of programming logic and codes.; SKILLS:Conflict resolution and/or mediation skills.; ABILITIES:Ability to plan and manage significant technical projects. Ability to act independently and provide leadership at an advanced level of technical expertise. Ability to communicate technical information to non-technical personnel. Ability to assess and maintain quality of programming structure, design, and coding. Ability to foster a cooperative work environment. Ability to plan, design, coordinate installation, test, and modify complex systems and subsystems. Ability to specify and develop computer programs using a range of programming languages. Ability to determine complex computer problems and to coordinate hardware/software solutions.

Job Duties and Responsibilities
Responsible for designing, developing, and implementing data extraction, transformation, and loading processes.
Design and develop ETL processes using to extract data from various sources and load it into data warehouses.
Collaborate with business users and data analysts to understand data requirements.
Perform data profiling and analysis to ensure data quality and integrity.
Implement data transformation rules and business logic.
Monitor and optimize ETL processes for performance and stability.
Troubleshoot and resolve issues with ETL jobs.
Document ETL processes, data mappings, and data dictionaries.
Develop processes and procedures using ITIL methodologies to govern both infrastructure and application activities

Preferred Qualifications

Strong SQL skills and experience with relational databases
Knowledge of data warehousing concepts and methodologies
Experience with data modeling and data governance
Working knowledge of ITIL methodologies

Special Requirements of the Position

Department Contact:  Jasmine Gomez, 575-646-3685, jgomez12@nmsu.edu

Contingent Upon Funding: Contingent upon external funding

Bargaining Unit Eligibility: This is NOT a bargaining unit position with American Federation of State, County & Municipal Employees (AFSCME).

Standard Work Schedule: Standard (M-F, 8-5)

If Not a Standard Work Schedule: 

Working Conditions and Physical Effort

Environment: Work is normally performed in a typical interior/office work environment.

Physical Effort: No or very limited physical effort required.

Lifting Requirements: Requires handling of average-weight objects up to 10 pounds or some standing or walking.

Risk: No or very limited exposure to physical risk.