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.