Database Administrator / Database Engineer

LanceSoft Inc; Waukesha (WI); On-site; USD 90,000 - 120,000; Full time

Job summary

A nationwide workforce solutions company is seeking a Sr. Data Engineer to assist business teams with data analytics and develop scalable database solutions. This role requires strong expertise in SQL and Oracle, along with experience in software development and data analytics. The ideal candidate will have a Bachelor's degree in Computer Science or a related field, and at least 4 years of experience in designing and optimizing SQL queries. Join our team to contribute to innovative data solutions that drive business value.

Qualifications

• 4+ years of experience designing and implementing SQL queries and optimizing performance.
• 2+ years of experience working on Oracle data administration.
• Experience in software development and the software development lifecycle.

Responsibilities

• Ensure translation of requirements into database architecture/design.
• Design and develop data layers and data stores.
• Monitor database performance and tune as necessary.

Skills

SQL queries

Data analytics

Java

Problem solving

Communications

Education

Bachelor degree in Computer Science or Engineering

Tools

Oracle

Unix

Job description

• Contract

Company Description

In business since 2000, LanceSoft is a nationally certified Minority Business Enterprise (MBE) that has established itself as a pioneer in providing highly scalable, cost-effective workforce solutions to a diverse set of customers across various industries in the United States. Headquartered in Virginia, LanceSoft currently operates out of several locations in the US and Canada.

Job Description

The Sr. Data Engineer will also be responsible for assisting business teams with data analytics needs, working with Global Services Data Architect to make sense out of the vast amount of machine data collected over time.

Duties include (but are not limited to):

• Application development - ensure translation of requirements into a logical and physical database architecture/design needs
• Application development – participate in cross-functional and global application teams to design and develop data layers and data stores (data services in Java, stored procedures in Oracle)
• Application development – educate and mentor peers and application teams on best practices on data management
• Production support – database performance monitoring, troubleshooting, and tuning
• Data analytics – explore data sets and identify data transformation and data quality needs for targeted applications
• Data analytics – implement known data engineering tasks including transformation, quality remediation and report, audit, optimization for storage and retrieval
• Data analytics – develop analytics / algorithms / rules to derive insight and business value

Quality Specific Goals:

• Aware of and comply with the GEHC Quality Manual, Quality Management System, Quality Management Policy, Quality Goals, and applicable laws and regulations as they apply to this job type/position
• Complete all planned Quality & Compliance training within the defined deadlines
• Identify and report any quality or compliance concerns and take immediate corrective action as required
• Ensure compliance/closure of Regulatory and Quality requirements before approving Design Outputs/Program Deliverables
• Lead continuous improvement activities by driving the implementation of process and product quality improvement initiatives

Qualifications

• Bachelor degree in Computer Science or Engineering, or closely related fields
• 4+ years of experience designing and implementing SQL queries, stored procedures, and optimizing their performance
• 2+ year of experience working on Oracle data administration
• Experience in software development and the software development lifecycle
• Experience with batch processing and large databases
• Expertise in one or more analytics software tools and packages
• Familiar with data modeling and physical database design
• Familiar with Unix
• Strong communications (written and verbal) and problem solving skills
• Ability to work independently, with limited information

Preferred Qualifications:

• Familiar with Agile software development methodology
• Experienced with developing with Java
• Healthcare Services domain knowledge
• Experience / familiarity with Remote Monitoring & Diagnostics
• Basic knowledge of project planning and execution
• Demonstrated experience with regulatory compliance process, and quality management process in the context of software development
• Experience in working with global teams and users across the world