Data Architect 2
Core
Develop, support, and optimize enterprise data warehouses to facilitate reporting and analysis.
Role type
Senior Data Architect
Builds
Data warehouse structures, ETL processes, and data models
Domain
Enterprise data management and analytics
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL, database design, ETL design patterns, data modeling, query optimization, data cleansing, system requirements analysis
Preferred skills
Cloud data storage technologies (Snowflake, Databricks, Azure, AWS), BI tools, leadership on sizable projects
Technologies
Snowflake, Databricks, Azure, AWS, MS Integration Services, Informatica, Microsoft Office
Responsibilities
Design and build data structures to support analysis and reporting; Troubleshoot and optimize existing queries and databases; Maintain data dictionary and documentation; Consult with managerial and systems analysis personnel to clarify intent and suggest changes; Provide guidance to lower-level team members; Analyze and document system requirements for data and workflow.
Seniority
Senior, hands-on IC with supervisory guidance responsibilities
