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 bachelors 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