Job Details
Job description:
The Data 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.
ESSENTIAL DUTIES:
- Oversee and review work of team members, as needed or instructed.
- Partner with scrum masters/ project managers on optimizing scheduling, work allocations, and story assignments.
- Manage reporting environment including data sources, connections, security, subscriptions, and metadata.
- Lead in initiative towards data access control and integrity across the enterprise.
- Create data models and schema for reliable and highly performant data marts and data warehouse.
- Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting.
- Evaluate, test and implement new or upgraded software.
- Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.
- Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.
- Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.
TECHNICAL EXPERIENCE:
- Bachelor's degree and/or relevant technical training and certifications.
- Must have 6+ years working as a Developer using Pentaho (PDI, Kettle), HP-Vertica and Tableau
- 4+ years with data modeling creating logical, physical, and conceptual data models.
- 4+ years' experience with data architecture designing data marts, creating source and target mapping documents, etc.