Senior Data Architect - Clearance Desired
Remote, United States
Full Time Senior-level / Expert Clearance required USD 122K - 189K *
Logistics Management Institute
With a legacy of solving the government’s most complex challenges and an outcome-driven model to execute above expectation, LMI transforms missions with solutions that define the new speed of possible.Overview
Seeking a senior data architect to oversee data architecture for large scale API and web application back end data store and implement ETL processes to supply application data for usage in the web application.Responsibilities
- Oversees data architecture for large scale API and web application back end data store. Implements ETL processes to supply application data for usage in the web application.
- Manages critical low latency application databases on platforms.
- Develop packages and scripts for system enhancements and interfaces.
- Develops scripts to validate the various data on systems. Involve in writing queries to improve the database performance and availability.
- Must use process through the ETL and refresh to identify, troubleshoot, and correct code problems.
- Develop, implement, and execute a quality assurance program and quality control standards for all activities. Executes statement to create and update various tables and views utilize for testing of code on an database.
- Establish database backup/recovery strategy using user-manage backup. Engineer extensive database solutions and interfaces enabling performance of data requests. Develop reusable components for deployment in a traditional data warehouse environment.
- Standardize database maintenance activities by standardizing directory structure, documentation of DBA activities.
- Establish backup and recovery options and implement automation of many DBA utility functions. Document database design, data definition language, define data migration strategy between different products/versions and develop data migration procedures.
Qualifications
Qualifications:
- Minimum of 10 years’ experience designing, developing, and maintaining enterprise database systems.
- Experience with cloud database development and implementation (AWS preferred).
- Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings.
- Demonstrated experience with ETL pipeline design and implementation.
- Overseeing aspects of data governance and maintenance, modeling, and secure access.
- Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle).
- Demonstrated experience implementing ETL pipelines within and without the use of 3rd party vendor solutions (NNCompass, Pentaho).
- Demonstrated experience documenting database architecture and diagrams.
- Secret clearance or ability to obtain and maintain a government security clearance, for which one must be a US citizen.
Preferred:
- Experience with storage on cloud for containerized applications
- Experience with NoSQL (Cassandra, HBase, MongoDB, etc...)
- Experience with index based datastores (ElasticSearch, Solr)
- Experience running ETL pipelines over Apache NiFi
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture AWS Cassandra Data governance Data warehouse Elasticsearch ETL HBase MariaDB MongoDB MS SQL MySQL NiFi NoSQL Oracle Pentaho Pipelines PostgreSQL Security SQL Testing
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs