Enterprise Data Engineer

Job Summary:

The Data Engineer will be responsible for developing optimizing testing and creating extracts integrations and migrations of data to new and existing databases to help users retrieve data effectively. This role involves working with technologies in the data field to support advanced analytics and data processing capabilities. The ideal candidate will have a strong background in software development database management and a solid understanding of data mapping and transformation extraction and loading.

Essential Duties and Responsibilities:

Development:

The Developer candidate must have the following experience:

• Proficient with Structured Query Language (SQL).

• Proficient in creating modifying and querying relational databases.

• Proficient in the creation of SQL queries to retrieve specific data from Needles by specifying various search criteria.

• At least 5 years of experience with interpreting database tables and data to understand correct extraction and mapping.

• Experience formatting running totals summaries custom formulas and custom Functions (SQL Queries).

• Experience with PLSQL Developer SQL Plus SQL Navigator and AWS Glue.

• Strong ability to research and manage complex data requests.

• Sound oral and written communication skills.

• Migration experience a plus.

• High evaluative and interpretative skills.

Qualifications:

• Bachelors or Masters degree in Computer Science Information Technology or a related field.

• Proven work experience as a Data Engineer Database Developer or similar role.

• Experience with databasebacked web applications.

• Proficiency in SQL and experience with database management systems (e.g. MySQL PostgreSQL MongoDB).

• Familiarity with data manipulation languages and the principles of database design.

• Knowledge of software development and user interface web applications.

• Excellent organizational and analytical abilities.

• Outstanding problem solver.

Preferences:

• Background with both structured and unstructured data.

• Experience with both SQL and NoSQL databases.

• Familiarity with columnar databases.

• Experience with Salesforce AWS Redshift and Snowflake.

Candidate must be local.

Additional Location Details (City State) :

Must currently be within Colorado.

Information on Security Training

NOTICE: If you are hired as vendor staff who will have access to state systems or data or as a contractor for one of the state executive branch consolidated agencies in adherence to Colorado Revised Statute 2437.and 406 and Colorado Information Security Policy (CISP) 002 you will be required to selfregister and complete information security training including but not limited to review and acknowledgement of the Acceptable Use of State Data and IT Resource Policy (AUP) (CISP018) through the consolidated agency contractor information security training site within 30 days of your contract start date and annually thereafter. Should you be awarded this contract the state agency will provide the contractor information security training site information to you.

Minimum Verification Requirements

Please complete the following verifications with Info Cubic upon candidates selection. Additional verifications may be identified by the agency.

• State Criminal Record verification (past 7 years covering each State in which the candidate has resided)

• County Criminal Records (past 7 Year Address History)

• Federal Criminal Records Verification (past 7 years)

• SSN Name Search

• Global Monitor Check (formerly Patriot/OFAC/Terrorist)

(Suppliers Only)
To order click on the link to the right:

Order the OIT Background Verification