NFF, Inc

ETL Data Engineer (Onsite)

NFF, Inc • $120K — $140K *
Washington, DC 20011In-Person
Information Technology
11 - 15 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Information Technology or related field or equivalent experience.
  • 15+ years of ETL process development and end-to-end pipeline experience.
  • 15+ years of requirements gathering for data extraction and transformation.
  • 15+ years of understanding data warehousing and information management.
  • 15+ years advising on data processing tools and systems.
  • 11+ years proficiency in various data formats (Oracle, SQL, CSV, Parquet).
  • 11+ years ensuring enterprise data governance standards.

Responsibilities

  • Analyze, design, develop and support complex enterprise data projects.
  • Consult with agencies to inform user departments on system requirements.
  • Develop ETL processes using tools like Azure Data Factory and Synapse.
  • Establish cloud and on-premise connectivity for various systems.
  • Create end-to-end pipelines to load data from multiple sources.
  • Optimize data workflows and adhere to governance standards.
  • Automate and manage data pipelines and workflows.

Benefits

  • Medical, Dental and Vision insurance.
  • Health Savings Account and Flexible Spending Account options.
  • Short-term and long-term disability insurance.
  • Supplemental life insurance and AD&D coverage.
  • Comprehensive 401k plan.
  • Flexible paid time off options.
Full Job Description
About this Position / Responsibilities

NFF,Inc. is seeking an expirienced ETL data engineer will support the Enterprise Data team for data curation, processing, and transformation tasks. Specifically, the ETL data engineer will be responsible for the following tasks:

Responsibilities:
  • Analyzes, designs, develops, implements, replicates, and supports complex enterprise data projects.
  • Interfaces with other agencies, consult with and inform user departments on system requirements, advise on environment constraints and operating difficulties for the current state and advise and resolve problems using cloud solutions and develop and replicate future enhancements to District's data systems.
  • Strong knowledge of Extraction, Transformation and Loading (ETL) processes using frameworks like Azure Data Factory, Synapse, Databricks, Informatica by gathering requirements from the stake holders or analyzing the existing code and perform enhancements or new development.
  • Establishing the cloud and on-premise connectivity in different systems like ADLS, ADF, Synapse, Databricks
  • Hands on experience in Azure cloud services like Azure Data Factory or Azure Synapse, MSSQL Db, Azure SQL DB, Azure Data Lake Storage Gen2, Blob Storage, Python etc.
  • Worked on creating end to end pipelines to load data by reading it from multiple sources or source systems and load to landing layer or SQL tables.
  • Familiarity/experience with data integration and data pipeline tools (e.g., Informatica, Synapse, Apache NiFi, Apache Airflow)
  • Familiarity/experience with various data formats including database specific (Oracle, SQL Server, DB2, Quickbase), text formats(CSV, XML) and Binary(Parquet, AVRO)
  • Develops, standardizes and optimizes existing data workflow/pipelines adhering to best practices.
  • Adhere and contribute to enterprise data governance standards by ensuring data accuracy, consistency, security, and reliability.
  • Automates, monitors, alerts, and manages data pipelines and workflows.
  • Analyzes and evaluates system changes to determine feasibility, provides alternative solutions, back-up, and rollback procedures.
  • Works on the development of new systems, upgrades and enhancements to existing systems and ensure systems follow approved standards and consistency after the changes.
  • Develops complex programs and reports in database query language.
  • Familiarity/experience with data visualization tools.
  • Familiarity/experience handling and securing sensitive data based on the level of the sensitivity


Qualifications

  • Bachelor's degree in Information Technology or related field or equivalent experience
  • Required 15 Years Strong knowledge for development of Extract-Transform-Load (ETL) processes, including end-to-end pipelines with data loading from multiple sources
  • Required 15 Years Ability to gather and document requirements for data extraction, transformation and load processes
  • Required 15 Years Understanding of data warehousing, data lake, business intelligence and information management concepts and standards.
  • Required 15 Years Ability to advise internal and external customers on appropriate tools and systems for complex data processing challenges.
  • Required 15 Years Knowledge and use of SQL for relational databases
  • Required 11 Years Experience with various data formats including database specific (Oracle, SQL, Postgres, DB2), text formats (CSV, XML) and Binary (Parquet, AVRO)
  • Required 11 Years Contribute to enterprise data governance standards by ensuring accuracy, consistency, security and reliability
  • Required 7 Years Strong experience with Microsoft Azure tools such as Azure Data Factory, Synapse, SQL Database, Data Lake Storage Gen2, Blob Storage Required 5 Years Experience with data integration and data pipeline tools such as Informatica PowerCenter, Apache NiFi, Apache Airflow and FME
  • Required 5 Years Experience with visualization and reporting software such as MicroStrategy, Tableau, and Esri ArcGIS
  • Highly desired 3 Years Strong communication skills, both oral and written
  • Required 3 Years Ability to provide excellent customer service to external partners
  • Required 3 Years Ability to work independently or as part of a larger team
  • Highly desired 3 Years Experience performing data functions with Databricks


NFF Disclosures

NFF offers a competitive salary, comprehensive benefits and flexible paid time off options, for eligible employees:
  • Medical, Dental and Vision, Health Savings Account, Flexible Spending Account
  • STD, LTD, Supplemental life insurance and ADD&D
  • Comprehensive 401k plan
  • Paid Time Off

About NFF, Inc

NFF, Inc. is a technology company that provides IT consulting, integration, and managed services to businesses and government agencies. The company was founded in 1996 and is headquartered in Herndon, Virginia. NFF's services include network infrastructure, data center, cloud computing, cybersecurity, and unified communications. The company has more than 200 employees and serves clients in a variety of industries, including healthcare, finance, and government. NFF is known for its technical expertise and customer service.
Learn more about NFF, Inc
Size
200 employees
Industry
Information Technology
Founded
1996
NASDAQ
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at NFF, Inc

More Information Technology Jobs

Find similar ETL Data Engineer (Onsite) jobs:

NationwideWashington, DC