Role Description:

The data architect position is an essential position in all organizations that have software delivery and consume and integrate existing software. Data Architects seek to create best practice guidelines within the groups that consume and manage data and support them in the support of new and existing technologies. Must always be looking ahead to strategically support functional units in adopting technology in a way that provides a competitive advantage while safeguarding and maximizing data.

Job Duties:

• Analyze business requirements and translate them into technical specifications and solutions.
• Lead and mentor development teams and provide technical guidance and support.
• Collaborate with cross-functional teams such as project managers, business analysts, testers, and other architects.
• Create reference architectures for different solutions, cross-company data exchange standards and solutions with functional domains in mind.
• Evaluate products created by external parties and see how their architecture integrates and meets our criteria.
• Ensure compliance with best practices, standards and methodologies for software development and architecture.
• Monitor and continuously improve the quality, performance, and reliability of solutions.
• Identify and mitigate risks of security applications, obsolescence, vulnerabilities, among others.
• Search for emerging technologies and develop proof of concepts in order to bring operational efficiency.
• Ability to manage multiple projects simultaneously with experience in the full project cycle from conception to implementation.
• Ability to identify complex customer issues and propose solutions which bring operational improvement
• Design and modeling of data at different levels and purposes
• Knowledge of data tools in public clouds such as AWS or Azure
• Experience applying architectures for high performance and scalable applications
• Knowledge in deploying applications using modern agile methodologies such as DevOps Experience (Please indicate time and area of expertise required)

Education & Requirements:

• Bachelor's degree in computer science, engineering or related field.
• At least 5 years of experience as a data architect or 10+ years as a developer with experience in different technology stacks or data related initiatives.
• Previous experience in the insurance industry will be highly valued.
• Advanced experience in database design, modeling and optimization and proficiency with data modeling tools.
• Expertise in SQL Server and Oracle administration, optimization, and securitization, including installation, configuration, maintenance, backups, recovery, and performance optimization.
• Experience in design and implementation of enterprise data warehouses and data lakes.
• Working knowledge of Big Data technologies such as Hadoop, Spark, and NoSQL databases (MongoDB, Cassandra).
• Advanced dimensional and relational data modeling in both structured and unstructured data.
• Ability to manage data governance and to configure and manage users, roles, and Security permissions.
• Create and maintain data dictionaries with business rules and data modeling design guidelines.
• Support teams delivering functional projects in their deployment efforts and validating that data is managed appropriately and reviewing data models ensuring integrity and quality in all data collected by functional systems.
• English Intermediate.

Preferred certifications:

• AWS Certified Solutions Architect Professional or Azure Solutions Architect Expert
• TOGAF 9 Certified or ArchiMate 3 Certified Essential Job Duties

SBNA is undertaking a bold digital transformation. The Digital Technical Lead is responsible for collaborating with their respective Product Manager to design and deliver the vision and customer experience for the Bank's Digital customers. (either 1. Customer Onboarding 2.Customer & Account Servicing, 3. Payments or 4. Security). This highly technical role is responsible for understanding, influencing, and enabling the business strategy by deploying the relevant digital technologies. The role is accountable to the Sr. Tech Lead of their Digital workstream, with specific focus on Mobile and Online capabilities across Sales and Service. Delivering and maintaining capabilities to enhance customer experience and satisfaction is key.

The role requires partnership between the business leadership team, local Technology teams, corporate development teams and vendors (for product integrations). The position acts as lynch pin between the business Product Manager, development teams and integration/deployment teams driving delivery, decision making and navigating risks and issues. The successful candidate will be a highly motivated, responsive and results orientated individual with exceptional technical skills, relationship development, communication skills, strong project, financial and management experience.

Job Duties:

• Fosters strong relationships with Digital Product Managers and Owners to promote customer satisfaction and growth. Aligns with, collaborates, and influences business and IT leaders.
• Accountable for all appropriate risk and security measures for the Digital Channels workstream.
• The Digital Technical Lead is responsible for collaborating with their respective Product Manager to design and deliver the vision and customer experience for the Bank's Digital customers. (either 1. Customer Onboarding 2.Customer & Account Servicing, 3. Payments or 4. Security).
• This highly technical role is responsible for understanding, influencing, and enabling the business strategy by deploying the relevant digital technologies.
• The role is accountable to the Sr. Tech Lead of their Digital workstream, with specific focus on Mobile and Online capabilities across Sales and Service.
• Delivering and maintaining capabilities to enhance customer experience and satisfaction is key.

Education & Requirements:

