Sr. BI Database Engineer

Responsibilities

  • Write complex scripts using Python, Bash, Java to download and manipulate data from internal and external sources
  • Gather and analyze business requirements to build new data jobs and tables, implement automated processes/workflows to support data initiatives both internally and with external marketing partners (DB scheduler, Opswise, etc)
  • Data warehousing knowledge of star schema, snow flake models for large scale storing and reporting of data over historical time periods
  • Create Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency. (PostgreSQL, MySQL, PLSQL)
  • Develop and enhance large features to support our business using Data warehousing tools (MPP Databases, Informatica, Oracle, Greenplum, Microsoft SQL Server, etc)
  • Work on DW models (star schema) and ETL process using SQL and/or other ETL tools
  • Monitor and provide production support for data jobs and processes to maintain data quality and availability

Qualifications

  • Bachelor’s Degree in Computer Science, Engineering or 2 years experience in related field
  • Informatica
  • Oracle
  • Greenplum
  • Microsoft SQL Server, PostgreSQL, MySQL, PLSQL

Options


Back to top