Data Engineer

Data Engineer Tech Army - 5.0 Tallahassee, FL Job Details Full-time | Contract 1 day ago Qualifications Application Integration Data model design Bachelor's degree in management information systems Data modeling Data Integration (Data management) Computer Science Cloud data warehouses Management Information Systems System design Database security management Snowflake Data Architecture Design (Architecture design skills) Bachelor's degree Data quality monitoring Improving database performance Organizational skills Software testing Computer Programming Systems analysis Redshift Senior level Cross-functional collaboration PL/SQL Bachelor's degree in computer science T-SQL System performance monitoring Full Job Description

INTERVIEW

= Onsite / Virtual

JOB TYPE

= Onsite Scope of Work 1. Minimum Qualifications a. Academic and Certification i. A bachelor's degree from an accredited college or university and seven (7) years' experience in computer systems analysis and/or computer programming; or ii. A bachelor's degree from an accredited college or university with a major in one of the computer sciences or management information systems. b. Skills and Abilities i. Knowledge of the principles, practices, and techniques of computer programming and systems design ii. Ability to evaluate and implement user's requests for new data elements and systems and incorporates in the existing shared data environment iii. Ability to coordinate use of the organization's data to ensure data integrity and control redundancy iv. Ability to perform data modeling and proto typing v. Knowledge of maintaining necessary database security vi. Skilled in monitoring database performance and implementing efficiency improvements vii. Ability to create test data base environment for applications sections, including the creation of necessary libraries and procedures viii. Ability to develop and maintain database access and procedures to ensure proper control of the databases ix. Ability to assist programmer/analysts in programming database objects and conduct walk-throughs to ensure database efficiency x. Ability to set up and/or execute the jobs necessary to save, retrieve, and recover databases from hardware and software failures within established procedures c. Experience i. Seven (7) plus years of successful data driven system development/integration experience using Microsoft SQL server. d. General i. Ability to plan, organize, and coordinate work assignments ii. Ability to communicate technical information effectively iii. Ability to establish and maintain effective working relationships with others 2. Responsibilities The Data Engineer will be responsible for the following: a. Design, construct, and maintain ETL/ELT pipelines, b. Create and manage relational databases and data warehouses, c. Write complex SQL queries, optimizing query execution and performance tuning, d. Data modeling and architecture, e. Ensuring data quality and reliability, f. Collaboration with Data Stakeholders, g. Implementation of Data Security and Governance, h. Expert SQL Proficiency (T-SQL, PL/SQL), i. Familiarity with Data Warehousing Tools like Snowflake, Redshift, j. Works as a subject matter expert for data integration, data exchange, and interfaces between internal and external systems associated with the Agency, k. Collaborate between the applications developer/DBA and the business unit working with the carious Agency systems, l. Acts as a liaison between APD and the external Agency technical staff on resolving issues with interfaces, data integration and the data exchange jobs associated with the Agency systems, m. Performs system testing and maintain the test results for various APD systems, n. Helps the developer/analyst in analyzing data and reports for resolving critical issues with production systems; and o. Liaises with network administrators, developers, system analysts, and business owners to assist in resolving problems with applications/programs.