What are the responsibilities and job description for the Data Architect -(Only USC/GC) position at Programmers.io?
This job is Onsite role at Cleveland OH
Visa Required - USC / GC
Job Summary :
We are seeking an experienced and highly motivated Data Architect to design and manage our data architecture, ensuring it meets the needs of our business and supports our analytics, reporting, and operational goals. The ideal candidate has a strong background in data modeling, database design, and data integration, as well as experience with cloud-based data platforms and emerging technologies.
Primary Roles and Responsibilities
- Design, develop, and implement effective database solutions for storing and retrieving company data including tables, views, stored procedures, functions, and other database objects.
- Create and maintain data warehouses. Design and optimize data flows across multiple ETL processes and technology platforms.
- Collaborate with developers, analysts, and various end users to understand business requirements, translate requirements into technical specifications, and develop project plans.
- Ensure data quality and integrity by implementing data testing and validation processes.
- Troubleshoot and optimize existing SQL queries for performance improvements, reduce redundancies, and streamline data flows.
- Support and enhance existing databases, programs, ETLs, and integrations.
- Write clean, maintainable, and well-documented data designs and programs.
