Software Architect

The Software Architect leads and builds data modernization and transformation solutions.

The Software Architect will also work with technical leads, database administrators, and database developers to provide recommendations and solutions for like-for-like data migrations at scale, Extract/Transform/Load activities for multiple data and database technologies, such as Oracle to PostgreSQL, Oracle to SQL Server as a Service, relational to NoSQL, Data Warehouse to Data Lake solutions, Indexed file systems to database management systems, and data transformation of business rules between COTS systems.

Other responsibilities include transforming business requirements into technical specifications, developing prototypes and proof of concepts for specified business challenges, and assisting clients in architecting scalable, highly available data migration solutions leveraging cloud technologies and utilizing agile development methodologies. Expected to have knowledge and/or experience in the following with focus on data ETL activities: RDBMS (Oracle, PostgreSQL, SQL Server, Amazon RDS, etc), Data Lake technologies, Data Transformation tools (IBM InfoSphere DataStage, Informatica PowerCenter, Microsoft SSIS, Oracle Data Integrator) XML, JSON, NoSQL, Python.