Sr. Oracle Data Warehouse Engineer
- Job Title
- Sr. Oracle Data Warehouse Engineer
- Job ID
- 27317819
- Location
- Brentwood, TN
- Other Location
- Description
-
- Create Oracle PL/SQL packages, complex stored procedures, partitioned tables, ad-hoc queries to support development and business needs.
- Assist other database engineers with the day-to-day activities, including databases maintenance such as installation, backup, restore and security control.
- Collaborate with stakeholders to plan and deploy new database releases.
- Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries.
- Troubleshoot production support issues in the application environments.
- Work as a part of a development team to implement product enhancements
- Collaborate with BI developers and product managers on delivery of reporting initiatives.
- Extract data from disparate sources and transform into internal formats for loading into our platform.
- Perform technical analysis and requirements definition with our partners on service integrations.
- Work as a part of an Agile team to implement product enhancements.
- Perform other duties and responsibilities as required, assigned, or requested.
What you will need to be successful in this role…
- Bachelor’s degree in computer science or related field
- At least 10 years of experience with ETL design & development in data warehouse using traditional SQL databases like Oracle
- At least 5 years of experience in Data Warehouse, data modelling, and various data warehousing techniques like star schema, etc.
- At least 5 years of experience with ANSI-SQL and Oracle PL/SQL. Must have expertise in SQL
- At least 5 years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects
- At least 3 years of demonstrated knowledge of Agile DW/BI best practices
- At least 5 years of experience database design and architecture for relational/NoSQL database is a plus
- Familiarity with database design and architecture for data warehouse is a plus
- Experience with architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems is a big plus
- Understanding of quality assurance and data quality principals as applied to an ETL architecture is a plus
- Critical thinking abilities to take complex, ambiguous, abstract requirements and break them into smaller components, patterns, views and features
- Strong ability to communicate technical and data concepts to non-technical audiences, and business concepts to technical audiences
- Strong analytical, organizational, verbal communication and business writing skills
#LI-RB1