Technical/Business Analyst/Engineer

Eliassen Group; United States; Remote; USD 83,000 - 96,000; Full time

Benefits offered by this job

Medical, Dental, and Vision benefits

401k with company matching

Life insurance

Job summary

Eliassen Group is seeking a Technical/Business Analyst/Engineer to deliver data solutions across a PLM platform and related systems for commercial mortgage data.

You will translate business requirements into technical specs, validate data outcomes, and support development, testing, and documentation in an Agile environment.

Qualifications

• Transform data into information for analytics and reporting.
• Develop, validate, and document business and functional requirements.
• Experience with data warehouses and data modeling.
• Ability to work in Agile environments and SDLC processes.
• Strong communication with business and IT stakeholders.

Responsibilities

• Develop, validate, document, and maintain business and functional requirements.
• Own development of requirements for data warehouse enhancements.
• Translate business requirements into SQL statements and tests.
• Collaborate with data architects and report writers in Agile methodology.
• Analyze data to triage issues and improve data quality.

Skills

Advanced SQL

Python

Excel

APIs/REST

Data analysis

Education

Bachelor's degree or equivalent related work experience

5-7 years IT-related experience in BA/QA

Tools

Alteryx

Job description

Remote

Our client seeks a Technical/Business Analyst/Engineer to deliver accurate and reliable data solutions across a PLM platform and supporting systems for commercial mortgage data. The role will translate business requirements into technical specifications and validated data outcomes, operate across data structures and system interactions, and assist with support, maintenance, testing, documentation, and application development. Success will be measured by timely delivery of enhancements, reduction of data quality issues, and effective collaboration with business and IT stakeholders within regulated financial systems and Agile or SDLC environments.

This is a contract to hire opportunity. Applicants must be willing and able to work on a w2 basis and convert to FTE following contract duration. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $60.00 to $70.00/hr. w2

JN -102026-109065

Responsibilities:

• Develop, validate, document, and maintain business and functional requirements. Conduct structured walkthroughs with business and IT team members.
• Own development of business and technical requirements for support and enhancement items within the Commercial Mortgage Data Warehouse model.
• Transform business requirements into SQL statements.
• Analyze data to triage issues within the data model.
• Collaborate with data architects, business sponsors, core system administrators, and report writers within an Agile methodology.
• Analyze source system data to improve data quality.
• Partner with the business to identify data issues and potential solutions.
• Proactively identify ways to improve data quality through business rules automation.
• Review existing application functionality and perform gap analysis to identify enhancements. Apply configuration changes and updates via an application management tool.
• Develop test plans and execute test scripts for application and data model changes.
• Evaluate business requests for feasibility. Research and identify options.
• Respond to questions from business and IT technical teams.
• Track new or enhanced solutions to determine potential issues, communicate business impacts, and recommend solutions within the mortgage data warehouse model.
• Assist with task automation and process improvements using scripting or tooling.
• Assist with analysis, creation, and testing of integrations between systems, including API-based or file-based exchanges.
• Investigate and resolve issues related to inbound and outbound data feeds supporting the PLM platform.
• Respond to escalated calls from users and the help desk.
• Support the core commercial mortgage servicing and accounting platform.
• Maintain regular and predictable attendance.
• Perform other duties as assigned.

Experience Requirements:

• Ability to transform data into information for analytics.
• Advanced SQL skills, including use of Alteryx or similar tools for data anomaly detection.
• Experience with Python for data analysis, automation, or scripting is a plus.
• Experience with APIs or system integrations (REST, JSON) is a plus.
• Advanced Excel skills.
• Ability to learn new technologies.
• Strong oral and written communication skills.
• Ability to adapt to new methods and work under tight deadlines within Agile methodology.
• Strong investigative, analytical, and problem-solving skills.
• Strong data analysis and troubleshooting skills within complex data models.
• Ability to trace data issues from source through reporting across systems.
• Strong interpersonal skills and customer service orientation.
• Ability to accept guidance and ask relevant questions during onboarding.
• Ability to set goals and manage multiple tasks, clients, and projects.
• Ability to balance priorities, deadlines, and deliverables.
• Team collaboration experience on department or team projects.
• Attention to detail with a methodical approach and sense of urgency.
• Ability to align detail with departmental goals and objectives.
• Ability to translate business needs into viable solutions.
• Ability to provide customer support for core platform capabilities and/or system development experience.
• Basic negotiating and persuasion skills.
• General business knowledge.
• Preferred: 8+ years IT experience in Business Analysis or Data Analysis.
• Preferred: 2+ years Financial or Investment industry knowledge.
• Preferred: Experience in Commercial Real Estate Finance.
• Preferred: Working knowledge of Loan Management Systems.
• Preferred: CCIM, MAI, CPA, LOMA, or other industry accreditation.
• Preferred: Insurance, Reinsurance, or Financial Services experience.
• Preferred: Experience developing technical skills in Python, data automation, or system integration.

Education Requirements:

• Bachelor's degree or equivalent related work experience.
• 5-7 years IT-related experience such as Business Analysis or Quality Assurance.