Data Architect (Python, R, PostgreSQL, Informatica)
- New York City, NY Albany, NY
- Permanent
- Full-time
The Architect will be working with the Data Management Team designing, implementing, and optimizing Master Data Management (DM) solutions.
- Design and implement scalable DM solutions, including data modeling, data quality, governance, and integration strategies.
- Guide the definition and implementation of DM architecture principles and design patterns for various styles, ensuring smooth data publishing and subscribing for applications.
- Utilize programming languages (Python, R, SQL) for data manipulation, analysis, and process automation.
- Design and implement ETL/ELT pipelines using tools like Informatica.
- Build and deploy DM solutions and integrations on cloud platforms such as GCP and AWS.
- Analyze existing DM architectures and develop roadmaps for optimization.
- Research emerging DM trends and refine technology strategy.
- Act as a business analyst, gathering requirements, performing fit-gap analysis, and preparing documentation.
- Identify automation opportunities in data conversion and integration processes to improve efficiency.
- Ensure adherence to data governance policies and security measures.
- Collaborate with stakeholders to understand data requirements and resolve issues.
- Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large-scale software system.
- 24 months experience in DM architecture, data modeling, governance, and data quality.
- 24 months experience in Python, R, and SQL (PostgreSQL) and DM tools like Informatica and ETL/ELT processes.
- Bachelor's degree in a relevant field.
- 24 months experience with building and deploying solutions on AWS and GCP, including relevant cloud services.
- 24 months experience in Python, API and Webservices for data integration
- 24 months experience in conducing fit-gap analysis, document requirements, and facilitate workshops.
- 24 months experience identifying and implementing automation for process improvement.
- 24 months experience working in a government setting.