Search for More Jobs
Forward job to a friend
Apply without Registering
Apply by creating/using an account
Please enter your registered email address, and we'll email you a link to reset your password right away.
Diversant is searching for a Data Engineer for our client located in Denver, CO. This is an AWS, Python ETL, SQL Server project. The complexity of this project will be in the business processes and source systems which are (A) Not standardized or documented, (B) still under active development. Engineers personality must be patient and able to accommodate strong source code. This is a Direct Placement Opportunity.
This person MUST have experience using Python as the production ETL Tool.
Python skills/experience: Python 3.6, PEP8 compliant code that lists error/warning free (Pylint, Pyflake) and that follows team coding conventions that will be under development. Code will be developed in Python virtual environments and versioned via Github. Code require will require proper treatment of various text encodings, error handling and recovery, logging, standard lib based CSV import/export (CSV data quality issues may eliminate Pandas as a library), string and data transformations, DBAPI connections to SQL Server and PostgreSQL, AWS Boto3 API calls at the resource and client level. Python code will run under Windows Server and optionally under Linux environment. Technical knowledge of Window NT Services architecture and behavior needed for delivering data capture code.
ETL skills/experience: Must understand job control, logging, monitoring, restart, initial and incremental data pulls, archive/failure bin tracking of raw assets, CDC techniques, surrogate key assignment, upsert/merge, pivot/transpose, audit control fields, data quality screening, etc.
SQL Server 2016+ skills/experience: In-memory tables, column store indexes, temporal tables, transactions, sequences, indexes. Optional: Stored procs, index and database tuning.
AWS skills/experience: Must understand IAC (infrastructure as code) concepts and be able to use CloudFormation or equivalent (Terraform, Chef, Ansible) to help build dev, QA and production environments from code. Respect for strong naming conventions and consistent resource tagging are important. Experience with AWS console, CLI, and Boto3 API.
Apply by creating/using an account
DIVERSANT (diversant.com) is one of the largest African-American owned IT staffing firms in the U.S. We offer rewarding career opportunities with many of the nation’s leading corporations. Our experienced recruiters understand what hiring managers look for in a candidate and provide our applicants with the proper support and guidance along the entire application and interviewing process. We offer opportunities on a contingent, contract-to-hire, and direct hire basis. At DIVERSANT, we are committed to providing the highest level of service and satisfaction to our customers, consultants, and employees.
DIVERSANT provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, DIVERSANT complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
WORK OPPORTUNITY TAX CREDIT
Diversant LLC participates in the Work Opportunity Tax Credit program. ADP Tax Credits administers this program on our behalf. It is vital that you follow the steps listed below in order for the tax credits to be processed. We appreciate your cooperation. Please note participation in this program is voluntary and is a required part of the employment application process. Formal application steps should still be followed.
Work Opportunity Tax Credit Applicant Instructions
• Open https://tcs.adp.com/screen/index.html?cc=diversant
Note: To change the language on screen please select a language from the dropdown box
• Click on Continue to begin
• Please answer each question including electronically signing any applicable forms
• To complete the interview and save your work, please click eSign and Finish
• If applicable, upload any available supporting documents and click Continue