Data analyst - consultant

Oracle; Madison (WI); On-site; USD 87,000 - 179,000; Full time

Job summary

Join Oracle as an ETL Developer, where you'll manage data pipelines and ensure data quality in a dynamic work environment. This role involves defining processes, building data architectures, and validating data against business requirements. Benefit from a comprehensive package including medical, dental, and a flexible vacation policy.

Benefits

Medical, dental, and vision insurance

401(k) Savings and Investment Plan with company match

Flexible Vacation policy

Paid sick leave

Paid parental leave

Qualifications

• Strong analytical skills and proficiency in scripting languages.
• Ability to liaise with stakeholders to understand requirements.

Responsibilities

• Define the ETL process and system architecture.
• Validate and clean data before loading it into the target system.
• Perform manual and automation testing of data.

Skills

Analytical skills

Python scripting

Job description

Job Description

ETL (extract, transform, and load) jobs involve managing data pipelines, building data warehouses, and ensuring data quality.

ETL developer responsibilities

Process management

Define the ETL process, including data processing boundaries and system architecture

Data warehouse

Define the architecture and tools for loading data into the warehouse

Data modeling

Read, analyze, and transform data to determine how to represent it in the warehouse

Data quality

Validate and clean data to meet quality standards before loading it into the target system

Data pipeline creation

Develop tools that organize and filter data so that end-users can find and use it

Data storage

Determine the storage needs of the business and analyze options to find the best fit

ETL tester responsibilities

Data verification: Verify data, spot anomalies, and ensure data meets business requirements

Testing: Perform manual and automation testing of data sources, extraction, transformation, and loading

ETL skills

Strong analytical skills

Proficiency in scripting languages such as Python scripting

Liaising with the business stake holders to understand the requirements and craft the data strategy

Responsibilities

ETL (extract, transform, and load) jobs involve managing data pipelines, building data warehouses, and ensuring data quality.

ETL developer responsibilities

Process management

Define the ETL process, including data processing boundaries and system architecture

Data warehouse

Define the architecture and tools for loading data into the warehouse

Data modeling

Read, analyze, and transform data to determine how to represent it in the warehouse

Data quality

Validate and clean data to meet quality standards before loading it into the target system

Data pipeline creation

Develop tools that organize and filter data so that end-users can find and use it

Data storage

Determine the storage needs of the business and analyze options to find the best fit

ETL tester responsibilities

Data verification: Verify data, spot anomalies, and ensure data meets business requirements

Testing: Perform manual and automation testing of data sources, extraction, transformation, and loading

ETL skills

Strong analytical skills

Proficiency in scripting languages such as Python scripting

Liaising with the business stake holders to understand the requirements and craft the data strategy

Disclaimer:

Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from: $87,000 to $178,100 per annum. May be eligible for bonus and equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’s differing products, industries and lines of business.

Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:

1. Medical, dental, and vision insurance, including expert medical opinion

2. Short term disability and long term disability

3. Life insurance and AD&D

4. Supplemental life insurance (Employee/Spouse/Child)

5. Health care and dependent care Flexible Spending Accounts

6. Pre-tax commuter and parking benefits

7. 401(k) Savings and Investment Plan with company match

8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.

9. 11 paid holidays

10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.

11. Paid parental leave

12. Adoption assistance

13. Employee Stock Purchase Plan

14. Financial planning and group legal

15. Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

Career Level - IC3

About Us

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s challenges. We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

We know that true innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing an inclusive workforce that promotes opportunities for all.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [e-mail] or by calling [phone] in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.