Software Architect (Python, R, SQL, Informatica, GCP, AWS)

MVP Consulting

  • Albany, NY
  • Permanent
  • Full-time
  • 6 days ago
HBITS-07-14243Day-to-day tasks:
  • 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.
Software ArchitectMakes 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.Junior
  • 12 - 36 Months
  • 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.

MVP Consulting