What are the responsibilities and job description for the ETL Datawarehouse Architect position at Donan Consulting?
THE OVERALL PURPOSE OF POSITION:
-
The purpose of this position is to provide support to the IT department.
SCOPE OF WORK
-
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.
-
Conduct end user training on data solutions.
QUALIFICATION AND EXPERIENCE:
-
Bachelor’s degree and/or relevant technical training and certifications.
-
Five (5) to Seven (7) years of directly related experience.
-
Three (3) to Four (4) years of operational and/or technical business leadership experience.
-
Five (5) years of experience with OLAP, industry standard databases, structured query language, ETL, reporting.
-
Three (3) years of experience with data warehouse and data mart design, including Star and Snowflake models.
EDUCATION
-
Bachelor’s degree with a strong academic record.
LENGTH OF EXPERIENCE
-
The minimum amount of total work-related experience required is five (5 ) years, for the position. This means experience in a related area or time spent performing similar work that provides the background for the current position.