Must be local and US Citizen; eligible to obtain Secret Clearance

Data Solutions Architect is a direct hire or full-time opportunity requiring US Citizenship. Candidate must be eligible to obtain Secret Clearance. Onsite in O’Fallon, IL. Local is a must.

Requirements

Strong SQL: Ability to write, troubleshoot, and modify complex SQL procedures and queries across a variety of datasets.

Extract, Transform, Load (ETL): Experience establishing and maintaining data load processes as well as manipulating and combining various data sources.

Business Intelligence: Creating and updating applications, reports, dashboards, etc. Cognos Analytics, Qlik Sense, and Power BI are especially relevant to the role.

Basic Python experience:

A mix of SQL and Python is typically used in most ETL processes, though Python can usually be prioritized as well.

Databricks experience: Familiarity with Databricks, Amazon AWS/S3, and Jupyter Notebooks will be helpful and preferred.

Teradata experience is a plus. Knowledge of Multiloads, BTEQs, and other assorted Teradata procedures will be preferred.

Accounting knowledge is a plus. Some experience with Department of Defense (DoD) accounting systems (DEAMS, TFMS, NERP etc.) and transportation policies will be preferred.

Federal Financial Management experience and Audit Practices are a plus.