SQL Data Warehouse Engineer - Nashville Perm 120K in Nashville, TN at Vaco

Date Posted: 7/2/2019

Job Snapshot

Job Description

  • 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 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:

  • multiple years of experience with ETL design & development in data warehouse environments
  • multiple years of experience in Data Warehouse, data modelling, and various data warehousing techniques like star schema, etc.

  • multiple years of experience with SQL and PL/SQL.

  • years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects

  • years of demonstrated knowledge of Agile DW/BI best practices

  • 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