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