9 days old

Data Warehouse/Data Quality Senior Analyst

Citigroup
Irving, TX 75062
The Data Quality Lead Analyst is a strategic professional who stays abreast of developments within own field and contributes to directional strategy by considering their application in own job and the business. Recognized technical authority for an area within the business. Requires basic commercial awareness. There are typically multiple people within the business that provide the same level of subject matter expertise. Developed communication and diplomacy skills are required in order to guide, influence and convince others, in particular colleagues in other areas and occasional external customers. Significant impact on the area through complex deliverables. Provides advice and counsel related to the technology or operations of the business. Work impacts an entire area, which eventually affects the overall performance and effectiveness of the sub-function/job family.


**Responsibilities:**


+ Designs/analyzes complex reports to satisfy management requirements.

+ Understand Banking and Finance data model to conduct test cases based on changed request (CR), source request testing (SRT) and consumer subscriptions validation.

+ Execute and understand ETL data pipelines with data loading from staging to DMART database platform.

+ Strong knowledge on UNIX shell scripts to validate raw data from Product processor source files (.dat files) before loading to DMART tables.

+ Analyze business requirements and technical specifications for organizationally utilized applications. Build and maintain the corresponding test strategy, test plans, and test cases.

+ Analyze test results and logs defects in JIRA. Partner with project team members on the resolution and re-testing of identified defects and issues

+ Deals with complex and variable issues with substantial potential impact.

+ Uses broad discretion in developing solutions for broad based business reporting issues.

+ Leads reengineering efforts in business's methodology, strategy, and organizational goals.

+ Manages resource allocation and leads the work within a team/project to develop solutions for business reporting issues.

+ Applies/demonstrates advanced understanding of processes, procedures, and policies for aligned business

+ Possesses a comprehensive understanding of how own area and others collectively integrate to contribute towards achieving business objectives.

+ Acts as advisor or coach to new or lower level personnel in the business processes and procedures of the business

+ Provides in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions.

+ Influences strategic functional decisions through advice, counsel or provided services that have direct impact on the business.

+ Persuades and influences others through developed communication and diplomacy skills with colleagues in other areas and occasional external customers.

+ May be responsible for resource management and allocation of work within the team/project.

+ Works and coordinates with a multidisciplinary group of business leads, operations managers and technologists.

+ Defines detailed business data requirements and documenting them.

+ Completes projects to acquire data, manage it, and present it for use in reporting and statistics.

+ Documents platform processes, procedures and training materials.

+ Leads discussions and requirement gathering sessions, reaching consensus and recommending solutions on system issues and projects.

+ Coordinates and plans work activities, meetings and other tasks that demonstrate leadership with measurable results.

+ Tests features and functionality in planned software releases.

+ Coordinates the resolution of operational activities performed by the production support team.

+ 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:**


+ Experiences on Software Experience

+ Experiences with defining and implementing data quality programs;

+ 8+ years ETL experiences and Data Warehousing/Business Intelligence concepts from QA perspective, complex SQL Queries and ETL Banking Data Warehouse Testing.

+ Experiences with Ab Initio (Batch graphs, Continuous graphs, Plans) and Unix shell scripts

+ 8+ years Experiences database platforms Netezza, Oracle and Teradata

+ Domain knowledge on Banking and Financial Services experiences preferredExperience with defining and implementing data quality programs


Skills:


+ Data Warehousing

+ ,SQL Complex,

+ Shell Script,

+ Java

+ Snowflake

+ Oracle

+ Testing process


**Education:**


+ Bachelors/University degree Computer Engineering, Information Technology or equivalent experience


-------------------------------------------------


**Job Family Group:**


Technology

-------------------------------------------------


**Job Family:**


Data Quality

------------------------------------------------------


**Time Type:**


Full time

------------------------------------------------------


Citi is an equal opportunity and affirmative action employer.


Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.


Citigroup Inc. and its subsidiaries ("Citi) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review **Accessibility at Citi (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)** .


View the "EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) " poster. View the EEO is the Law Supplement (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pdf) .


View the EEO Policy Statement (http://citi.com/citi/diversity/assets/pdf/eeo\_aa\_policy.pdf) .


View the Pay Transparency Posting (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp\_%20English\_formattedESQA508c.pdf)


-----------------------------


Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.

Categories

Posted: 2022-05-13 Expires: 2022-06-12

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Warehouse/Data Quality Senior Analyst

Citigroup
Irving, TX 75062

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast