Business Data Analyst Job at JustinBradley, Reston, VA

dUxsM3d0bHc3ZmEvRjJOd1lHb09VRStUaXc9PQ==
  • JustinBradley
  • Reston, VA

Job Description

JustinBradley’s client, a leading source of mortgage financing, is seeking a highly skilled Business Data Analyst to join their Data Warehouse team. The successful candidate will work closely with business users, analysts, developers, and report directly to the Data Management Manager. This role involves troubleshooting data variances and failures, providing root cause analysis, and collaborating with various stakeholders to resolve issues efficiently. If you have a strong background in SQL, data analysis, and experience with Informatica code reading, we would love to have you on their team.

Must be local to Reston, VA for their on-site requirement.

Responsibilities:

  • Troubleshooting & Analysis: Analyze complex requirements by reading STTMs and leverage your knowledge to troubleshoot failures in a production environment.
  • Solution Proposal: Propose effective solutions to address identified data issues and recommend changes based on root cause analysis.
  • SQL Scripting: Write SQL scripts to correct data discrepancies and collaborate with technical teams to ensure that the changes are implemented successfully in production.
  • Data Verification & Certification: Verify and certify data changes post-implementation to ensure accuracy and alignment with business rules.
  • Stakeholder Communication: Articulate technology solutions, consult with systems analysts/tech leads, and present business requirements to internal and external stakeholders.
  • Data Documentation & Analysis: Understand Data Lineage, source-to-target mapping, and document data elements accurately to meet business needs.
  • Meetings & Presentations: Conduct meetings and presentations to share insights and findings with the team and stakeholders.
  • Collaboration & Documentation: Work closely with business and technical teams to ensure alignment on data requirements and business rules, and document the results effectively.
  • Time & Resource Management: Manage competing resources and priorities while ensuring that tasks are completed with minimal supervision.
  • Problem Resolution Ownership: Take full ownership of the issue resolution lifecycle, ensuring problems are addressed promptly and accurately.

Requirements:

  • 8+ years of experience in Business/Data Analysis, with proven expertise in working with Data Warehouses.
  • A bachelor’s degree is required.
  • Strong experience with advanced SQL, particularly on Oracle databases. Recent hands-on experience is a plus.
  • Deep understanding of Data Warehouse/Mart concepts, with the ability to analyze and troubleshoot data flows and mappings.
  • Proficiency with Toad for data comparison, JIRA, and Confluence. Basic experience with AWS (login, repository access) is preferred but not required.
  • Ability to work with Source-to-Target Mapping (STTM) documentation and other data documentation for traceability checks.
  • Excellent written and verbal communication skills, with the ability to articulate complex concepts to non-technical stakeholders.
  • Strong working knowledge of agile practices and tools.
  • Highly organized with strong time-management skills, and the ability to juggle multiple competing priorities.
  • Ability to read and analyze Informatica code (development experience not required).

JustinBradley is an EO employer - Veterans/Disabled and other protected employees.

Job Tags

Local area,

Similar Jobs

Clean Harbors

Oil Sales and Service Rep I Job at Clean Harbors

 ...Class B Route Driver you will be responsible for pickup of waste oil and anti-freeze at customer locations such as garages,...  ...gallons of used motor oil each year and we have the largest re-refinery capacity in North America allowing us to re-refine more than 150... 

Rate

Search Engine Optimization Specialist Job at Rate

 ...Description:Focus on improving organic search activity to attract potential borrowers by optimizing website content and structure....  ...website content for search enginesMonitor and analyze website...  ...new Search Engine Optimization Specialist jobs in Chicago, IL .Additional... 

Nautical Ventures

Luxury Watersports Sales Associate Job at Nautical Ventures

 ...toys to potential customers, playing a significant role in driving sales growth and expanding our customer base. This open position will...  ...and the ability to work as part of a team.17.Travel:Attend boat shows and industry events as required.Requirements? High... 

Confidential Careers

Site Administrative Assistant Job at Confidential Careers

 ...MANAGE DAILY OFFICE OPERATIONS FOR THE CONSTRUCTION SITE OFFICE Assist purchasing internet research, pricing, placing orders any additional...  ..., be hospitable and keep ears open. Random checks on the security guards and tool attendant Run errands, pick up checks, make... 

Aramark

Custodial Services Worker - Anheuser-Busch Jacksonville MCC Job at Aramark

Are you self-motivated and proud of the work you do? Here at Aramark, we take pride in our level of service and safety we provide! Cleanliness is a necessity of every business. As a Custodial Services worker on our team, youll take on the important job of keeping...