Data warehouse Architect

THE OVERALL PURPOSE OF POSITION:  

• The Data warehouse Architect will spearhead the design and development of a new, high performance enterprise data warehouse for the organization, using industry best practices and data modeling techniques.  

SCOPE OF WORK  

• The position’s SCOPE OF WORK include the following:  

• Collaborate with important stakeholders, including division-based data stewards as well as technical system owners to establish an understanding of the organization’s vast processes and data.  

• Design and implement an efficient and adaptable data model to support data exploration, data science, analytics, and GIS, resulting in insights to inform key business decisions.  

• Actively participate in process improvement initiatives and in setting best practice standards around Data Architecture, Metadata, Governance, Master Data Management, and Data Quality flows.  

• Proactively investigate opportunities to increase the value of the data to the business while focusing on projects that improve business processes.  

• Designs, builds and maintains flexible and scalable data warehouse solutions to support Business Intelligence (BI) and Reporting projects.  

• Provides expertise in the creation and refinement of agile technical stories for data architecture and development.  

• Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models).  

• Helps to develop, implement, and maintain appropriate data governance on the data warehouse and associated metadata for purposes of data quality, integrity, availability, and security.  

• Proactively monitors and analyzes performance to identify and recommend optimizations.  

• Coordinates with team members and leads the implementation of Master Data Management, in conjunction with the new data warehouse.  

• Leads the integration of the data warehouse with a modern, leading business intelligence platform.  

QUALIFICATION AND EXPERIENCE:                     

• Bachelor’s degree (master’s degree preferred) and relevant technical training and relevant technical training and certifications.  

• Five (5) to Seven (7) years of directly related experience.  

• One (1) to Two (2) years of business leadership experience.  

• Five (5) or more years of recent Data Warehouse Architecture experience to build and articulate conceptual, logical and physical dimensional data models and third normal form artifacts.  

• Five (5) or more years of experience with business intelligence technologies and solutions.  

• Five (5) or more years of experience leading teams on IT initiatives, particularly those related to big data.  

• Two (2) or more years of experience with leading data quality tools.  

CORE COMPETENCIES  

• Forward Thinking: The ability to anticipate the implications and consequences of situations and take appropriate action to be prepared for possible contingencies.  

• Thinks Critically: The ability to approach one’s work analytically by identifying issues/questions, gathering and evaluating data, and creating evidence-based recommendations or solutions.  

• Embrace Innovation & Change: The ability to respond positively to change and demonstrate flexibility, and openness to new ways of thinking and doing things.  

• Communicate Openly & Effectively: The ability to effectively communicate in multiple modes and in a way that fosters understanding and dialogue, as well as engages with others in a way that demonstrates emotional intelligence.  

• Performance Focused: The ability to take ownership for one’s own or one’s employees’ performance, by setting clear goals and expectations, tracking progress against the goals, providing  feedback, and addressing performance problems and issues promptly.  

• Apply Customer Lens: The ability to provide the best service to customers (internal and external) with the goal of exceeding their expectations while maintaining integrity.  

• Develop Self & Others: The ability to identify, learn, and apply new skills or habits as needed to perform successfully on the job.  

• Foster Collaboration: The ability to look beyond immediate teams, broaden peer networks, and finding ways to partner with internal and external stakeholders to achieve success.