• 5+ years of experience
• Extensive technical background in banking or financial servicing; technical degree; extensive experience working cross functionally with technology and business partners.
• Proven experience of building, defining, and evolving a Digital technical stack definition to support Digital capabilities in the Financial Services or regulated space.
• Demonstrated knowledge of the latest Digital technology innovations.
• Demonstrated relationship management and leadership skills with a superior ability to make things happen through the use of influence and negotiation with all levels of management.
• Strong IT Project/Program Management; experience in evolving an organization from Waterfall to Agil.
• Strong reporting, decision making, analytical and problem-solving skills.
• Highly flexible and able to quickly adapt to changing priorities and ambiguity.
• Highly organized, self-motivated, customer oriented and able to work independently as well as within a team.
• Knowledge of secure coding standards and testing techniques.
• Experience evolving the use of Testing Automation tools such as Selenium and Perfecto.
• Understanding of API definition, development, and integration; experience of leveraging solutions such as API Connect, Apigee, MuleSoft, Spring Boot.
• Proven experience evolving the use of continuous delivery and integration techniques using tools such as Figma, Confluence, JIRA, Jenkins.
• English Intermediate.

Plus:

• Bilingual Spanish/English always a plus.

Title: Data Warehouse Specialist

Summary: In-depth knowledge of data structures, sources, and targets (source and target data), which is crucial for ensuring proper integration and data transformation across different systems. Expertise in developing relational database schemas, including hierarchical databases and star schema models, fundamental for designing effective data warehousing solutions.

Experience in Information Technologies:

• Five (5) years of IT experience in related areas, with a particular focus on data modeling and system development.
• Four (4) years of experience modeling operational systems (OLTP) and data warehousing. The candidate must have specific experience in creating and maintaining databases oriented toward both operational transactions and the storage and analysis of large volumes of data.

Knowledge in Specific Tools and Platforms:

• Four (4) years of experience with Oracle and Microsoft SQL, two of the most widely used enterprise databases, ensuring the candidate can effectively work with existing systems.
• In-depth knowledge of data structures, sources, and targets (source and target data), which is crucial for ensuring proper integration and data transformation across different systems.
• Expertise in developing relational database schemas, including hierarchical databases and star schema models, fundamental for designing effective data warehousing solutions.

Experience with Reporting and Analysis Tools:

• Extensive knowledge in managing computing systems such as Excel, Analysis Services, Business Objects, Web Intelligence, Data Services, and ETL tools. This includes experience with high-performance analysis and reporting tools, essential for the development and support of data infrastructure.

Evaluation of Tools and Data Modeling:

• Experience in evaluating data modeling and data warehousing tools, demonstrating a deep understanding of best practices and available technologies to optimize the management of large data volumes.

Title: Sr. Programmer Analyst

Summary: Extensive experience in in developing and implementing enterprise solutions.  Oracle and SQL programming, including developing and optimizing complex queries, stored procedures, triggers, and views. Expertise in database schema design and performance troubleshooting is essential. Oracle and SQL Server Databases: Practical experience in handling and administering Oracle and SQL Server databases, including maintenance, backup and recovery, and performance tuning.

Experience in Enterprise Solutions Programming:

• Minimum of seven (7) years of experience in developing and implementing enterprise solutions in web environments. Proven track record in creating complex enterprise applications and managing relational databases.

Programming Languages:

• Java: Extensive experience in Java, including large-scale application development, object-oriented architecture design, and performance optimization. Advanced skills in frameworks like Spring or Hibernate are required.
• JavaScript: Strong experience in JavaScript, including developing rich and dynamic interfaces. Knowledge of modern libraries and frameworks such as React, Angular, or Vue.js is highly desirable.

Web Technologies:

• HTML and CSS: Deep knowledge of HTML and CSS for designing and developing effective web interfaces. Experience with preprocessors like Sass or Less and creating responsive designs is essential.
• XML and XPath: Proficiency in using XML for data structuring and XPath for navigating and manipulating XML documents. Experience with XSLT transformations is a plus.
• Web Services: Experience in developing and consuming web services, including SOAP and RESTful APIs. Proficiency in integrating web services and handling data formats like JSON and XML is required.

Database Programming and Management:

• Oracle and SQL: Extensive experience in Oracle and SQL programming, including developing and optimizing complex queries, stored procedures, triggers, and views. Expertise in database schema design and performance troubleshooting is essential.
• Oracle and SQL Server Databases: Practical experience in handling and administering Oracle and SQL Server databases, including maintenance, backup and recovery, and performance tuning.

ETL and Data Integration Tools:

• ETL (Extract, Transform, Load): Experience with tools such as DTS (Data Transformation Services) and SSIS (SQL Server Integration Services). Skilled in creating and managing data integration processes and automating ETL workflows.
• Cloud Platforms: Experience with cloud platforms, specifically Azure Synapse Analytics and Azure Data Factory. Capable of designing, implementing, and optimizing large-scale data processing and analytics solutions using these tools. Must have expertise in creating data pipelines, integrating diverse sources, and efficiently handling large data volumes in cloud environments. Familiarity with best practices and standards in these technologies to ensure efficient and secure processes is indispensable.

Enterprise Content Management (ECM) Tools:

• Knowledge of ECM tools, preferably OnBase by Hyland.
• Experience in managing workflows and implementing business rules using the tool.
• Proficiency with integration tools such as UnityScripts, API, Visual Studio, and C#.