Data Warehouse Architect

Skills
Computer ScienceWarehouse OperationsData IntegrityData StrategiesDatabasesImport OperationsOracle Database
Role

What the job involves

The main requirements, responsibilities and hiring steps.

Requirements

  • Minimum 3 years of experience in data reporting mining business strategy Sales Operations or related field
  • Minimum 2 years of experience with data visualization tools such as PowerBI Tableau or Birst delivering complex reports and dashboards
  • Advanced knowledge of MS Excel MS PowerPoint CRM systems PowerBI and database extraction
  • Knowledge of SQL queries SQL Server Reporting Services SQL Server Integration Services and Python
  • Background in Data Warehouse design including dimensional modeling and data mining
  • Ability to provide forward looking analysis for forecasting and business trending
  • Bachelor’s degree in Business Computer Science Management Information Systems Economics Finance or related field

Nice to have

  • Cross-functional collaboration
  • Excellent analytical skills
  • Strong problem solving
  • Detail oriented
  • Continuous learner
  • Financial acumen

Day to day

  • Partners with Sales Operations IT Sales Management Finance and Marketing to build comprehensive reporting tools that support multiple business units
  • Analyzes cleanses and governs data from varied systems to improve integrity quality and accessibility
  • Designs automates and maintains Power BI dashboards models and reports while supporting leadership with actionable analytics