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.

Cloud BC Labs Inc is a digital transformation organization aimed at creating seamless solutions for clients to effectively manage their business operations. The company specializes in Business and Management Consulting, AI / ML, Data Analytics & Visualization, Cloud Data Warehouse Migration, Snowflake Implementation, Informatica Implementation & Upgrade, Staffing Services and Data Management Solutions