Database Developer

Nexgen Savvy Solutions; Charlotte (AR); On-site; USD 90,000 - 120,000; Full time

Job summary

Nexgen Savvy Solutions in Charlotte, NC invites you to join our data analytics team. You’ll perform data mining across diverse warehouses, build and maintain SSIS ETL processes, and ensure data quality with SOAP UI testing.

You will refine SQL for OBI-style reports and contribute to BI artefacts while collaborating with peers. The role requires a bachelor’s degree in CS/IS/IT and willingness to travel to client locations across the USA.

Qualifications

• Bachelor's degree in computer science, information systems or information technology or equivalent.
• Willingness to travel to client locations across the USA.
• Experience with data warehousing, ETL, BI reporting and QA tooling.

Responsibilities

• Perform data mining across data warehouses and data-marts.
• Create and maintain ETL processes in SSIS.
• QA and test planning with SOAP UI; triage defects.
• Develop and modify SQL for BI reports and metrics.
• Coordinate installations and change management; support end users.

Skills

Data mining

Quality assurance

SQL scripting

ETL development

Data warehousing

SOAP UI

Code review

Database tuning

BI concepts

Data integrity

Education

Bachelor's degree in CS/IS/IT

Tools

SSIS

SOAP UI

Oracle BI / OBI Reports

Job description

View Current Openings

Job Duties And Skills

• Data Mining in various data warehouses and data-marts
• Quality assurance on tools by configuring test plans in SOAP UI, executing test cases, first-level triage of defects found
• Create and maintain ETL process in SSIS
• Conduct peer testing, code review and impact analysis of the script developed by the other members
• Create technical design specifications, database alerts, troubleshoot and resolve technical issues, debug, tune and optimize database performance.
• Write procedures and SQL rules to clean up data
• Develop workflows and procedures to automate the data load from disparate systems and create alerts to trigger the status of the jobs.
• Coordinate application installs and change management.
• Conduct application development sessions and train end users as needed
• Quality assurance on tools by configuring test plans in SOAP UI, executing test cases, first-level triage of defects found
• Drive the analysis, design, and development of databases and BI objects and perform enhancements to current BI artifacts.
• Modify the SQL of the existing OBI reports and write queries to create new metrics
• Contribute to team discussions presenting ideas, sharing knowledge and listening to others ideas.

• Data Mining in various data warehouses and data-marts
• Quality assurance on tools by configuring test plans in SOAP UI, executing test cases, first-level triage of defects found
• Create and maintain ETL process in SSIS
• Conduct peer testing, code review and impact analysis of the script developed by the other members
• Create technical design specifications, database alerts, troubleshoot and resolve technical issues, debug, tune and optimize database performance.
• Write procedures and SQL rules to clean up data
• Develop workflows and procedures to automate the data load from disparate systems and create alerts to trigger the status of the jobs.
• Coordinate application installs and change management.
• Conduct application development sessions and train end users as needed
• Quality assurance on tools by configuring test plans in SOAP UI, executing test cases, first-level triage of defects found
• Drive the analysis, design, and development of databases and BI objects and perform enhancements to current BI artifacts.
• Modify the SQL of the existing OBI reports and write queries to create new metrics
• Contribute to team discussions presenting ideas, sharing knowledge and listening to others ideas.

Required Education: Bachelor’s degree in computer science, computer information systems, information technology or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Work location is Charlotte, NC with required travel to client locations throughout the USA.