Data Analyst/Data Integration Specialist
Spectraforce
Newark, New Jersey
15 days ago
Job Description
Job Title: Data Analyst/Data Integration Specialist
Location: Newark, NJ (Hybrid)
Duration: 7-8+ Months
Responsibilities:
About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $65.00/hr.
Location: Newark, NJ (Hybrid)
Duration: 7-8+ Months
Responsibilities:
- Database design: Design and implement efficient database structures and schemas to support application functionality
- Code writing: Write and optimize complex SQL queries for data retrieval, manipulation, and reporting
- Database queries: Write SQL queries to extract and manipulate data
- Testing and troubleshooting: Test databases and identify and fix issues related to performance, security, or data integrity
- Software specifications: Research, design, document, and modify software specifications
- Business requirements: Analyze the company's data need and assist in data migration and transformation projects to support business needs
- Collaboration: Work across IT teams and with business users understand the business needs and translate it to implementation.
- Security processes: Develop security processes
- Best practices: Develop and maintain documentation for database schemas, procedures, and best practices
- Standards: Verify that all database programs adhere to the organization’s and performance standards.
Database performance: Assess the effectiveness and performance of database systems and applications
- 5-7 years of experience working in Oracle and DB2 Databases.
- Proven work experience as a Database developer.
- In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
- SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain
- Plan/Query Analyzer/Optimization Tool is required.
- Knowledge of software development and Agile delivery methodology.
- Proficiency in working with specific database like DB2, Oracle & SQL server.
- Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases)
- Excellent analytical and organizational skills.
- Understanding the needs of front-end users and having a problem-solving mindset.
- Excellent verbal and written communication skills
About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation.
California Applicant Notice: SPECTRAFORCE is committed to complying with the California Privacy Rights Act (“CPRA”) effective January 1, 2023; and all data privacy laws in the jurisdictions in which it recruits and hires employees. A Notice to California Job Applicants Regarding the Collection of Personal Information can be located on our website. Applicants with disabilities may access this notice in an alternative format by contacting NAHR@spectraforce.com.
LA County, CA Applicant Notice: If you are selected for this position with SPECTRAFORCE, your offer is contingent upon the satisfactory completion of several requirements, including but not limited to, a criminal background check. We consider qualified applicants with arrest or conviction records for employment in accordance with all local ordinances and state laws, including the Los Angeles County Fair Chance Ordinance for Employers (FCO) and the California Fair Chance Act (FCA). The background check assessment will consider whether a criminal history could reasonably have a direct, adverse impact on the job-related safety, security, trust, regulatory compliance, or suitability for this role. Such findings may result in withdrawal of a conditional job offer.
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $65.00/hr.