Principal Architect

Position Description:

Implements cloud-based data strategy including database design, ETL/ELT Pipelines, Data Lakes, automation, and orchestration. Designs and develops data warehouse and data lake ETL/ELT pipelines using data integration frameworks and tools -- Informatica, Python, Spark, and SpringBatch. Utilizes DevOps and Continuous Integration/Continuous Delivery (CI/CD) pipeline technologies including Jenkins, uDeploy, Concourse, and Datadog to automate pipelines. Uses Agile methodologies including Scrum and Kanban to implement DevOps software development to perform data application development. Uses relational database technologies such as Oracle and Snowflake.

Primary Responsibilities:

• Architects and designs end-to-end data solutions and software applications.

• Works closely with business partners and technology teams to understand business objectives and helps to define the appropriate software architecture direction for them.

• Architects, designs, and builds highly scalable analytical and reporting applications.

• Utilizes data management standard methodologies such as data integration, data security, data warehouses, data analytics, metadata management, and data quality.

• Evaluates, prototypes, and recommends emerging data technologies and platforms.

• Designs, develops, and modifies software systems; and uses scientific analysis and mathematical models to predict and measure outcomes and consequences of design.

• Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces.

• Develops and oversees software system tests and validation procedures, programs, and documentation.

Education and Experience:

Bachelor’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience as a Principal Architect (or closely related occupation) performing architecture and application design using Cloud technologies in a financial services environment.

Or, alternatively, Master’s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience as a Principal Architect (or closely related occupation) performing architecture and application design using Cloud technologies in a financial services environment.

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise (“DE”) designing and developing end-to-end Cloud based data solutions and software applications using AWS Cloud, and Python, Spark, Java, or Spring Batch; and designing and developing data warehouse, data lakes, ETL or ELT pipelines, and database using Oracle, PostgreSQL, or Snowflake.

• DE designing, developing, and architecting databases using data management standard methodologies -- data integration, data security, metadata management, and data virtualization – using Kafka, and Java, Python, or Delphix; and architecting, designing, and building highly scalable operational, analytical, and reporting applications using AWS Cloud or Snowflake, and APIs or Batch frameworks.

• DE evaluating and prototyping data technologies and AWS tools (Aurora, Athena, Batch, DynamoDB, or EMR), and Snowflake; designing high availability data architecture solutions for disaster recovery using Cloud technologies -- AWS or Snowflake; and creating data architecture blueprints using ETL tools and real time RESTful APIs.

• DE developing DevOps practices using Continuous Integration and Continuous Delivery tools (CI/CD) pipeline technologies -- Jenkins, uDeploy, Concourse, GitHub, or Datadog; and implementing DevOps software to perform data application development according to Agile methodologies -- Scrum or Kanban.

#PE1M2