Data Warehouse Engineer 120K Perm Nashville in Nashville at Vaco

Date Posted: 7/1/2019

Job Snapshot

Job Description

Why is this role critical?
This Sr. Data Warehouse Engineer role is a senior member of the Informatics EDW group which builds and supports the Enterprise Data Warehouse to deliver strategic business value to the organization. The Sr. Data Warehouse Engineer collaborates with product owners to plan and define requirements, and then works with the implementation team to design, develop, test, and maintain a high-performance data warehouse environment. The DW architecture delivers BI capabilities including pre-defined, ad-hoc, dynamic reporting, OLAP analysis, and dashboards as well as data sharing interfaces with other systems.

What you will be accountable for…
  • 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