דרושים Applications Development Sr Programmer Analyst ב-Citi Group ב-United States, Houston

Citi’s Functions Technology is responsible for delivering Technology solutions to Citi's Functions organizations. Functions Technology mission is to optimize Citi's Technology environment by delivering world class applications, driving standardization of the production environment, reducing complexity, optimizing management of systems supporting global functions such as Compliance, Controls, Internal Audit and Risk, and introducing innovative technologies that provide new business capabilities, reduce the technology total cost of ownership, and create a competitive advantage for Citi.

The Senior Solutions Architect is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits. Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.

• Analyzes system / application architecture; ensures that architecture conforms to enterprise blueprints and patterns.

• 3+ years knowledge of Java, Angular, ORaaS, microservices, authentication/authorization, and applying patterns.

• Evaluates and tests potential IT architecture solutions to ensure they meet user needs and requirements.

• Creates and produces moderately complex IT architecture designs to translate user requirements to solutions.
• Researches and produces standards documents.
• Researches future industry trends; acts as resource for development staff regarding the use of new technologies.
• Applies hardware engineering and software design theories and principles in researching, designing, and developing product hardware and software interfaces.
• Translates complex business problems into sound technical solutions.
• Exhibits sound understanding of concepts and principles in architecture and basic knowledge of these elements in other areas.
• Requires in-depth understanding of how the area integrates within architecture and has basic commercial awareness.
• Trains and mentors junior team members.
• Uses evaluative judgment based on the analysis of factual information in complicated or novel situations; uses multiple sources of information.
• Has direct impact to the architecture area by ensuring the quality of the tasks/services/ information provided by self and others.
• Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.
• Performs other job duties and functions as assigned
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

• 6+ years relevant solution architecture experience

• 5+ years hardware engineering and software design

• Consistently demonstrates clear and concise written and verbal communication
• Management and prioritization skills
• Ability to develop working relationships, manage multiple activities and changing priorities
• Self-starter with ability to take the initiative and master new tasks quickly
• Methodical, attention to detail

• Bachelor degree or equivalent experience

Anticipated Posting Close Date:

Duties: Conduct requirement analysis and system design. Work with the product managers and business users to understand the requirements, identify, document, and execute the database technical work needed for the end product, monitor, and maintain the database application. Collaborate with business team and product managers to discuss the business requirements for effective systems database design. Design data systems to serve use cases based on factors such as performance and reliability. Create technical design document, which includes both high-level design and low-level design. Responsible for development, including designing and developing database programs, and executing coding and development tasks. Conduct unit and integration testing. Develop data models, database objects, and related artifacts. Serve as a subject matter expert to provide technical solutions and support to developers. Perform code reviews to ensure quality in the deliveries. Estimate and allocate the resources and capacity planning. Create individual tasks, estimate the development and testing efforts of those tasks and coordinate with product management team in order to support the overall of project delivery. Create business stories, tasks, and subtasks using Jira, and provide estimates in story points against each individual Jira. Provide ground level estimates by dividing the bigger chunk into smaller tasks using Jira tool. Decide delivery dates based on the resource availability, capacity planning, and book of work given by business. Prepare reports and correspondences concerning project specifications, activities, and status. Responsible for performing production releases and monitoring the stability of the production database. Perform CD/CI. Perform data analysis with structured, semi-structured and unstructured data. A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with Citi policies and protocols.

Requirements: Requires a Master’s degree, or foreign equivalent, in Applied Computer Science, Computer Engineering, Computer Applications, or related field and 4 years of experience as a Technology Lead, Software Developer, Senior SQL Server/BI Developer, BI Consultant or related position creating automated test cases and validating steps to ensure software quality. Alternatively, employer will accept a Bachelor’s degree in the stated fields and 6 years of the specified progressive post-baccalaureate experience. Full span of experience must include: Database design and scripting for data storage, transformation, ingestion and retrieval; Identifying bottlenecks, and performance tuning the database queries; Developing security measures in post implementation analysis of business usage; Maintaining data integrity and security through access controls and encryption techniques; Creating database tasks to satisfy business requirements, documenting database solutions and test cases; Data profiling and developing data quality rules, data modeling (Relational, Dimensional, NoSQL), and Extract Transform Load (ETL) data patterns; Delivering database objects through SIT, UAT and Production; Source version control; and SQL, PL/SQL, T-SQL, Microsoft SQL Server (MSSQL) 2012 and higher, RDBMS Oracle 12c and higher. Applicants submit resumes at https://jobs.citi.com/. Please reference Job ID #25861863. EO Employer.

Wage Range: $163,100 to $163,100

Anticipated Posting Close Date:

Citi’s Functions Technology is responsible for delivering Technology solutions to Citi's Functions organizations. Functions Technology mission is to optimize Citi's Technology environment by delivering world class applications, driving standardization of the production environment, reducing complexity, optimizing management of systems supporting global functions such as Compliance, Controls, Internal Audit and Risk, and introducing innovative technologies that provide new business capabilities, reduce the technology total cost of ownership, and create a competitive advantage for Citi.

