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

The Eye Group

Optometrist Job Richmond, VA Contact Lens Specialist Job at The Eye Group

Join ophthalmology practice. Stellar opportunity for an optometrist that has a passion to fit specialty contact lenses. This optometrist would go into the OR with the MDs. Monday through Friday. Competitive compensation package and benefits offered. Richmond offers a great... 

Adams & Martin Group

Litigation Paralegal - eDiscovery/Trial Job at Adams & Martin Group

&##128293; We're Hiring: Litigation / Trial Paralegal (2 Openings) - Join a High-Stakes Defense Team &##128293; Do you live for the intensity of trial? Thrive under pressure? Have a passion for digging into complex litigation like mass torts, product liability, and commercial...

Belnuc

Nucleair Geneeskundige/Nucleair radioloog (beloning conform AMS) Máxima MC Job at Belnuc

 ...arbeidsvoorwaardenpakket aanbieden. De aanstelling vindt plaats in dienstverband. De arbeidsvoorwaardenregeling medisch specialisten (AMS) is van toepassing. Daarbij kun je rekenen op: Een bruto maandsalaris volgens inschaling in de AMS. Ook krijg je 8% vakantiegeld en... 

Medix™

Environmental Services Technician- 241838 Job at Medix™

 ...visitors! &##129658; This isn't just a job; it's a stepping stone! &##128640; After just 6 months, you can access FREE technical training programs to become a Certified Medical Assistant, Pharmacy Tech, and more! Plus, you'll be part of a supportive team with great... 

ProSearch Recruiting Partners an independent franchise of th...

Fabrication Supervisor Job at ProSearch Recruiting Partners an independent franchise of th...

 ...Custom Machinery Fabrication Leader Hiring for a Project Manager, ideal candidate will have a strong sheet metal background with Engineering design and metal cutting laser programming. ProSearch Recruiting Partners, an independent franchise of the MRINetwork, is hiring...