Sign Up Sign Up Log In Sign Up
This job has expired and you can't apply for it anymore. Start a new search.

Data Engineer


The U.S. Citizenship and Immigration Services (USCIS), Office of Information Technology (OIT) is seeking to acquire highly qualified cross-functional Data Scientists and developers. The Transformation Data Science Services (TDSS) II team will be part of an ecosystem, participating with federal employees, and other contractors, in a team-based Development and Operations (DevOps) approach to deliver business value (the performance measurements, Key Performance Parameters (KPPs) are established in Operational Requirements Document (ORD)) frequently, cost-effectively, responsively, and with high quality.
The TDSS II teams shall provide Data Analytics Services within the DevOps framework; perform analysis of the USCIS Electronic Immigration System (USCIS ELIS) and related data for forecasting and system growth analysis. This analysis is intended to support data-driven decision-making, as well as development of automated dashboards and tools, which provide analytic insight to ELIS program.
  • Creating and maintaining Data Lakes and Data Warehouses.
  • Data modeling and modifying database schema design as needed.
  • Building data pipelines to pull together information from different source systems
  • Integrating, consolidating and cleansing data, and structuring it for use in individual analytics applications
  • Perform the full data lifecycle areas of:  data ingestion, data aggregation, data correlation and visualization, analytics.
  • Actively engage with end users to understand data-intensive challenges and needs and ensure development enables high performance movement, storage, aggregation, visualization and analytics over datasets from disparate sources.
  • Utilize the ELIS roadmap to conduct an exploratory statistical analysis for each ELIS line of business.
  • Translate business requirements into technical requirements.
  • Extract, transform and load (ETL) structured and unstructured data into Databricks Unified Analytics Platform.
  • Work with data scientists to perform analytics in Databricks Unified Analytics Platform, and version control machine learning models and reports in GitHub.
  • Comply with ELIS DevOps development, testing, and standard operational procedures (SOP).
  • Collaborate with other vendors, stakeholders, and government employees to collect data needed to aid decision-making.
  • Maintain good configuration and data management methods.
  • Use DHS USCIS approved methods and tools.


  • Bachelors with 9+ years of experience, or Masters with 7+ years, or PhD with 4+ years of experience.
  • 9+ years of relevant experience.
  • Hands-on expertise in the full data lifecycle areas of:  data modeling, ETL, data warehousing, reporting, data exploration and visualization, analytics and data provisioning. 
  • Hands on experience in the areas of Big Data design and implementation for data intensive problems. 
  • Experience with RDBMS, Oracle and PostgreSQL particular.
  • Experience with Agile methodology.
  • Experience assessing business objectives, conducting gap analysis of existing versus needed capability, and identifying business requirements.
  • Experience in the evaluation of business requirements to identify potential software, hardware, and system architectures that can be employed to meet business objectives.
  • Experience providing potential technical solutions to meet business needs and supporting analysis of alternatives for best fit.
  • Experience in evaluating technical trends and providing recommendations for technology and architecture to meet business objectives.
  • Experience in Databricks products, or extensive experience in Apache Spark.
  • Experience with several of the following skills:
    • AWS, SQL, Liquidbase, Java, Junit, Selenium, Python, Data API Design, Scala
  • Must be a US Citizen
  • Must be able to obtain and maintain Public Trust
Company Name:
Security Clearance:
WASHINGTON, District of Columbia
United States
Not Specified
Job Number:

Send me email alerts for similar jobs