Principal DBA - SQL, Oracle, Azure Synapse We are looking for Principal Database Administrator to lead an enterprise team undergoing a period of significant growth. After a strong 2023, this insurance organisation is expanding their technical services teams across their multi-platform environment. Working across Microsoft SQL, Oracle DB and Azure Synapse, you will direct this support team, achieving greater operational efficiency across a large estate. The successful candidate will have worked across on-prem Microsoft and Oracle environments, along with exposure to cloud-based services. You'll be a strong communicator and mentor and be comfortable as a technical point of escalation within the database team. This is a great opportunity to lead a team in a very successful financial services company, without the people management responsibilities. You'll be excited by the chance to really scale up this organisation's estate, whilst consistently ensuring stability and security. Whilst insurance sector experience is preferred, experience from other financial services will be considered. Responsibilities Lead a team of Database Administrators as technical expert for enterprise environments Act as escalation point whilst mentoring and supporting team members Support a large multi-platform environment across SQL, Oracle and Synapse Maintain integrations with group-wide applications Work collaboratively with multiple internal departments Requirements Excellent ability in T-SQL, P/L SQL and Powershell Strong knowledge in MS SQL, SSRS, SSIS and SSAS Experience in 24/7 and on-call environments Certification in ITIL along with Microsoft and/or Oracle Awareness of Nutanix tooling, along with Dell DDBoost or Veeam is a bonus Principal DBA - SQL, Oracle, Azure Synapse
03/05/2024
Full time
Principal DBA - SQL, Oracle, Azure Synapse We are looking for Principal Database Administrator to lead an enterprise team undergoing a period of significant growth. After a strong 2023, this insurance organisation is expanding their technical services teams across their multi-platform environment. Working across Microsoft SQL, Oracle DB and Azure Synapse, you will direct this support team, achieving greater operational efficiency across a large estate. The successful candidate will have worked across on-prem Microsoft and Oracle environments, along with exposure to cloud-based services. You'll be a strong communicator and mentor and be comfortable as a technical point of escalation within the database team. This is a great opportunity to lead a team in a very successful financial services company, without the people management responsibilities. You'll be excited by the chance to really scale up this organisation's estate, whilst consistently ensuring stability and security. Whilst insurance sector experience is preferred, experience from other financial services will be considered. Responsibilities Lead a team of Database Administrators as technical expert for enterprise environments Act as escalation point whilst mentoring and supporting team members Support a large multi-platform environment across SQL, Oracle and Synapse Maintain integrations with group-wide applications Work collaboratively with multiple internal departments Requirements Excellent ability in T-SQL, P/L SQL and Powershell Strong knowledge in MS SQL, SSRS, SSIS and SSAS Experience in 24/7 and on-call environments Certification in ITIL along with Microsoft and/or Oracle Awareness of Nutanix tooling, along with Dell DDBoost or Veeam is a bonus Principal DBA - SQL, Oracle, Azure Synapse
Head of BI - SSIS, SSRS, SQL Server, CRM Do you want to work for a business that is truly making a difference to peoples lives? A healthcare charity are looking for a new head of database development and BI, to lead their BI function whilst developing, delivering and leveraging their 2 CRM systems. Acting as a Project manager for system upgrades, data warehouse deliveries etc. Key Responsibilities - Create annual database and BI operating plans, taking responsibility for the annual budget and plan for the database and BI function. - Develop, implement and review data platform strategy, including potential migration to cloud-based solutions like Microsoft Azure, etc. - Line-manage Database developer & BI analyst roles and CRM training specialist - Be a key member of the digital transformation group. - Oversee Database administration. - Ensure continued availability of the data systems - Oversee, challenge and sign off new business requirements relating to changes in the CRM systems and data warehouses. - Revising the suitability of the data warehouse and its associated data model, refining the design of the data models where required. - Liaise with CRM/SQL vendors. - Ensure all datasets have appropriate levels of data governance and maintain up-to date knowledge of GDPR and legislation. - Oversee the management of CRM/BI/Data warehouse issues. - Be the key contact for database queries. - Optimise use of SQL, SSIS,SSRS, Microsoft Visual Studio, etc Essential Skills - Degree educated (or equivalent experience) in a relevant field - Advanced knowledge of SQL, including building complex queries and administrative scripts - Data validation and manipulation techniques using SQL, Visual Basic (including Excel macros, linked workbooks and pivot tables) - Experience in programming languages commonly used for data analysis, such as Python, R or Scala. - Advanced knowledge of ETL tools such as SSIS, SSRS MS Visual Studio, SQL Server 2008R2 and 2017, stored procedures, and the associated implementation of automations. - Strong requirements specification and documentations skills and project management experience. - Knowledge of current and evolving tends in data and information management. - Excellent communication and interpersonal skills with the ability to provide and receive complex and often sensitive information. - Professional, confident approach able to engage with colleagues at all levels. Head of data/Data warehouse/Database Administrator/Database Administration/DBA/CRM/Salesforce
03/05/2024
Full time
Head of BI - SSIS, SSRS, SQL Server, CRM Do you want to work for a business that is truly making a difference to peoples lives? A healthcare charity are looking for a new head of database development and BI, to lead their BI function whilst developing, delivering and leveraging their 2 CRM systems. Acting as a Project manager for system upgrades, data warehouse deliveries etc. Key Responsibilities - Create annual database and BI operating plans, taking responsibility for the annual budget and plan for the database and BI function. - Develop, implement and review data platform strategy, including potential migration to cloud-based solutions like Microsoft Azure, etc. - Line-manage Database developer & BI analyst roles and CRM training specialist - Be a key member of the digital transformation group. - Oversee Database administration. - Ensure continued availability of the data systems - Oversee, challenge and sign off new business requirements relating to changes in the CRM systems and data warehouses. - Revising the suitability of the data warehouse and its associated data model, refining the design of the data models where required. - Liaise with CRM/SQL vendors. - Ensure all datasets have appropriate levels of data governance and maintain up-to date knowledge of GDPR and legislation. - Oversee the management of CRM/BI/Data warehouse issues. - Be the key contact for database queries. - Optimise use of SQL, SSIS,SSRS, Microsoft Visual Studio, etc Essential Skills - Degree educated (or equivalent experience) in a relevant field - Advanced knowledge of SQL, including building complex queries and administrative scripts - Data validation and manipulation techniques using SQL, Visual Basic (including Excel macros, linked workbooks and pivot tables) - Experience in programming languages commonly used for data analysis, such as Python, R or Scala. - Advanced knowledge of ETL tools such as SSIS, SSRS MS Visual Studio, SQL Server 2008R2 and 2017, stored procedures, and the associated implementation of automations. - Strong requirements specification and documentations skills and project management experience. - Knowledge of current and evolving tends in data and information management. - Excellent communication and interpersonal skills with the ability to provide and receive complex and often sensitive information. - Professional, confident approach able to engage with colleagues at all levels. Head of data/Data warehouse/Database Administrator/Database Administration/DBA/CRM/Salesforce
Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell We are supporting a Global Specialty Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Engineer is required to develop automated solutions in support of a multi-platform environment. In an ever-evolving business, you will have the opportunity to shape the database system & infrastructure, allowing the business to capitalize on streamlined & automated processes. Working alongside a brand-new team of DBAs and Database Architects, you will be a key player in the development & support of SQL, Oracle and Azure databases. You will have excellent T-SQL & PowerShell programming, deep Microsoft Suite knowledge and supporting Database systems & migrations. This is an excellent opportunity to join a brand-new team and design & maintain scalable and robust databases for a truly Global business Responsibilities: Design, implement & support Database infrastructure & administration solutions Collaborate with DBA and application teams to ensure database performance, reliability and scalability Support code repository for the DBA team - ensuring code is up-to-date and functional Set standards and policies for best database practice & identify opportunities for improvement Participate in the evaluation of toolings, utitiles and applications to assist DBAs Requirements: Experience providing database development & support for SQL Server and Oracle Proven experience supporting the migration of database systems to Azure Deep understanding of Microsoft SQL, SSRS, SSIS and SSAS. Knowledge of Oracle is also desirable Strong programming knowledge including T-SQL and PowerShell Proven background in supporting relationship Database Management System architecture Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell
03/05/2024
Full time
Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell We are supporting a Global Specialty Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Engineer is required to develop automated solutions in support of a multi-platform environment. In an ever-evolving business, you will have the opportunity to shape the database system & infrastructure, allowing the business to capitalize on streamlined & automated processes. Working alongside a brand-new team of DBAs and Database Architects, you will be a key player in the development & support of SQL, Oracle and Azure databases. You will have excellent T-SQL & PowerShell programming, deep Microsoft Suite knowledge and supporting Database systems & migrations. This is an excellent opportunity to join a brand-new team and design & maintain scalable and robust databases for a truly Global business Responsibilities: Design, implement & support Database infrastructure & administration solutions Collaborate with DBA and application teams to ensure database performance, reliability and scalability Support code repository for the DBA team - ensuring code is up-to-date and functional Set standards and policies for best database practice & identify opportunities for improvement Participate in the evaluation of toolings, utitiles and applications to assist DBAs Requirements: Experience providing database development & support for SQL Server and Oracle Proven experience supporting the migration of database systems to Azure Deep understanding of Microsoft SQL, SSRS, SSIS and SSAS. Knowledge of Oracle is also desirable Strong programming knowledge including T-SQL and PowerShell Proven background in supporting relationship Database Management System architecture Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses, data messaging, data modelling, data science, etc. The company wants someone with 10+ years of data architect/engineering/DBA work experience. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Qualifications: 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead Bachelor's degree or higher in a technical field Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC Experience in solution integration and operability. Experience working with Infrastructure Technologies and Teams. Experience using Service-now or similar
01/05/2024
Full time
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses, data messaging, data modelling, data science, etc. The company wants someone with 10+ years of data architect/engineering/DBA work experience. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Qualifications: 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead Bachelor's degree or higher in a technical field Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC Experience in solution integration and operability. Experience working with Infrastructure Technologies and Teams. Experience using Service-now or similar
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses, data messaging, data modelling, data science, etc. The company wants someone with 10+ years of data architect/engineering/DBA work experience. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Qualifications: 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead Bachelor's degree or higher in a technical field Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC Experience in solution integration and operability. Experience working with Infrastructure Technologies and Teams. Experience using Service-now or similar
01/05/2024
Full time
*Hybrid, 3 days onsite, 2 days remote* *We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Principal, Data Architecture. This principal will focus on data architecture and design to support all IT departments throughout the company. These responsibilities include design of data lakes, data warehouses, data messaging, data modelling, data science, etc. The company wants someone with 10+ years of data architect/engineering/DBA work experience. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Qualifications: 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead Bachelor's degree or higher in a technical field Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC Experience in solution integration and operability. Experience working with Infrastructure Technologies and Teams. Experience using Service-now or similar
Request Technology - Craig Johnson
Chicago, Illinois
*We are unable to sponsor for this permanent Full time role* *Position is bonus eligible* Prestigious Financial Company is currently seeking a Principal Data Architect with Kafka and Data Lakes experience. Candidate will be responsible for data architecture and design to support all IT areas of the business. This role will establish standards, coordinate solution design with subject matter owners, document and design solutions and ensure strategic goals are met at the operational level. The role will be a primary contributor to the Joint Technology Strategy and oversee and conduct evaluations of technology and process during proofs-of-concept/value. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Advises team of IT technology standards requirements, methodologies, and processes. Drives short and long term architecture strategy for the overall IT project portfolio for key business segments. Responsible for comprehensive infrastructure designs including all aspects of IT. Participates in proof of concepts to assist in defining technology direction and enabling business strategy. Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Responsible for impact analysis and design modifications of existing systems to support new solutions and integrations. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Communicate and coordinate between IT, Application Development, Operations, and Management. Uses traditional and Agile project/product approaches to execute projects and achieve business outcomes. Drive business results through process and informal leadership. Qualifications: Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions [Required] Ability to prioritize critical versus non-critical issues and communicate effectively to management. [Required] Proven ability to contribute consistently and positively in a dynamic, fast-paced, and highly regulated environment. [Required] Proven ability to facilitate project alignment between business and technical teams. [Required] Demonstrated ability to dig beyond the surface to uncover root causes and offer solutions that could deliver effective and efficient outcomes. [Required] Experience operating in a collaborative environment to solve cross-functional problems. [Required] Self-directed and detail oriented. [Required] Highly effective organization and planning skills. Technical Skills: Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC [Required] Experience in extracting and developing technical requirements from business goals and needs. [Required] Experience in solution integration and operability. [Required] Experience working with Infrastructure Technologies and Teams. [Required] Proficiency in using Microsoft Office products (Word, Excel, PowerPoint, Visio) [Required] Experience using Service-now or similar [Required] 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead [Preferred] Bachelor's degree or higher in a technical field [Preferred] Process improvement certifications such as Lean/Six Sigma [Preferred] IT service or process management certifications such as ITIL or ITAM
01/05/2024
Full time
*We are unable to sponsor for this permanent Full time role* *Position is bonus eligible* Prestigious Financial Company is currently seeking a Principal Data Architect with Kafka and Data Lakes experience. Candidate will be responsible for data architecture and design to support all IT areas of the business. This role will establish standards, coordinate solution design with subject matter owners, document and design solutions and ensure strategic goals are met at the operational level. The role will be a primary contributor to the Joint Technology Strategy and oversee and conduct evaluations of technology and process during proofs-of-concept/value. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Advises team of IT technology standards requirements, methodologies, and processes. Drives short and long term architecture strategy for the overall IT project portfolio for key business segments. Responsible for comprehensive infrastructure designs including all aspects of IT. Participates in proof of concepts to assist in defining technology direction and enabling business strategy. Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Responsible for impact analysis and design modifications of existing systems to support new solutions and integrations. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Communicate and coordinate between IT, Application Development, Operations, and Management. Uses traditional and Agile project/product approaches to execute projects and achieve business outcomes. Drive business results through process and informal leadership. Qualifications: Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions [Required] Ability to prioritize critical versus non-critical issues and communicate effectively to management. [Required] Proven ability to contribute consistently and positively in a dynamic, fast-paced, and highly regulated environment. [Required] Proven ability to facilitate project alignment between business and technical teams. [Required] Demonstrated ability to dig beyond the surface to uncover root causes and offer solutions that could deliver effective and efficient outcomes. [Required] Experience operating in a collaborative environment to solve cross-functional problems. [Required] Self-directed and detail oriented. [Required] Highly effective organization and planning skills. Technical Skills: Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC [Required] Experience in extracting and developing technical requirements from business goals and needs. [Required] Experience in solution integration and operability. [Required] Experience working with Infrastructure Technologies and Teams. [Required] Proficiency in using Microsoft Office products (Word, Excel, PowerPoint, Visio) [Required] Experience using Service-now or similar [Required] 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead [Preferred] Bachelor's degree or higher in a technical field [Preferred] Process improvement certifications such as Lean/Six Sigma [Preferred] IT service or process management certifications such as ITIL or ITAM
*We are unable to sponsor for this permanent Full time role* *Position is bonus eligible* Prestigious Financial Company is currently seeking a Principal Data Architect with Kafka and Data Lakes experience. Candidate will be responsible for data architecture and design to support all IT areas of the business. This role will establish standards, coordinate solution design with subject matter owners, document and design solutions and ensure strategic goals are met at the operational level. The role will be a primary contributor to the Joint Technology Strategy and oversee and conduct evaluations of technology and process during proofs-of-concept/value. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Advises team of IT technology standards requirements, methodologies, and processes. Drives short and long term architecture strategy for the overall IT project portfolio for key business segments. Responsible for comprehensive infrastructure designs including all aspects of IT. Participates in proof of concepts to assist in defining technology direction and enabling business strategy. Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Responsible for impact analysis and design modifications of existing systems to support new solutions and integrations. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Communicate and coordinate between IT, Application Development, Operations, and Management. Uses traditional and Agile project/product approaches to execute projects and achieve business outcomes. Drive business results through process and informal leadership. Qualifications: Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions [Required] Ability to prioritize critical versus non-critical issues and communicate effectively to management. [Required] Proven ability to contribute consistently and positively in a dynamic, fast-paced, and highly regulated environment. [Required] Proven ability to facilitate project alignment between business and technical teams. [Required] Demonstrated ability to dig beyond the surface to uncover root causes and offer solutions that could deliver effective and efficient outcomes. [Required] Experience operating in a collaborative environment to solve cross-functional problems. [Required] Self-directed and detail oriented. [Required] Highly effective organization and planning skills. Technical Skills: Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC [Required] Experience in extracting and developing technical requirements from business goals and needs. [Required] Experience in solution integration and operability. [Required] Experience working with Infrastructure Technologies and Teams. [Required] Proficiency in using Microsoft Office products (Word, Excel, PowerPoint, Visio) [Required] Experience using Service-now or similar [Required] 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead [Preferred] Bachelor's degree or higher in a technical field [Preferred] Process improvement certifications such as Lean/Six Sigma [Preferred] IT service or process management certifications such as ITIL or ITAM
01/05/2024
Full time
*We are unable to sponsor for this permanent Full time role* *Position is bonus eligible* Prestigious Financial Company is currently seeking a Principal Data Architect with Kafka and Data Lakes experience. Candidate will be responsible for data architecture and design to support all IT areas of the business. This role will establish standards, coordinate solution design with subject matter owners, document and design solutions and ensure strategic goals are met at the operational level. The role will be a primary contributor to the Joint Technology Strategy and oversee and conduct evaluations of technology and process during proofs-of-concept/value. Responsibilities: Design the data architecture of organization to support data driven vision Create design and blueprint of the data capabilities for the organization within the data framework Analyze structural requirements for new solutions and applications Optimize new and current database systems Responsible for requirements-based analysis and selection of data tools Responsible for setting up and enforcement of Data Modeling standards Responsible for creating logical and conceptual data models Ensure that data architecture principles are adhered to across the enterprise Assist in building data taxonomy and aligning it with business processes Work with Data Governance, IT, and data stewards on design of the strategic solution to data quality issues Advises team of IT technology standards requirements, methodologies, and processes. Drives short and long term architecture strategy for the overall IT project portfolio for key business segments. Responsible for comprehensive infrastructure designs including all aspects of IT. Participates in proof of concepts to assist in defining technology direction and enabling business strategy. Communicates and validates program architecture with infrastructure, project management and technology services teams. Conducts end to end technical plan design. Develop enterprise standards to ensure compatibility and integration of platforms in a multi-vendor platform environment. Design and develop infrastructure and solution documentation and blueprints. Responsible for impact analysis and design modifications of existing systems to support new solutions and integrations. Develops specifications for solutions integrations. Maintain documentation library on standard procedures and approved solution configurations. Communicate and coordinate between IT, Application Development, Operations, and Management. Uses traditional and Agile project/product approaches to execute projects and achieve business outcomes. Drive business results through process and informal leadership. Qualifications: Experience in design of data lake/warehouse solutions, preferably in the cloud Experience in schema design for relational and non-relational data and messaging protocols Experience in design of data science and data analytics solutions [Required] Ability to prioritize critical versus non-critical issues and communicate effectively to management. [Required] Proven ability to contribute consistently and positively in a dynamic, fast-paced, and highly regulated environment. [Required] Proven ability to facilitate project alignment between business and technical teams. [Required] Demonstrated ability to dig beyond the surface to uncover root causes and offer solutions that could deliver effective and efficient outcomes. [Required] Experience operating in a collaborative environment to solve cross-functional problems. [Required] Self-directed and detail oriented. [Required] Highly effective organization and planning skills. Technical Skills: Experience with Kafka and Protocol Buffers Expertise in both SQL and No SQL databases Expertise with BI tools (Tableau, Power BI etc) Expertise with federated query tools such as Presto/Trino Experience with data lake file formats such as Avro, Parquet, ORC [Required] Experience in extracting and developing technical requirements from business goals and needs. [Required] Experience in solution integration and operability. [Required] Experience working with Infrastructure Technologies and Teams. [Required] Proficiency in using Microsoft Office products (Word, Excel, PowerPoint, Visio) [Required] Experience using Service-now or similar [Required] 10+ years of progressive experience leading to a Senior-level Data Architect, Data Engineer, DBA, consultant, technical lead [Preferred] Bachelor's degree or higher in a technical field [Preferred] Process improvement certifications such as Lean/Six Sigma [Preferred] IT service or process management certifications such as ITIL or ITAM
Request Technology - Craig Johnson
Chicago, Illinois
*There is no sponsorship for this 6 month contract role* Prestigious Financial Institution is currently seeking a Sr. Performance Testing Engineer with SDET experience. Candidate will be on a team that is responsible for the operationalization of new projects as it pertains to performance testing and other processes that will be necessary to maintain the new system when it goes live. Duties will include but not limited to parallel testing, creating test automation processes that will simplify the parallel testing process. UAT Testing and documenting test results. Responsibilities: Requirements analysis and requirements gathering as it relates to test planning End to End Test planning and execution Assist with the standing up of on-prem and AWS test platforms Assist with the creation of best practices deployment processes Assist with the development of automated testing processes that will simplify our parallel testing process (Encore Versus RTC) Work with our business partners on in the development of test plans and test cases Prepare documentation needed for any automated process and other testing procedures created (test plans, architecture/design) Participates in test results reviews, proactively identifying and mitigating potential issues and defects as well as assisting with continuous improvement Drives continuous improvement efforts by identifying and championing practical means of reducing time to market while maintaining high quality Must be a willing self-starter, independent and comfortable with a fast paced, dynamic environment A team player who assists the team as required to achieve collective goals & delivery milestones including knowledge-share Embraces and advocates for Agile best practices for software development discipline (be true to Agile Manifesto) Actively participates in creation and review of both business and technical user stories, providing constructive feedback and input on both work effort estimation as well as architecture/design improvements Participating in innovative design and proof of concepts with emerging technologies and solutions Embrace industry best practices like continuous integration, continuous deployment, automated testing, TDD etc. Follows agreed upon SDLC procedures to ensure that all information system products and services meet both explicit and implicit quality standards, end-user functional requirements, architectural standards, performance requirements, audit requirements, security rules are upheld, and external facing reporting is properly represented. Performs application and project risk analysis and recommends quality improvements. Assists Production Support by providing advice on system functionality and fixes as required Assist with departmental and new employee training Qualifications: Requires an in-depth knowledge of a development life cycle. Must be competent at the highest technical level in all phases of application development and implementation and testing Requires good communication, analytical, sound judgment and management skills Ability to work effectively with clients, management, and staff. 7+ years experience with SQL to maintain, create and retrieve information from structured or unstructured data stores. Ability to quickly resolve complex data issues in accessing, updating, manipulating, inserting, and modifying data efficiently. Functional and technical specifications creation knowledge Leadership capabilities Knowledge of QA best practices (system, regression, unit, performance) Good organization skills and documentation creation Intellectually curious and eager to learn BS degree in Computer Science, similar technical field required. Masters degree preferred.
29/04/2024
Project-based
*There is no sponsorship for this 6 month contract role* Prestigious Financial Institution is currently seeking a Sr. Performance Testing Engineer with SDET experience. Candidate will be on a team that is responsible for the operationalization of new projects as it pertains to performance testing and other processes that will be necessary to maintain the new system when it goes live. Duties will include but not limited to parallel testing, creating test automation processes that will simplify the parallel testing process. UAT Testing and documenting test results. Responsibilities: Requirements analysis and requirements gathering as it relates to test planning End to End Test planning and execution Assist with the standing up of on-prem and AWS test platforms Assist with the creation of best practices deployment processes Assist with the development of automated testing processes that will simplify our parallel testing process (Encore Versus RTC) Work with our business partners on in the development of test plans and test cases Prepare documentation needed for any automated process and other testing procedures created (test plans, architecture/design) Participates in test results reviews, proactively identifying and mitigating potential issues and defects as well as assisting with continuous improvement Drives continuous improvement efforts by identifying and championing practical means of reducing time to market while maintaining high quality Must be a willing self-starter, independent and comfortable with a fast paced, dynamic environment A team player who assists the team as required to achieve collective goals & delivery milestones including knowledge-share Embraces and advocates for Agile best practices for software development discipline (be true to Agile Manifesto) Actively participates in creation and review of both business and technical user stories, providing constructive feedback and input on both work effort estimation as well as architecture/design improvements Participating in innovative design and proof of concepts with emerging technologies and solutions Embrace industry best practices like continuous integration, continuous deployment, automated testing, TDD etc. Follows agreed upon SDLC procedures to ensure that all information system products and services meet both explicit and implicit quality standards, end-user functional requirements, architectural standards, performance requirements, audit requirements, security rules are upheld, and external facing reporting is properly represented. Performs application and project risk analysis and recommends quality improvements. Assists Production Support by providing advice on system functionality and fixes as required Assist with departmental and new employee training Qualifications: Requires an in-depth knowledge of a development life cycle. Must be competent at the highest technical level in all phases of application development and implementation and testing Requires good communication, analytical, sound judgment and management skills Ability to work effectively with clients, management, and staff. 7+ years experience with SQL to maintain, create and retrieve information from structured or unstructured data stores. Ability to quickly resolve complex data issues in accessing, updating, manipulating, inserting, and modifying data efficiently. Functional and technical specifications creation knowledge Leadership capabilities Knowledge of QA best practices (system, regression, unit, performance) Good organization skills and documentation creation Intellectually curious and eager to learn BS degree in Computer Science, similar technical field required. Masters degree preferred.