Data analyst

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Cinergy Technology Inc, is seeking the following. Apply via Dice today!

Title: SAS Data Analyst (12+yrs Exp)

Duration: 9 months Contract on W2

Location: Atlanta, GA / Charlotte, NC (4-days on site)

Visa Type: and USC

Rate: 65/hr. on W2

Client: Truist bank

Please find the below position for Truist bank, Need Sr. candidates on this role

Overview: Looking for people focused on the data analytics space, supporting audit and issue evaluations. Example: These can be one-time pull data or do a heavier data analysis/investigative work(looking for outliners).

Screening Questions: Will add to resume

• How do you establish relationships across stakeholders?
• What process do you use to gather detailed requirements and scope?
• Give examples of how you have analyzed large data sets, challenges encountered, and how challenges were addressed/overcome?
  
  

Manager notes: Please reference for candidate screening and resume review. Main Skills:

• SQL
• SAS (Python as a secondary)
• Working Multiple Datasets (understanding of Enterprise Data Warehouse concepts)
  
  

Skills Overview:

• 5-10 years of experience in data analytics, data science
• Strong SQL skills (writing SQL from scratch, queries, complex joins) no stored procedure or tables.
• SAS customization
  • SAS programming do code reviews.
  • Python as a secondary
    • Do not need both SAS and Python
  • Data extraction, data manipulation , data reporting (pulling insights from the data)
    • (re-executed and executing data might not be the right fit.) need to have coding expertise to analyze and identify outliers
  • No ETL pipelining or performance tuning required
• Need to work with non-tech folks as well to be able to accomplish ask
• Banking/financial services is preferred BUT I am open to other enterprise experience
  • Audit is only a nice to have skill, not required
    
    

Job Description:

• Gather, analyze, document and maintain all data requirements related to the business applications, interfaces and reporting environments.
• Apply standards and best practices to ensure the Bank's data is accurate, complete, current, understandable and accessible.
• Work closely with internal clients, Audit Delivery Teams, business analysts and development project teams to resolve information flow and content issues
  
  

Essential Duties And Responsibilities

• Gathers, reviews, analyzes, profiles, validates and maps system data into the data warehouse to meet reporting and analytical business needs.
• Performs data analysis and troubleshooting on data-related issues reported by production support and other teams.
• Develops solutions and recommendations for improving data integrity issues. Analyzes data issues and works with development teams for problem resolutions. Identifies problematic areas and conducts research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
• Determines and analyzes line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
• Works with extract, transform and load (ETL) developers to test and validate data attributes and with other business analysts to ensure data is integrated consistently, regardless of the source system.
• Works with business analysts and project teams to provide accurate documentation of data related project and support deliverables. And with source system business analysts to understand system nuances and resolve data issues. Takes ownership of issues through resolution including close coordination between business analysts.
• Ability to act as liaison between Audit team and business team
  
  

Required Skills:

Required Qualifications: (IF CANDIDATES DO NOT HAVE MUST HAVE SKILLS in Red THEN DO NOT SUBMIT.)

• Bachelor's degree in information technology, information systems, computer science or business-related field, six years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and/or sophisticated data presentation or equivalent education and related training or experience
• Hands-on Knowledge of SQL Queries (IS A MUST). Proficient in analyzing and understanding existing SQL queries to make necessary modifications and capable of developing new queries as needed.
• Hands-on Experience with SAS (IS A MUST). Proficient in analyzing and understanding existing SAS programs to make necessary modifications and capable of developing new programs as needed.
• Understanding of Enterprise Data Warehouse concepts and prior experience applying that understanding to query data in a Very Large Database (VLDB) environment (CANDIDATES MUST HAVE EXPERIENCE WORKING WITH MULTIPLE DATASETS)
• Familiarity in using a query analysis tool.
• Experience with Python. (preferred, nice to have)
  
  

Nice To Have Skills:

• Banking or financial services experience.
• Experience working with Informatica.
• Audit experience.
  
  

Thanks and Regards,

Varshini kandru

Team Lead Recruiter

Cinergy Technology Inc. | varshini @CinergyTech.com