Duration:+6-month contract to start (with extensions)
Location: Work in remote (must reside within the USA)
Visa: USC, GC and H4
Interview: Video
Job Description
Position Overview:
We are seeking a skilled and proactive SQL Scripter with a Business Analyst dimension to join our team. The ideal candidate will have expertise in SQL scripting for data import/export, a strong business analysis background, and the ability to work with diverse datasets. This role will involve extracting data from various sources including D365, Excel, and other sources, cleansing the data, and importing it into a data lake for further analysis and integration into NetSuite (NS).
Responsibilities
Develop and optimize SQL scripts to extract data from D365, Excel, and other sources.
Cleanse and transform data to ensure accuracy and integrity before importing it into the data lake.
Collaborate with stakeholders to gather business requirements and translate them into technical solutions.
Analyze data to identify trends, patterns, and insights that drive business decision-making.
Import data into the data lake and integrate it into NetSuite (NS) using SQL scripting.
Work closely with cross-functional teams to ensure smooth data integration and implementation.
Provide expertise in database export/import processes and data cleansing techniques.
Act as a technical expert and advisor, guiding the team on best practices for SQL scripting and data management.
Qualifications
Bachelor’s degree in Computer Science, Information Systems, Business Administration, or related field.
Proven experience in SQL scripting for data import/export, with a focus on data cleansing and transformation.
Strong understanding of database concepts and experience with database export/import processes.
Business analysis skills, with the ability to gather and interpret business requirements.
Experience working with diverse datasets from multiple sources.
Knowledge of NetSuite (NS) and familiarity with multi-media industry practices is a plus.
Excellent communication and interpersonal skills, with the ability to work effectively in a remote team environment.
Proactive attitude and ability to work independently with minimal supervision.
Strong problem-solving skills and attention to detail.
"Propeller head" mentality with a passion for diving deep into technical challenges.
Seniority level
Associate
Employment type
Full-time
Job function
Research, Analyst, and Information Technology
Industries
Information Technology & Services
Referrals increase your chances of interviewing at SmartIPlace by 2x