Conexess – Conexess Design Skip to main content

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

Option 1: Create a New Profile