The Senior Solutions Architect is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits. Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.

Responsibilities:

• Analyzes system / application architecture; ensures that architecture conforms to enterprise blueprints and patterns.

• 3+ years knowledge of Java, Angular, ORaaS, microservices, authentication/authorization, and applying patterns.

• Evaluates and tests potential IT architecture solutions to ensure they meet user needs and requirements.

• Creates and produces moderately complex IT architecture designs to translate user requirements to solutions.

• Researches and produces standards documents.

• Researches future industry trends; acts as resource for development staff regarding the use of new technologies.

• Applies hardware engineering and software design theories and principles in researching, designing, and developing product hardware and software interfaces.

• Translates complex business problems into sound technical solutions.

• Exhibits sound understanding of concepts and principles in architecture and basic knowledge of these elements in other areas.

• Requires in-depth understanding of how the area integrates within architecture and has basic commercial awareness.

• Trains and mentors junior team members.

• Uses evaluative judgment based on the analysis of factual information in complicated or novel situations; uses multiple sources of information.

• Has direct impact to the architecture area by ensuring the quality of the tasks/services/ information provided by self and others.

• Exhibits sound and comprehensive communication and diplomacy skills to exchange complex information.

• Performs other job duties and functions as assigned

• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 6+ years relevant solution architecture experience

• 5+ years hardware engineering and software design

• Consistently demonstrates clear and concise written and verbal communication

• Management and prioritization skills

• Ability to develop working relationships, manage multiple activities and changing priorities

• Self-starter with ability to take the initiative and master new tasks quickly

• Methodical, attention to detail

:

• Bachelor degree or equivalent experience

Primary Location Full Time Salary Range:

In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.

Anticipated Posting Close Date:

The

Responsibilities:

• Conduct tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establish and implement new or revised applications systems and programs to meet specific business needs or user areas

• Monitor and control all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users

• Utilize in-depth specialty knowledge of applications development to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement

• Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality

• Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems

• Ensure essential procedures are followed and help define operating standards and processes

• Serve as advisor or coach to new or lower level analysts

• Has the ability to operate with a limited level of direct supervision.

• Can exercise independence of judgement and autonomy.

• Acts as SME to senior stakeholders and /or other team members.

• The candidate will be responsible for building and managing senior and junior ETL developers.

• Work directly with global application development teams, Operations teams/partners to successfully integrate.

• Will work with team and manage deliverables, provide architectural guidance, enforce best Citi practices, conduct code reviews, build support processes, and serve as escalation point during production outages.

• Keep up to date with new technologies and their possible adoption within ISG

• Work on streamlining processes and work closely with other team members, onsite and remote to ensure consistent approach to development/process is used within the application.

• Work with vendor teams to Coordinate and manage key projects.

• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 5-8 years of relevant experience

• Experience in systems analysis and programming of software applications

• Experience in managing and implementing successful projects

• Working knowledge of consulting/project management techniques/methods

• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements

• Knowledge and experience of managing reference data sytems.

• Knowledge of Securities and Pricing data.

• Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle

• Strong command of ETL architecture and Tools (Abinitio), and working with relational databases

• Experience of working in a demanding and results driven, time critical environment

