Data Engineer - SQL
- Location: Richmond, VA
- Start Date: 11/14/2023
- Job ID: 24-00028
- Posting Date: 2/20/2024
- Job Type: Direct Placement
Responsibilities
The Data Science Engineer - SQL will be a part of our IT team and will work in support of SQL Reporting, Pricing, Analytics, Operational and Infrastructure initiatives. Will be responsible for developing an understanding of data and information needs, identifying solutions and improving the quality of service while providing support through the logical and physical design of databases, data-structures, routes, and topic and be responsible for designing, managing, and maintaining digital communication document and messaging format standards. Act as a Database Administrator, maintaining data integrity, availability and performance across data-stores, data services, and RDBMSs.
Will also provide strategic guidance and implementation of the corporate Data "Surface and the corresponding integrations, translations, and observability.
Designing, managing, and maintaining company digital communications formats and standards in documentation.
Qualifications
The Data Science Engineer - SQL will be a part of our IT team and will work in support of SQL Reporting, Pricing, Analytics, Operational and Infrastructure initiatives. Will be responsible for developing an understanding of data and information needs, identifying solutions and improving the quality of service while providing support through the logical and physical design of databases, data-structures, routes, and topic and be responsible for designing, managing, and maintaining digital communication document and messaging format standards. Act as a Database Administrator, maintaining data integrity, availability and performance across data-stores, data services, and RDBMSs.
Will also provide strategic guidance and implementation of the corporate Data "Surface and the corresponding integrations, translations, and observability.
Designing, managing, and maintaining company digital communications formats and standards in documentation.
- Managing and maintaining database system software and database security.
- Monitoring and analyzing database performance and ensuring effective and efficient utilization of database systems/processes.
- Maintaining database dictionaries and support tools; developing and maintaining accurate system documentation.
- Participating in the development of application code: assisting in developing application data-management architecture and defining data-structures.
- Providing technical leadership on database systems and solutions. Providing individual mentoring and training on databases and tools. Recommending, testing, and evaluating new technologies, software tools, and required skill sets; recommending and implementing improvements.
- Implementing a Business Continuity solution for the database environment.
- Comply with company C-TPAT and TSA security procedures.
- Perform other duties as assigned.
Qualifications
- Five or more years of complex SQL, and NoSQL query creation, tuning and troubleshooting.
- Database administration experience: installing, configuring, designing, patching, archiving, monitoring, indexing and performance tuning.
- Backup/recovery solutions and best practices.
- Common BI Tools (Tableau, PowerBI).
- NoSQL solutions and concepts.
- Working knowledge of data encryption techniques in process and on disk.
- Capable of managing multiple projects concurrently while maintaining a high level of attention to detail on each project.
- Ability to write effective technical documentation.
- Ability to communicate with the customer's technical staff.
- Ability to communicate with business stakeholders in order to understand business needs.
- Experience with modern operations technologies and network troubleshooting.
- Bachelor's Degree in Computer Science, Computer Applications, or past commercial implementation experience in the field.
- Experience with the following is not required but considered valuable:
- BigData / FastData / DataLake / Data Virtualization solutions and concepts.
- Machine Learning.
- Strong communication skills, good organizational skills, and ability to problem solve.
- Ability to work independently and in a fast-paced, team environment.
- Must be able to and comply with all company policies, rules, procedures and Code of Conduct.
- Must be able to interact well with others.
- Ability to read and interpret complex business and/or technical documents.
- Ability to write comprehensive reports and detailed business correspondence.
- Ability to work with groups of people such as other departments and communicate known concepts.
- Ability to solve problems with a variety of concrete variables through semi-standardized solutions that require some ingenuity and analysis. Ability to draw inferences and follow prescribed and detailed procedures to solve moderately complex problems.
- Must be eligible to work in the United States.
Posted by Jeffrey Armstrong
