Data Engineer

Job#: 2076718

Job Description:

Job Description

Essential Duties and Responsibilities include the following. Other duties may be assigned.

The Database Engineer III is responsible for key areas which includes Database programming, application/operations support, rotational on-call service, issue resolution, documentation and departmental support. Additionally, this position:

• Supports database management activities including production data modification requests
• Gains a thorough understanding of functional requirements for new software requests.
• Works with Business Systems Analysts to understand and clarify data change requests, reporting requirements, and new database development requirements.
• Designs, develops and performs testing of software to meet functional requirements.
• Performs process analysis and recommends data and structural changes to improve application performance.
• Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products.
• Partners with software team in the development of the software engineering processes.
• Works to identify and resolves technical or product problems.
• Participates in software project meetings and provides status reports.
• Translates technical designs into working software.
• Maintains up-to-date documentation for all supported data management processes, gathers and reports data related system statistics.
• Collaborates with team members and partners with others as needed to ensure successful completion of assigned database development tasks.
• Participates in code reviews and incorporates recommendations.
• Applies software engineering and Object Oriented Design principles in creating UML diagrams and technical design documents for software components.
• Partners with team members and technical project lead to ensure component design fits in with the overall solution.
• Adopts new techniques and technologies.
• Initiates attendance at job related training to keep skills current; maintains current understanding of the industry's best practices.
• Assists with mentoring and training of less experienced IT staff members.
• Participates in after-hours on-call support rotation; responds to monitoring alerts; implements resolution to avoid or reduce duration of an outage; escalates issues per policy to higher tier support resources and management as necessary.

Supervisory Responsibilities

No supervisory responsibilities

Client Responsibilities

This is an internal (and external to IT) client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

BS/BA and 6+ years' experience or equivalent combination of education and experience, and 2 years of SME in respective areas. Prior PBM or healthcare experience is helpful but not required.

Computer Skills - Demonstrable skills required in the following areas

• Six (6) plus years of experience with Database design, data mapping between cross functional application, and best practices for data pipelines
• Six (6) plus years of experience in development of database processes using functions, procedures, triggers, views in Oracle, MSSQL, PostGreSQL and Unix shell scripting
• Excellent knowledge of debugging, tuning and optimizing performance of database queries
• Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications
• Strong experience in designing database objects using partitioning and sharding.
• Strong experience in maintaining data per data retention policy
• Strong experience in in data provisioning with masking and anonymization for lower environment.
• Strong ETL and data modelling experience
• Strong proficiency in database interfacing and relational database management systems.
• Strong technical and analytical skills

Certificates, Licenses, Registrations

None required

Other Skills and Abilities

• Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
• Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions.
• Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences.
• Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines

Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Mathematical Skills

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs.

Reasoning Ability

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

• Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events.
• Analytical - Synthesizes complex or diverse information; Collects and researches data; Identifies data relationships and dependencies; uses intuition and experience to analyze data and relationships; designs workflows and procedures.
• Business Acumen - Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals.
• Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
• Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals. Completes tasks on time or notifies appropriate person with an alternate plan.
• Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.
• Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
• Technical Skills - Demonstrates required skills; Adapts to new technologies; Troubleshoots technical problems; Uses technology to increase productivity; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others; Exhibits ability to learn and apply new skills; Keeps abreast of current developments; Displays understanding of how job relates to others.

Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate.

Work Location

This position must work on-site at the San Diego Headquarters or at the Tempe, Arizona site for purposes of providing adequate support to internal clients; being available for face-to-face interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as for facilitation of quick and effective decisions through collaboration with stakeholders. Remote work is not an option for these purposes.

Working Hours

This is an exempt level position requiring one to work the hours needed to get the job done. Therefore one must have the flexibility to work beyond traditional hours and be able to work nights, weekends or on holidays as required. This may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.