IT Specialist (Data Ingestion & Transformation Engineer)

This IT Specialist (Data Ingestion & Transformation Engineer) position is with Internal Revenue Service (Department of the Treasury) in Glendale, AZ. WHAT IS Information Technology - Data & Platform Engineering? A description of the business units can be found at: https://www.jobs.irs.gov/about/who/business-divisions Position(s) are to be filled in following area(s): IT - Data and Platform Engineering - Consider each location carefully when applying. You will be limited to 1 location choice. If you are selected for a location, that location will be your official post of duty. Key duties: • REVIEW THE ADDITIONAL INFORMATION BELOW FOR FURTHER DETAILS The following are the duties of this position at the full working level. If this vacancy includes more than one grade and you are selected at a lower grade level, you will have the opportunity to learn to perform these duties and receive training to help you grow in this position. Design and build data pipelines: Create scalable and reliable data pipelines using tools like Apache Kafka, Apache NiFi, and cloud-based services (e.g., AWS Glue). Implement and maintain the Extract, Transform, and Load (or Load and Transform) processes to move data from source to target systems. Develops ETL pipelines in Databricks and Python. Optimizes data ingestion from multiple source systems. Design, develop and operate systems and features relating to data ingestion and transformation. Data transformation and cleansing: Apply advanced techniques like parsing, cleansing, normalization, and transformation to ensure data quality and consistency. Monitor and troubleshoot data pipelines to identify and fix inefficiencies, optimize performance, and ensure scalability. Designs transformation logic to ensure compliance with data model standards. Data validation and quality: Conduct data validation and testing to ensure accuracy, consistency, and compliance with data governance policies. Monitors data flow performance and scalability across cloud environments. Stay up to date with emerging technologies and methodologies to enhance data processing capabilities. Cross-functional collaboration: Working with data analysts, engineers, and scientists to understand data requirements and translate them into technical solutions; as well as to ensure the best experience for our customers. Document data processing workflows, best practices, and technical specifications for knowledge sharing and maintainability. Provide considerate and timely review of your peers' design proposals and pull requests. Qualifications: Federal experience is not required. Experience may have been gained in the public sector, private sector or through Volunteer Service. One year of experience refers to full-time work; part-timework is considered on a prorated basis. To ensure full credit for your work experience, please indicate dates of employment by month/day/year, and indicate number of hours worked per week, on your resume. You must meet the following requirements by the closing date of this announcement. QUALIFICATION REQUIRMENTS: To qualify for this position, you must meet the qualification requirements outlined below: MINIMUM REQUIREMENTS FOR GRADE 12 LEVEL UP (GS or Equivalent) Applicants must have Information Technology related experience demonstrating each of the following nine competencies: 1) Attention to Detail, 2) Customer Service, 3) Decision Making, 4) Information Management, 5) Interpersonal Skills, 6) Oral Communication, 7) Problem Solving, 8) Teamwork and 9) Technical Competence.SPECIALIZED EXPERIENCE GS-13 LEVEL: You must have one year of specialized experience at a level of difficulty and responsibility equivalent to the GS-12 grade level in the Federal service. Specialized experience for this position includes: Independently applying IT principles, concepts, methods, and practices to plan, analyze, implement, maintain, troubleshoot, or enhance IT systems, services, hardware, software, applications, interfaces, scripts, or related technology environments. Performing computer projects, operational, or application-related assignments involving IT requirements and techniques, including resolving technical issues, validating system, application, or code testing and configuration. Preparing technical documentation and applying federal cybersecurity, privacy, or regulatory requirements. Working directly with customers, stakeholders, users, and technical teams to define business or technical requirements, advising on feasible IT approaches, and implementing secure, reliable, scalable IT solutions, including application enhancements where applicable. Assessing system, service, or application performance, availability, reliability, usability, and operational effectiveness. Identifying risks, recurring issues, or defects; and recommending or implementing corrective actions consistent with established policies and procedures. Analyzing multiple technical alternatives and advising management or IT specialists on the selection, configuration, implementation, or improvement of IT solutions, including application components where applicable, to support mission and operational requirements. Operating Python, Spark, Databricks, and AWS data services. Applying data normalization, ingestion automation, and schema mapping. Utilizing Structured Query Language (SQL) for searching, manipulating, and validating large datasets, and scripting languages like Python for automation and testing. Experience with data quality dimensions (e.g., accuracy, completeness, consistency). Utilizing Extract, Transform, Load (ETL) processes and data pipelines and cloud platforms like Amazon Web Services (AWS), Azure, or (Google Cloud Platform) GCP. Experience Applying DevOps and automation best practices by utilizing CI/CD repositories and pipelines and deployment automation (e.g. GitHub, GitHub Actions workflows) to ensure secure, reliable, repeatable, and scalable delivery of data engineering solutions and platform enhancements. AND You must also meet the following requirement(s): PERFORMANCE RATING: Current federal employees must have at least a fully successful or equivalent performance rating to receive consideration. TIME AFTER COMPETITIVE APPOINTMENT (TACA): By the closing date (or if this is an open continuous announcement, by the cut-off date) specified in this job announcement, current civilian employees must have completed at least 90 days of federal civilian service since their latest non-temporary appointment from a competitive referral certificate, known as time after competitive appointment. For this requirement, a competitive appointment is one where you applied to and were appointed from an announcement open to "All US Citizens" TIME IN GRADE (TIG): Federal employees must meet time-in-grade requirements. For positions above the GS-05, applicants must meet applicable time-in-­grade requirements to be considered eligible. One year (52 weeks) at the next lower grade level is required to meet the time-in-grade requirements for the grade you are applying for. For positions at the GS-05, you cannot advance to the GS-05 if you have held a GS-02 in the past 52 weeks. There is no TIG restriction for GS-02, 03, or 04 positions. MINIMUM AGE REQUIREMENT: Minimum age for federal employment is 18 years old, or at least 16 years old and have: Graduated from high school or been awarded a certificate equivalent to graduating from high school; or Completed a formal vocational training program; or Received a statement from school authorities agreeing with your preference for employment rather than continuing your education. For more information on qualifications please refer to OPM's Qualifications Standards. View the full announcement and apply on USAJOBS.gov.