Data Analyst with SQL

Position : Data Analyst

Location : Reston, VA (Hybrid)

Term : W2/Full Time Role

Duration : Long Term

Interview Mode : In-Person Interview

Job Description :

We are hiring a Data Analyst to join our data warehouse team. The analyst is expected to work alongside business users/ business or data or systems analyst/ developers and report directly to the Data Management manager. Your main tasks will include Troubleshooting data variances and failures to identify the root cause of issues using the available documentation (STTM). Able to read Informatica code to identify root cause of data variances. Providing solutions to resolve the issues and improve overall product quality.

Top 3 skills:

• Analytic Skills

• Agile experience

• Problem Solving Ability

Responsibilities:

• Analyze complex requirements by reading STTMs and apply the knowledge to troubleshoot failures in a production environment

• Propose solutions to resolve the analyzed problem/issue

• Write SQL scripts to correct data (data corrections) and coordinate with the technical team members to ensure the change is delivered to production.

• Verify data changes and certify the change after the data correction is implemented

• Articulate technology solutions, in consultations with the systems analyst or Tech lead and requirements to diverse internal/external stakeholders, integrating process, business rules, and data to meet business needs.

• Data-driven, results-oriented with the ability to quickly analyze data and make decisions that drive performance.

• Understanding of Data Lineage, source to target mapping, documenting the data elements accurately is strongly needed.

• Conducting meetings and presentations to share ideas and findings.

• Documenting and communicating the results of data and business requirements

• Effectively communicating your insights and plans to cross-functional team members and management.

• Managing competing resources and priorities.

• Should be able to complete task with minimum supervision

• Overall 8-10 years of experiences needed

Business / Data Analyst Requirements:

• 8+ years of Data Analysis experience

• A bachelor's degree Is required.

• Must have Advanced SQL, excel skills (SQL on Oracle database preferred)

• Strong knowledge of Data Warehouse / Mart concepts.

• Must have experience using Toad and comparing data from various data sources

• Competency in Microsoft applications including Word, and Outlook.

• Must have experience using JIRA, Confluence

• Strong working knowledge of agile methodology

• Exhibit strong written and verbal communication skills

• Extremely organized with strong time-management skills

• Demonstrated ability to work with multiple stakeholders on a high visibility project

• Multifamily or Single-Family mortgage experience is preferred.