Fidelity Corp
Cloud-Based Systems Design Position
Produces scalable, resilient, cloud-based systems design using multiple methodologies -- data warehousing, data visualization, and data integration. Simplifies online transaction processing (OLTP) using relational database technologies (Oracle SQL and PL/SQL) and Snowflake. Constructs and compares models using data modeling tools and data ingestion tool sets, including Apache NiFi and Kafka. Sets up reliable infrastructure to perform data-related tasks, particularly with Kafka, to stream analytics. Delivers and supports cloud strategies including migrating legacy products and implementing software as a service (SaaS) integrations (for data-sharing purposes). Designs, develops, and modifies software systems to predict and measure outcomes and consequences of design, using scientific analysis and mathematical models. Primary responsibilities: Crafts and implements operational data stores and data lakes in a production environment. Coordinates project functionality, using DevOps and Continuous Integration/Continuous Delivery (CI/CD) methodologies and tools. Performs deep data analysis on multiple database platforms hosted in AWS and Azure. Develops data pipelines to move data to and from Snowflake and AWS cloud resources, using Python. Analyzes information to determine, recommend, and plan installation of a new system or modification of an existing system. Monitors functioning of equipment to ensure system operates in conformance with specifications. Determines system performance standards. Confers with systems analysts and other software engineers/developers to design systems and obtain information on project limitations and capabilities, performance requirements, and interfaces. Develops and maintains software system testing and validation procedures, programming, and documentation. Assists in establishing and maintaining industry standards in systems and security. Education and experience: Bachelors 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 data engineer (or closely related occupation) designing data applications in cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle). Or, alternatively, masters 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 data engineer (or closely related occupation) designing data applications in cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle). Skills and knowledge: Demonstrated expertise performing data movement processes (migration, ingestion, and sync-up) for legal, compliance, risk, and security applications, using Python, Kubernetes, and Snowflake. DE implementing Snowflake data lake, stored procedure, views, relationships, and flows for legal, compliance, risk, and security applications on a cloud platform, using custom connectors; and implementing Power BI reports using Snowflake and Oracle. DE implementing data components (databases, tables, views, types, stored procedures, functions, roles, and queries) for legal, compliance, risk, and security applications on relational databases (Oracle), using SQL and PL/SQL queries. DE implementing enterprise level job scheduling and creating compliance aggregate reports for legal, compliance, risk, and security applications on a customer identification program, using Control-M.
Produces scalable, resilient, cloud-based systems design using multiple methodologies -- data warehousing, data visualization, and data integration. Simplifies online transaction processing (OLTP) using relational database technologies (Oracle SQL and PL/SQL) and Snowflake. Constructs and compares models using data modeling tools and data ingestion tool sets, including Apache NiFi and Kafka. Sets up reliable infrastructure to perform data-related tasks, particularly with Kafka, to stream analytics. Delivers and supports cloud strategies including migrating legacy products and implementing software as a service (SaaS) integrations (for data-sharing purposes). Designs, develops, and modifies software systems to predict and measure outcomes and consequences of design, using scientific analysis and mathematical models. Primary responsibilities: Crafts and implements operational data stores and data lakes in a production environment. Coordinates project functionality, using DevOps and Continuous Integration/Continuous Delivery (CI/CD) methodologies and tools. Performs deep data analysis on multiple database platforms hosted in AWS and Azure. Develops data pipelines to move data to and from Snowflake and AWS cloud resources, using Python. Analyzes information to determine, recommend, and plan installation of a new system or modification of an existing system. Monitors functioning of equipment to ensure system operates in conformance with specifications. Determines system performance standards. Confers with systems analysts and other software engineers/developers to design systems and obtain information on project limitations and capabilities, performance requirements, and interfaces. Develops and maintains software system testing and validation procedures, programming, and documentation. Assists in establishing and maintaining industry standards in systems and security. Education and experience: Bachelors 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 data engineer (or closely related occupation) designing data applications in cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle). Or, alternatively, masters 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 data engineer (or closely related occupation) designing data applications in cloud using Python and databases (Snowflake, Azure Dataverse, and Oracle). Skills and knowledge: Demonstrated expertise performing data movement processes (migration, ingestion, and sync-up) for legal, compliance, risk, and security applications, using Python, Kubernetes, and Snowflake. DE implementing Snowflake data lake, stored procedure, views, relationships, and flows for legal, compliance, risk, and security applications on a cloud platform, using custom connectors; and implementing Power BI reports using Snowflake and Oracle. DE implementing data components (databases, tables, views, types, stored procedures, functions, roles, and queries) for legal, compliance, risk, and security applications on relational databases (Oracle), using SQL and PL/SQL queries. DE implementing enterprise level job scheduling and creating compliance aggregate reports for legal, compliance, risk, and security applications on a customer identification program, using Control-M.