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, [email protected]
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 EffortEnvironment: 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.
Recruitment Summary
We are New Mexico’s land-grant institution and a comprehensive research university dedicated to teaching, research public service and outreach at all levels. NMSU is a welcoming community of talented faculty, staff and students who are working together to make a difference. We are a NASA Space Grant College, a Hispanic-serving institution (HSI), a minority-serving institution (MSI) and home to the first Honors College in New Mexico. We offer an accessible education that shapes bright futures.
NMSU provides learning opportunities to a diverse population of students and community members at four campuses, Cooperative Extension offices located in each of New Mexico’s 33 counties, 12 research and science centers, and through distance education.
NMSU Main Campus
Located in Las Cruces, NM, New Mexico State University's 900-acre main campus is located at the crossroads of I-10 and I-25 in the Southwestern United States. As a thriving center of higher education, deeply rooted in the regional tradition, its role as a comprehensive university is recognized throughout the state.