SQL Developer (T-SQL)

SQL Developer (T-SQL)

Posted 1 day ago by 1763638090

Apply
Negotiable
Outside
Remote
USA
Apply
Business Operations Database Systems Data Integration Data Integrity Data Manipulation Microsoft Excel Online Transaction Processing Relational Databases Spreadsheets SQL (Programming Language)

Summary: We are looking for a SQL Data Integration Specialist with strong T-SQL skills to maintain and update a master store list in an OLTP relational database system. The role involves staging data from Excel spreadsheets and ensuring data integrity while working remotely. This is a part-time position with a contract duration of two months. Candidates must reside in the Pacific Time zone.

Key Responsibilities:

  • Maintain and update the master store list in an OLTP RDBMS backend.
  • Stage data from Excel spreadsheets into staging tables and use T-SQL to merge deltas into production tables.
  • Ensure data integrity by preventing duplicates and validating updates.
  • Process store updates received.
  • Handle bulk updates (up to several hundred records) from Excel spreadsheets.
  • Collaborate with internal teams to ensure accurate and timely data incorporation.

Key Skills:

  • Proficiency in T-SQL for data manipulation and integrity checks.
  • Experience working with OLTP relational databases or similar.
  • Strong skills in Excel for staging and preparing data.

Salary (Rate): £40.00 hourly

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

No C2C / No Third-Party Agencies

 We're Hiring: SQL Data Integration Specialist (T-SQL)
 Remote (Must reside in Pacific Time)
$40.00 to 45.00 per hour
: Part-time hours (15-20/week), 2 months contract

We are seeking on behalf of our client a detail-oriented SQL Data Integration Specialist to help maintain and update our master store list in an OLTP relational database system. This role requires strong mid-level T-SQL skills and the ability to stage and incorporate data from Excel spreadsheets into production tables while ensuring data integrity.

Key Responsibilities

  • Maintain and update the master store list in an OLTP RDBMS backend.
  • Stage data from Excel spreadsheets into staging tables and use T-SQL to merge deltas into production tables.
  • Ensure data integrity by preventing duplicates and validating updates.
  • Process store updates received.
  • Handle bulk updates (up to several hundred records) from Excel spreadsheets.
  • Collaborate with internal teams to ensure accurate and timely data incorporation.

Qualifications

  • Proficiency in T-SQL for data manipulation and integrity checks.
  • Experience working with OLTP relational databases or similar.
  • Strong skills in Excel for staging and preparing data.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

Apply
Similar Jobs
Loading data...