Remote Data Analyst/Engineer: SQL, Python, APIs

Eliassen Group; Montpelier (VT); Remoto; USD 171.924.000 - 200.579.000; Tempo pieno

Descrizione del lavoro

Eliassen Group is seeking a Technical/Business Analyst/Engineer for remote, contract-to-hire work focused on Commercial Mortgage Data Warehouse development and data quality improvements. The role requires advanced SQL, Python, Excel, and API integration experience, with Agile collaboration and strong communication skills.

Responsibilities include transforming business requirements into technical specifications, validating data models, and supporting the mortgage platform with testing and

Competenze

• Able to transform data into information for analytics.
• Advanced SQL skills with 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.

Mansioni

• Develop, validate, document, and maintain business and functional requirements.
• Own development of business and technical requirements for mortgage data warehouse support and enhancements.
• Transform business requirements into SQL statements.
• Analyze data to triage issues within the data model.
• Collaborate with data architects, sponsors, administrators, and report writers in Agile.
• Analyze source system data to improve data quality.
• Identify data issues and propose solutions with the business.
• Improve data quality through business rules automation.
• Review application functionality and perform gap analysis for enhancements.
• Develop test plans and execute test scripts for changes.
• Evaluate feasibility of business requests and research options.
• Respond to questions from business and IT teams.
• Track solutions to determine issues and communicate impacts.
• Assist with automation and process improvements using scripting/tools.
• Assist with integrations between systems (APIs or file-based).
• Investigate and resolve data feed issues for PLM platform.
• Respond to escalations from users and help desk.
• Support core commercial mortgage servicing and accounting platform.
• Maintain regular attendance and other duties as assigned.

Conoscenze

Advanced SQL

Python for data analysis

Advanced Excel

APIs or system integrations

Data analysis

Communication skills

Learning new technologies

Analytical thinking

Formazione

Bachelor's degree or equivalent related work experience

Strumenti

Alteryx

Descrizione del lavoro

Eliassen Group is seeking a Technical/Business Analyst/Engineer for remote, contract-to-hire work focused on Commercial Mortgage Data Warehouse development and data quality improvements. The role requires advanced SQL, Python, Excel, and API integration experience, with Agile collaboration and strong communication skills.

Responsibilities include transforming business requirements into technical specifications, validating data models, and supporting the mortgage platform with testing and