ETL Programmer
FUNCTIONAL PURPOSE:
Develops and maintains Extract Transfer and Load (ETL) processes to support effective and efficient data management. Works with structured and unstructured data to prepare for optimized use and analysis.
DUTIES AND RESPONSIBILITIES:
1. Manages ETL activities that cross organizational lines. Interfaces with various teams in drawing insight from data for use across the organization.
2. Develops data warehouse models and prepares documentation for metadata integration into systems.
3. Interacts with analysts and internal customers to understand business processes and requirements.
4. Analyze and translate functional specifications and business requirements into technical specifications to incorporate into design specifications.
5. Document analytic information assets and relationships among those assets.
6. Develop data processing methodologies and draft scripts to ensure accuracy and integrity of data while maintaining an effective project life cycle on all ETL processes.
7. Develop and perform tests on all ETL processes to ensure update within required schedules and according to business requirements.
8. Analyze data and design data mapping techniques for data models in systems working with large data volumes across USPS functional areas as well as data from external sources.
9. Coordinate with Analytic Engineers to implement ETL procedures for new projects and maintain effective awareness of all production activities according to required standards.
10. Perform root cause analysis on all processes to resolve all production issues and inefficiencies and validate data to coordinate ongoing iterative development.
SUPERVISION:
Business Project Leader
REQUIREMENTS:
- Skill optimizing with ETL processes and databases.
- Skill using Oracle, Teradata, and/or SAP data sources sufficient to develop data warehouse models, draft scripts, analyze data and design data mapping techniques.
- Skill writing SQL statements to select/update queries, extracting data from database and use stored procedures with complex data sets.
- Ability to provide support for quality assurance and quality control testing.
- Ability to manage projects including planning, tracking/oversight, scheduling tasks, risk identification and mitigation, project administration and status reporting.
- Knowledge of relational databases and familiarity with transactional program languages, extract programs, and/or datamarts at a level sufficient to mine, correlate, and analyze data.
- Knowledge of dimensional and relational data modeling, business intelligence, data visualization and data warehousing concepts and systems sufficient to design actionable data analytic solutions.
- Ability to analyze complex data sets to support actionable business intelligence and decision making.
*Domicile may be considered*
*Reimbursement of relocation expenses will NOT be considered.*
**This position requires a NACI clearance. This process can take up to 6 weeks from the date the offer letter is returned.**
This is a two-step application process requiring you to create a profile and submit an application for the position you are applying for.
You will receive two email confirmations:
1. An email confirming your profile is complete.
2. After submitting your application you will receive a second email confirming your application has been successfully submitted.
For information, please contact Cyril Johnson at Talent@usps.gov