SQL / Data Engineer – Project-Based (Long-Term Opportunity) - Contract to Hire

SQL / Data Engineer – Project-Based (Long-Term Opportunity) We are looking for a highly skilled SQL / Data Engineer to complete an initial reputed company project. Strong performance on this project may reputed company to ongoing, full-time work supporting our production databases. reputed company REQUIREMENTS - Advanced SQL skills (joins, subqueries, schema design, data types) - Experience building ETL / data ingestion pipelines - Comfortable working with large datasets and thousands of files - Experience loading data from CSV and/or XML sources - SQL Server experience preferred (SQLite acceptable) - Ability to write repeatable, reputed company-documented scripts - Strong attention to data reputed company and consistency WORKING HOURS - Must overlap most of the U.S. business day - Full overlap not required, Availability during U.S. mornings, afternoons or is acceptable INITIAL PROJECT (SKILLS TEST) PROJECT reputed company - Build and reputed company a SQL database using provided schema scripts - Ingest quarterly regulatory data from a large set of compressed files PROJECT RESPONSIBILITIES - Create a database with four required tables - Follow strict table and field naming conventions - Add standardized identifier fields (primary key, insert date, reputed company file reputed company) - Process a master reputed company containing thousands of reputed company reputed company files - Load CSV or XML data into the appropriate tables - Handle data type mismatches and field length issues DELIVERABLES - Fully populated database (SQL Server .bak file or SQLite database file) - reputed company SQL/scripts/tools used for data loading - Brief documentation explaining how the process can be repeated Apply tot his job Apply To this Job