• All potential candidates must be able to work in a dynamic team environment which includes working and managing teams on different technologies (such as Java, Web Services and C#/.NET) and across multiple regions

• Ab Initio GDE and Co>Op (Continuous, Batch, Plans)
• Data Stage
• UNIX/Linux Shell scripting
• Oracle concepts, SQL, PL/SQL
• SQL performance tuning
• Autosys• Data modeling
• Knowledge of advance Ab Initio components
• Tibco EMS and other message oriented middleware
• XML/XSD/XSLT
• Web Services
• Java SE
• Prior industry experience with Reference Data
• Java EE: Servlets, JSP and EJB
• Cobol copybook
• EAI

Education:

• Bachelor’s degree/University degree or equivalent experience

• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Anticipated Posting Close Date:

Education:

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Anticipated Posting Close Date:

Responsibilities:

• This role is responsible for activities related to the development of data controls including data profiling, data analysis, logic tuning, and advanced SQL coding.

  · This role manages the end-to-end data quality control development lifecycle and will also scope data control code releases, agreeing to and tracking business priorities, incorporating regulatory and compliance requirements.

  · Create and Implement data quality controls by performing audits and validations across various data sources. Conduct exploratory data analysis to uncover data trends, patterns and anomalies in large complex data sets.

• Develops plans, prioritizes, coordinates design and delivery of products or features to product release, and serves as product ambassador within user community
• Works in close co-ordination with Technology, Business Managers and other stakeholders to fulfill the delivery objectives
• Identifies solutions ranging across data analytics, reporting, CRM, Trade Workflows and trade processing
• Has responsibility to deliver direct business results and advice regarding product development that necessitates a degree of responsibility over technical strategy
• Partners with senior team members and leaders and a widely distributed global user community to define and implement solutions
• Creates clear and specific project plans, business and technical requirements documents for product execution
• Interacts with business managers, technology, and sales to understand their long term vision, discuss industry trends, and incorporate them into the product & solutions strategy
• Focuses on controls and governance, including performing Need-to-Know based security and access reviews, Access Approvals, controls testing and documentation
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 6-10 years of experience

  · Advanced SQL coding proficiency

  · Deep Business Analysis skill set including a strong understanding of various form of analysis such as: Descriptive Analysis, Diagnostic Analysis, Exploratory Analysis, Inferential Analysis, Causal Analysis

  · Efficient coding methodologies such as use of Common Table Expressions and window analytic functions to create elegant and efficient analytical packages in SQL

  · Very strong proficiency in data profiling and entity relationship discovery within a standard Enterprise Data Warehouse and extensive experience in use of business data marts

  · High competency in actual coding in SQL to interrogate the data system and obtain outputs necessary to answer business questions

  · A good general understanding of the development cycle of a software product (SDLC, Agile methodologies, etc.)

  ·Intermediate/advancedPython experience preferred

  · Experience with data management lifecycles and workflows

  · Banking/Lending experience preferred but not required

  · Intellectual curiosity, analytical and conceptual thinker

  · Proactively seeks and develops new opportunities

  · Attention to detail and process/analytic mindset

  · Ability to build networks and relationships internally and externally

  · Familiarity with product development methodologies

  · Direct experience in end-to-end project delivery, preferably in product development, and knowledge of various analytical tools including Qlikview, Tableau, Access

  · Comfortable with performing data investigations that require a high degree of accuracy with tight timescales

  · Ability to create business analysis, troubleshoot data quality issues, and conduct exploratory and descriptive analysis of business datasets

  · Ability to structure and break down problems, develop solutions, and to drive to results

  · Process Management knowledge with a propensity for detail and comprehensiveness of

  Content

  · Ability to collaborate and clearly communicate with team members of an organization

  · Project Management skills with experience leading large cross functional initiatives

  · Generation of reports and presentations for management

• Bachelor’s/Universitydegree, Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Anticipated Posting Close Date:

Responsibilities:

• This role is responsible for activities related to the development of data controls including data profiling, data analysis, logic tuning, and advanced SQL coding.

  · This role manages the end-to-end data quality control development lifecycle and will also scope data control code releases, agreeing to and tracking business priorities, incorporating regulatory and compliance requirements.

  · Create and Implement data quality controls by performing audits and validations across various data sources. Conduct exploratory data analysis to uncover data trends, patterns and anomalies in large complex data sets.

• Develops plans, prioritizes, coordinates design and delivery of products or features to product release, and serves as product ambassador within user community
• Works in close co-ordination with Technology, Business Managers and other stakeholders to fulfill the delivery objectives
• Identifies solutions ranging across data analytics, reporting, CRM, Trade Workflows and trade processing
• Has responsibility to deliver direct business results and advice regarding product development that necessitates a degree of responsibility over technical strategy
• Partners with senior team members and leaders and a widely distributed global user community to define and implement solutions
• Creates clear and specific project plans, business and technical requirements documents for product execution
• Interacts with business managers, technology, and sales to understand their long term vision, discuss industry trends, and incorporate them into the product & solutions strategy
• Focuses on controls and governance, including performing Need-to-Know based security and access reviews, Access Approvals, controls testing and documentation
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 6-10 years of experience

  · Advanced SQL coding proficiency

  · Deep Business Analysis skill set including a strong understanding of various form of analysis such as: Descriptive Analysis, Diagnostic Analysis, Exploratory Analysis, Inferential Analysis, Causal Analysis

  · Efficient coding methodologies such as use of Common Table Expressions and window analytic functions to create elegant and efficient analytical packages in SQL

  · Very strong proficiency in data profiling and entity relationship discovery within a standard Enterprise Data Warehouse and extensive experience in use of business data marts

  · High competency in actual coding in SQL to interrogate the data system and obtain outputs necessary to answer business questions

  · A good general understanding of the development cycle of a software product (SDLC, Agile methodologies, etc.)

  ·Intermediate/advancedPython experience preferred

  · Experience with data management lifecycles and workflows

  · Banking/Lending experience preferred but not required

  · Intellectual curiosity, analytical and conceptual thinker

  · Proactively seeks and develops new opportunities

  · Attention to detail and process/analytic mindset

  · Ability to build networks and relationships internally and externally

  · Familiarity with product development methodologies

  · Direct experience in end-to-end project delivery, preferably in product development, and knowledge of various analytical tools including Qlikview, Tableau, Access

  · Comfortable with performing data investigations that require a high degree of accuracy with tight timescales

  · Ability to create business analysis, troubleshoot data quality issues, and conduct exploratory and descriptive analysis of business datasets

  · Ability to structure and break down problems, develop solutions, and to drive to results

  · Process Management knowledge with a propensity for detail and comprehensiveness of

  Content

  · Ability to collaborate and clearly communicate with team members of an organization

  · Project Management skills with experience leading large cross functional initiatives

  · Generation of reports and presentations for management

• Bachelor’s/Universitydegree, Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Anticipated Posting Close Date: