System Analyst (BADA) SQL exp at Cloud BC Labs

Position : System Analyst (BA/DA) - SQL exp is must Location : Reston VA (Hybrid) Term : W2/Full Time Role Duration : Long Term Interview Mode : In-Person Interview Job Description : We are hiring a Business / 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 Business / Data Analyst 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 Business/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 Key Skills SQL,System Design,.NET,Crystal Reports,EDI,Windows,Microsoft SQL Server,Visio,Visual Basic,SDLC,Systems Analysis,Oracle Employment Type : Full Time Experience: years Vacancy: 1