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)

Rohrer Corporation jobs

Sr. Data Warehouse Engineer