Job Description:
A data warehouse architect designs and maintains data management solutions for an organization to store and retrieve processed data. They use their technical and analytical skills to create strategies for data warehouse systems, multidimensional networks, and enterprise databases. They also set standards for database operations, programming, query processes, and security.
Responsibilities:
- Analyze data needs: Understand the company's data needs
- Design data models: Create and optimize data models for warehouse infrastructure and workflow
- Design and implement data warehouses: Design and implement data warehouses, data marts, and data stores while ensuring high levels of data availability
- Select infrastructure components: Evaluate and select all infrastructure components such as software, hardware, database management systems, and networking capabilities
- Develop tools: Develop tools for data mining and data analysis
- Test and improve: Test and improve data warehouse systems, and perform unit, system, performance, and regression testing on ETL mappings
- Report: Report on systems performance and project progress
- Support: Provide technical and business knowledge support to the team, and support and improve production data integration system and environment
- Evangelize: Develop white papers, blogs, reference implementations, labs, and presentations to evangelize design patterns and best practices
Essential Technical Skills:
- SQL (Programming Language)
- Data Warehousing – Concepts, Practice, Architecture, Design and Implementation
- Data Modeling
- Data Management
- Azure
- PowerBI
Other Essential Skills:
- Communications
- Problem Solving
- Leadership
- Management
- Operations
- Trouble Shooting
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)