Job Summary:
This Data Analyst position is part of the onsite IT team and will interact directly with the customer and end users while researching data flow and reconciliation issues as well as providing results to frequent ad hoc requests for data in support of customer operations and transaction/financial reconciliation.
Growth can lead onto a Jr DBA role.
Essential Duties and Responsibilities: This list should specifically describe the job duties of the role
- Fulfill ad-hoc data requests from customer. This requires interacting with the customer to fully understand the request as well as being able to clearly explain to the customer the nature of the data and query results.
- Investigate and resolve data flow / reconciliation issues between multiple databases and applications.
- Work with members of development team to validate data and data flows after software changes and/or system enhancements.
- Monitor daily system jobs and reports for issues and resolve any issues found.
- Update systems support documentation regularly.
- Demonstrate regular and predictable attendance during core business hours.
Experience and Skills:
Qualifications/Requirements:
- 5+ years of strong SQL Query generation experience on Oracle RDBMS: knowledge of Oracle PL/SQL script writing is a plus
- 5+ years of strong experience fulfilling customer ad-hoc data requests, producing structured/formatted reports
- 5+ years analysis of data with emphasis on transactional data
- 2+ years of experience with Oracle database servers (10g, 11g, or 12c) is preferred, but not required
- Oracle Professional Certification, is preferred, but not required
- Must possess outstanding verbal and written communication skills
- Must possess strong troubleshooting skills
- 2-3+ years customer facing interaction
- Must be team player, organized, with professional attitude
Educational Requirements:
Bachelor degree in Information Technology or Computer Science
Job Benefits:
ETC offers a valuable benefits program designed with you and your family’s health and wellness in mind.
The following is a non-exhaustive list of some of the benefits offered to full time ETC employees.
- 12 company-paid holidays with one of those days to choose a day special to you
- Generous company-sponsored 401K retirement plan with employer match with 100% vested within two years
- Medical Insurance, with Telemedicine option and a generous medical premium discount
- Dental Insurance
- Vision Insurance
- Pet Insurance
- Multiple Flexible Spending Account (FSA) options
- Employer-paid Life Insurance
- Short-term and long-term disability coverage
- Social, teambuilding and leadership events
- Internal career development and advancement opportunities
- Employee Assistance Program (EAP)
- Legal Shield and Identity Theft Protection
- Gym membership discount
- Military/Reserve Leave
- Employee Referral Program
- Jury Duty and Compulsory Witness Duty time off
- Bereavement Leave
From: Electronic Transaction Consultants