Data Warehouse Architect Job Description
Data warehouse architect
provides expertise in data analysis, data migration tools, data modelling, data integration, data warehousing and database design.
Data Warehouse Architect Duties & Responsibilities
To write an effective data warehouse architect job description, begin by listing detailed duties, responsibilities and expectations. We have included data warehouse architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Create COBOL, DB2, Informatica, Linux, Teradata and Oracle code artifacts
Meet with various IT groups (other departments and computer operations' staff) to address issues/concerns
Interact closely with Business Analysis team, ETL team and BI Reporting teams to ensure understanding of proper use of data architecture
Analyze requirements to create technical designs, data models and migration strategies
Design, build, and maintain physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration strategies
Evaluate and influence selection of data warehouse and business intelligence software
Collaborate with technology stakeholders to define and implement actionable metrics, KPIs and data visualizations
Lead technical design and implementation of dashboards and reporting capabilities
Implement data quality, data integrity, and data standardization efforts across products and databases enabling key business processes and applications
Recommend improvements to enhance existing ETL and data integration processes to enable performance and overall scalability
Data Warehouse Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Data Warehouse Architect
List any licenses or certifications required by the position: AWS, MCDBA, RDBMS, CFA
Education for Data Warehouse Architect
Typically a job would require a certain level of education.
Employers hiring for the data warehouse architect job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Education, Information Systems, Technical, Technology, Math, Mathematics, Business, Information Technology
Skills for Data Warehouse Architect
Desired skills for data warehouse architect include:
Relational databases
Data warehousing
Analytics technologies
Information systems technology management
Informatica
Design and development of data warehouses
Of Oracle
Of business intelligence tools
Of large data repositories
Of the analysis
Desired experience for data warehouse architect includes:
Experience with ETL tools such as SAP Data Services
Experience with API based integration tools such as Mulesoft, Snaplogic, Cast Iron
Highly developed verbal and written communication and presentation skills, with demonstrated ability to translate technical information to a non-technical audience at all levels of the organization
Data Analyst / Architect for development activities for Enterprise Data warehouse on MVS and Linux platforms
Provide support and participate analysis, design, coding, development and testing processes
Support On-call for sustainment and development activities as a Data Custodian
Data Warehouse Architect Examples
1
Data Warehouse Architect Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data warehouse architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data warehouse architect
- Proactive speakers on the calls, co-ordinate the development work with offshore, quickly gain familiarity with new applications
- Ability to multitask on multiple projects in various phases
- Participate in technical forums, change approval board and get all desired approvals before code migrations to production
- Candidate should possess excellent problem solving abilities and data analysis
- Motivated and self-driven with focus customer satisfaction
- Able to work on multiple projects with different stake holders
- Investigate production related issues and provide workaround/fixes for issues as per SLA
- Exposure to one of biggest DW of world
- Exposure to multiple lines of business (Cable/Mobility/fixed line) under same DW, nowhere in this line you will get exposure to such diverse line of business
- Join us to be part of a proud team to create dynamic solutions for business
Qualifications for data warehouse architect
- Experience with large-scale data integration and reporting
- Understanding of data requirements in complex environments
- 10+ years of experience as a Data Warehouse Engineer or Architect
- 3+ years of experience with Big Data solutions
- Demonstrated knowledge of current Big Data and analytics solution platforms such as HANA, Teradata, Oracle, MS SQL, Hadoop, Spark and other Big Data knowledge a plus
- Experience with various technologies, frameworks and processes, such as data modeling, data flow mapping, requirements gathering, testing and data validation techniques
2
Data Warehouse Architect Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of data warehouse architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse architect
- Support the growth of healthcare analytics practice
- Conduct analysis of business process, data and systems
- Understand, design and create physical and logical data models to meet business needs
- Develop and document overall data sourcing, data transformation and semantic layer designs
- Consult and advise technical analysts during development process
- Guide test plan creation
- Troubleshoot, diagnose and work within a team to resolve problems in data marts
- Identify and recommend database performance solutions and standards
- Provide 24x7 on call support as needed for data warehouse issues that require immediate resolution
- Participate in the development process (if needed) by implementing integration or semantic design
Qualifications for data warehouse architect
- Expert communication skills and passion to mentor others
- Solid understanding of systems engineering in relation to creating a high performance BI architecture which will efficiently use CPU, memory, storage, caching, IO
- Analyze their operational and analytical data requirements by working with business and applications teams across markets and geographies
- Identify and profile data quality and data curation methods for public data sources, payment behavior data sources and syndicated data sources
- Identify data enrichment requirements for statistical data appends, third party data appends, derived attribute data appends
- Evangelize the use of data quality metrics and best practices from ingest to delivery
3
Data Warehouse Architect Job Description
Job Description Example
Our company is growing rapidly and is looking for a data warehouse architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for data warehouse architect
- Manages the planning and delivery of data warehouse and storage architecture
- Manages relationships stays capable of working with software and hardware vendors to understand the potential architectural impact of different vendor strategies
- Travel to client location as required
- Drive architectural alignment across multiple delivery partners for key and complex initiatives
- Establish strategic alliances, and lead joint ventures with key IT suppliers and business partners that proactively drive business opportunities for the organization
- Communicate and effectively articulate the end-to-end solution/roadmaps to business and technical delivery teams
- Partner with solution architects to align various project architectures with the overall vision and standards outlined
- Drive architectural and roadmap alignment at the IT leadership level and additionally across the CIO and CTO organizations
- Investigate complex strategic business issues, researching and identifying innovative solutions
- Partner closely with Business Analysts, Product Capability Managers, Technical Leads, other Solution Architects and vendors to ensure alignment with projects, programs and strategies, and standards
Qualifications for data warehouse architect
- Understanding of data modeling and use of modeling tools a plus, Erwin, Data Modeler
- Scientific computing experience
- Experience with additional industry standard ETL tools (Pentaho )
- Higher degree in IT studies
- Minimum 3 years of experience in DWH/ETL area
- Solid knowledge of platforms
4
Data Warehouse Architect Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of data warehouse architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse architect
- Serve as a subject matter expert on SAP HANA, SAP Business Warehouse, Microsoft SQL Server and related technologies
- Develop standard patterns for how to best utilize SAP HANA and Microsoft SQL Server analytics within an enterprise data management landscape
- Work on complex issues where analysis of situations or data requires an in-depth evaluation of various factors
- Plan and establish SAP HANA and Microsoft SQL Server technology standards and usage frameworks
- Actively support a Global BI COE Architecture organization
- Align with project teams to provide solution architecture
- Manage/mentor project team members
- Collaborate with technology vendors
- Stay current with the latest technology in in-memory, big data, social media, mobility and cloud computing
- Participate in creating of department/project budgets
Qualifications for data warehouse architect
- Fluent command of SQL
- Knowledge of leading ETL tools
- Knowledge of banking services business model would be an asset
- Provides domain expertise in modern business intelligence and self-service data visualization tools
- Provides domain expertise of open-source and commercial relational DBMS (Oracle, SQL Server, PostgreSQL, AWS RDS, Azure) and NoSQL databases
- Proficiency with relational database technology
5
Data Warehouse Architect Job Description
Job Description Example
Our growing company is hiring for a data warehouse architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for data warehouse architect
- Solves complex problems and develops proofs of concept to validate ideas or technologies
- Helps support the system and troubleshoots system related issues
- Design and shape the business intelligence data architecture, ensuring high performance of the delivered project by rationalising data processing, and ensuring the design meets industry best practice
- Co-ordinate communication across teams with delivery responsibility
- Strong scripting skills (PowerShell, Python)
- Interface with senior business and technology leaders to identify their data & analytics requirements
- Set direction and define architecture patterns and reference models for target state integrated data store designs
- Provide DW/BI environment collaborative leadership to DW Data Architect, ETL Lead, and BI Architect to align overall DW/BI environment architecture with DW/BI component architectures
- Ensure alignment of data models within the enterprise data warehouse environment across conceptual, logical, and physical data models, whether overall or project/iteration level data models
- Provide end-to-end oversight across projects to ensure Data Models and ETL/BI designs align to standards and best practices for achieving maximum consistency, performance and efficiency of the DW/BI ecosystem
Qualifications for data warehouse architect
- Minimum of five (5) years of experience as a dedicated Data Warehouse Architect, with expertise in Designing and Developing Data Models for Enterprise Data Warehouses is required
- Bachelor's degree AND 5+ years' experience as a lead architect for large scale data warehouse implementations
- Excellent documentation skills, ability to produce diagrams and schematics that visualize technical solutions.In-depth understanding of DW implementation best practices and application development best practices (SDLC methodology)
- At least 5 years experience as a DW architect, delivering solutions for large (multi-terabyte) projects that integrate many diverse technologies and products
- Demonstrate exemplary teamwork skills excellent interpersonal skills
- Experience with TSQL stored procedures, views, tables and triggers