Data Architect

Data Ideology•Pittsburgh, PA

7d•Remote

About The Position

We are looking for a Data Architect to join our growing team. Data Architect will leverage their business and technical knowledge to develop production-ready data models by integrating multiple data sources while working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.

Requirements

Proven understanding of Data warehousing, Data Architecture, and BI.
Experience with data pipelines and architecture/engineering.
Knowledge of modern apps and data platforms.
Cloud-based project implementation.
Google BigQuery experience
BI/Data Warehousing (3+ years) - Google BigQuery
Cloud platforms (1+ years) - Google Cloud Platform
Dimensional Data Modeling ( 3+ years)
ETL (3+ years)
SQL (3+ years)
Busienss Intelligence (1+ years) - Power BI

Responsibilities

Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse plan.
Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions that leverage these modeling techniques.
Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints.
Ability to define and implement best practices across database design and ETL.
Ability to direct the work of others, including but not limited to directing ETL development, demonstrating an understanding of key concepts of ETL/ELT, including best practices for optimization and scheduling.