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)
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed
LMI is an Equal Opportunity Employer. LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact accommodations@lmi.org
Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.