Role : Big Data Architect IT Consultant Master Client : State of DC Location : Washington,D.C.

Job description

This role will provide expertise to support the development of a Big Data / Data Lake system architecture that supports enterprise data operations for the District of Columbia government, including the Internet of Things (IoT) / Smart City projects, enterprise data warehouse, the open data portal, and data science applications. This is an exciting opportunity to work as a part of a collaborative senior data team supporting DC's Chief Data Officer. This architecture includes an Databricks, Microsoft Azure platform tools (including Data Lake, Synapse), Apache platform tools (including Hadoop, Hive, Impala, Spark, Sedona, Airflow) and data pipeline/ETL development tools (including Streamsets, Apache NiFi, Azure Data Factory). The platform will be designed for District wide use and integration with other OCTO Enterprise Data tools such as Esri, Tableau, MicroStrategy, API Gateways, and Oracle databases and integration tools.

Responsibilities:

1. Coordinates IT project management, engineering, maintenance, QA, and risk management.
2. Plans, coordinates, and monitors project activities.
3. Develops technical applications to support users.
4. Develops, implements, maintains and enforces documented standards and procedures for the design, development, installation, modification, and documentation of assigned systems.
5. Provides training for system products and procedures.
6. Performs application upgrades.
7. Performs, monitoring, maintenance, or reporting on real- time databases, real-time network and serial data communications, and real-time graphics and logic applications.
8. Troubleshoots problems.
9. Ensures project life-cycle is in compliance with District standards and procedures.

Minimum Education/Certification Requirements: Bachelor’s degree in Information Technology or related field or equivalent experience

Skills

Experience implementing Big Data storage and analytics platforms such as Databricks and Data Lakes Knowledge of Big Data and Data Architecture and Implementation best practices - 5 Years Knowledge of architecture and implementation of networking, security and storage on cloud platforms such as Microsoft Azure - 5 Years Experience with deployment of data tools and storage on cloud platforms such as Microsoft Azure - 5 Years Knowledge of Data-centric systems for the analysis and visualization of data, such as Tableau, MicroStrategy, ArcGIS, Kibana, Oracle - 10 Years Experience querying structured and unstructured data sources including SQL and NoSQL databases - 5 Years Experience modeling and ingesting data into and between various data systems through the use of Data Pipelines - 5 Years Experience with implementing Apache data products such as Spark, Sedona, Airflow, Atlas, NiFi, Hive, Impala - 5 Years Experience with API / Web Services (REST/SOAP) - 3 Years Experience with complex event processing and real-time streaming data - 3 Years Experience with deployment and management of data science tools and modules such as JupyterHub - 3 Years Experience with ETL, data processing, analytics using languages such as Python, Java or R - 3 Years Experience with Cloudera Data Platform - 3 Years 16+ yrs planning, coordinating, and monitoring project activities - 16 Years 16+ yrs leading projects, ensuring they are in compliance with established standards/procedures - 16 Years Bachelor’s degree in IT or related field or equivalent experience Required 5 Years Knowledge of Big Data and Data Architecture and Implementation best practices

5 Years

Knowledge of architecture and implementation of networking, security and storage on cloud platforms such as Microsoft Azure - 5 Years

Experience with deployment of data tools and storage on cloud platforms such as Microsoft Azure -5 Years

Knowledge of Data-centric systems for the analysis and visualization of data, such as Tableau, MicroStrategy, ArcGIS, Kibana, Oracle

10 Years Experience querying structured and unstructured data sources including SQL and NoSQL databases - 5 Years

Experience modeling and ingesting data into and between various data systems through the use of Data Pipelines -5 Years

Experience with implementing Apache data products such as Spark, Sedona, Airflow, Atlas, NiFi, Hive, Impala - 5 Years Experience with API / Web Services (REST/SOAP) - 3 Years

Experience with complex event processing and real-time streaming data - 3 Years

Experience with deployment and management of data science tools and modules such as JupyterHub - 3 Years Experience with ETL, data processing, analytics using languages such as Python, Java or R - 3 Years

Experience with Cloudera Data Platform - 3 Years

16+ yrs planning, coordinating, and monitoring project activities - 16 Years

16+ yrs leading projects, ensuring they are in compliance with established standards/procedures - 16 Years

Bachelor’s degree in IT or related field or equivalent experience

Required