Data Architect- experience with Ascend.io tool needed

Data Architect

Remote (Local to California Preferred)

Duration : 12 months Contract

Pay Rate : $80/hr W2 or $85/hr C2C / 1099

Note : Must have experience with Asced.io tool

1. Architect and implement scalable, high-performance data warehouse and medallion architectures for analytics and reporting needs.
2. Develop or understand the conceptual, logical, and physical data models for both structured and unstructured data, ensuring alignment with business requirements.
3. Lead the development of ETL/ELT frameworks and processes to integrate data from various sources into the warehouse and medallion layers.
4. Design and implement robust data integration pipelines using tools like Google Cloud Platform Cloud Composer, Airflow, and Informatica.
5. Develop and optimize ETL/ELT processes to integrate data from multiple sources into the data warehouse.
6. Ensure data integrity, security, and compliance by implementing governance policies, encryption, and access controls.
7. Optimize database performance through query tuning, indexing, and storage strategies for maximum efficiency.
8. Work closely with data engineers, analysts, and business stakeholders to align architecture with business needs.
9. Implement data validation, cleansing, and quality control processes to ensure reliable and accurate data.

Must Have:

• Any ETL tools, Google Cloud Platform, Airflow, Data Modeling, Python, GBQ, SQL

Preferred:

• Collibra, Ascend, Vertex AI, DBT, Docker, GitLab, Machine Learning, Oracle, DB2

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.