Business Analyst with expertise in Loan IQ and data modeling

PeopleNTech LLC

Alexandria, VA

JOB DETAILS
SALARY
$80–$82 Per Hour
SKILLS
Acceptance Testing, Agile Programming Methodologies, Amazon Web Services (AWS), Basel III (Third Basel Accord), Business Analysis, Business Transformation, Capital Markets, Change Requests/Orders, Chartered Financial Analyst (CFA), Cloud Computing, Communication Skills, Data Analysis, Data Management, Data Modeling, Data Profiling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Derivatives, Documentation, Dodd Frank Act, Finance, Financial Systems, Gap Analysis, Information Technology & Information Systems, Investment Services, Loans, Metadata, Microsoft Windows Azure, NCR Teradata, Policy Implementation, Quality Assurance, Regulatory Reports, Regulatory Requirements, Requirements Management, Risk, SQL (Structured Query Language), Scrum Project Management and Software Development, Snowflake Schema, Test Case
LOCATION
Alexandria, VA
POSTED
30+ days ago
Indent : SF_OP_203739-1-1
Role : Business Analyst with expertise in Loan IQ and data modeling
Location : Iselin, NJ (Hybrid)
Rate : $80/hr – $82/hr

Preferred : CFA

Job Summary:
We are looking for a seasoned Business Analyst to support a strategic Data Warehouse initiative within our Bank division. The ideal candidate will have deep domain expertise in Derivatives, Finance, Cash, Loans, and Commitments, along with a strong understanding of Regulatory Reporting requirements. This role involves working closely with business stakeholders, data architects, and engineering teams to define and deliver robust data solutions that support compliance, reporting, and analytics.
Key Responsibilities:
  • Collaborate with business users and technology teams to gather and document requirements for data warehousing solutions.
  • Analyze and map data from source systems (trading, finance, risk) into the enterprise data warehouse.
  • Define data models, transformation rules, and business logic for derivatives, loans, cash, and commitment products.
  • Support the design and implementation of regulatory reporting data pipelines (e.g., Dodd-Frank, EMIR, Basel III).
  • Conduct data profiling, gap analysis, and validation to ensure data quality and completeness.
  • Create detailed functional specifications, data dictionaries, and lineage documentation.
  • Work with QA and UAT teams to define test cases and validate data warehouse outputs.
  • Act as a liaison between business, compliance, and IT to ensure alignment on data requirements and delivery timelines.
  • Support ongoing enhancements and change requests related to regulatory and business reporting.

Required Skills & Qualifications:
  • Bachelor's degree in Finance, Information Systems, or a related field.
  • 5+ years of experience as a Business Analyst in Investment Banking or Capital Markets.
  • Strong understanding of financial products, especially derivatives, loans, and cash instruments.
  • Proven experience in data warehousing projects, including data modeling and ETL processes.
  • Familiarity with regulatory reporting frameworks (e.g., EMIR, Dodd-Frank, Basel III, SFTR).
  • Proficiency in SQL and data analysis tools.
  • Experience working with enterprise data platforms (e.g., Snowflake, databricks, Teradata).
  • Excellent communication, documentation, and stakeholder management skills.

Preferred Qualifications:
  • Experience with Agile/Scrum methodologies.
  • Knowledge of data governance, metadata management, and data lineage tools.
  • Exposure to cloud-based data platforms (e.g., AWS, Azure).


About the Company

P

PeopleNTech LLC