Data Warehouse Architect

Data Warehouse Architect Job Description Template

Our company is looking for a Data Warehouse Architect to join our team.

Responsibilities:

  • Design and build Data Warehouse structures (databases and SSAS cubes);
  • Develop unique, simple solutions to meet the immediate and long-term needs of information customers and stakeholders;
  • Develop data architecture, data modeling, and ETL mapping solutions;
  • Support the development and validation required throughout the entire lifecycle of the data warehousing and business intelligence systems;
  • Additional tasks and duties are assigned;
  • Support the data warehouse technical ecosystem, including SharePoint for the delivery of reporting and analytic applications;
  • Ability to present complex topics to key stakeholders, business analysts and senior executives;
  • Ability to document business, functional, and technical requirements;
  • Lead cross-functional teams in developing innovative client solutions;
  • Understanding of cloud data warehouse platforms and modern data warehousing techniques;
  • Troubleshooting the reporting database environment and reports;
  • Provide quality assurance of imported data, working with quality assurance analyst if necessary;
  • Commissioning and decommissioning of data sets;
  • Managing and designing the reporting environment, including data sources, security, and metadata;
  • Generating reports from single or multiple systems.

Requirements:

  • Five or more years of experience as a Data Warehouse architect and ETL developer;
  • At least three years of data modeling experience, and knowledge of 3NF, Star-Schema and other data warehousing modeling techniques;
  • Experience with BI reporting tools (Cognos preferred.);
  • Ability to communicate information clearly, concisely, and effectively both orally and in writing;
  • Five or more years of experience with data analysis and data profiling using SQL and other tools;
  • Extensive experience in T-SQL development, MS SQL Server preferred, with strong knowledge in query optimization;
  • Very strong written and verbal communication skills;
  • Bachelor’s Degree in Computer Science, Engineering or an equivalent hard science and/or Banking Certification in a related field;
  • Big Data and Advanced Analytics Experience;
  • Bachelor’s Degree in related field;
  • Highly motivated, hard-working, excited to learn, and able to motivate others;
  • High-level experience in methodologies and processes for managing large-scale databases;
  • Ability to analyze existing tools and databases and provide software solution recommendations;
  • SQL Server analysis services. Tabular modeling;
  • Azure cloud-based services.