Data Analyst

E Capital; Atlanta (GA); On-site; USD 65,000 - 85,000; Full time

Job summary

E Capital is seeking a detail-oriented Data Analyst to join their team in Atlanta. This role focuses on supporting data-driven decisions in asset-based lending, engaging with complex datasets, and utilizing advanced analytical tools. The ideal candidate will possess strong Excel, SQL, and programming skills to enhance operational efficiency and drive success in various data projects.

Benefits

Competitive Compensation

Annual Bonus Incentives

PTO

Health, Dental, and Life Benefits

401K Matching

Qualifications

• Strong analytical mindset with attention to detail.
• Experience with data extraction from SQL databases.
• Proficiency in programming languages like Python and VBA.

Responsibilities

• Execute ad hoc data analysis projects using advanced analytical tools.
• Analyze and support client reports for lending operations.
• Develop and modify analytical tools as per business requirements.

Skills

Advanced Excel proficiency

Quantitative problem-solving

Statistical analysis

Programming in VBA

Programming in Python

SQL proficiency

Education

Bachelor's degree in a relevant field

Tools

SQL databases

AWS S3

Job description

About Us:
At eCapital, we are on a mission to ignite growth and empower businesses across North America and the U.K. by accelerating their access to capital. Our expertise and forward-thinking technology create customized, cutting-edge solutions for clients in over 80 industries. We are proud to have been named to the prestigious Inc. 5000 Fastest Growing Company list in 2023, recognized as a ‘Great Place to Work’ by the Secured Finance Network, and celebrated as a ‘Most Innovative Company’ by ABF Journal; all thanks to our dynamic team who are the cornerstone of our success.

The Opportunity:
We are looking for a detail-oriented Data Analyst to join our remote team and support data-driven decision making across our operations. This role involves working with complex datasets, building analytical tools, and contributing to various data projects using modern technologies. You'll primarily be supporting Asset-based Lending operations, with additional work across other lending groups.

Note:This role requires full-time presence in the Atlanta office.

Required Qualifications:

• Advanced Excel proficiency, including complex formulas, pivot tables, and data flow analysis for troubleshooting.
• Strong quantitative and statistical problem-solving abilities to analyze novel datasets, identify appropriate variables, investigate data irregularities, and develop reporting structures.
• Programming experience in at least one of the following: VBA, Python, or SQL with demonstrated ability to write and troubleshoot code.

Preferred Qualifications:

• SQL database experience for data extraction and manipulation.
• Python programming skills.
• Experience leveraging AI tools and large language models to enhance analytical work and processes.
• Experience working with AWS S3 buckets and cloud-based data storage.
• Background in QA/UA testing for proprietary software applications.
• Experience in finance, banking, or lending industries.
• Healthcare sector experience.

What We're Looking For:
Analytical Mindset: Someone who investigates inconsistencies, asks insightful questions, explores new analytical approaches, and effectively communicates findings.
Attention to Detail: Ability to produce accurate, comprehensive results while managing detailed tasks and reports with precision.
Initiative: A proactive approach to anticipating project needs and addressing potential challenges before they become roadblocks.
Independence: Strong ability to manage priorities across multiple teams and deliver projects on schedule with minimal supervision.
Communication: Excellent verbal and written communication skills for collaborating with colleagues and presenting findings.

Key Responsibilities:

• Execute ad hoc data analysis projects using modern analytical tools and AI technologies.
• Analyze client reports and data to support lending operations and decision-making.
• Develop and modify analytical tools using Excel, VBA, Python, SQL, and other technologies to accommodate business requirements.
• Create automated solutions and macros to support operations team needs.
• Interface with SQL databases and AWS S3 buckets for data extraction and storage.
• Provide backup coverage for recurring internal and external reporting processes.
• Support various data-driven initiatives and special projects as assigned.
• Process funding requests and maintain relationships with an assigned portfolio of established clients.
• Collaborate effectively in small team environments, typically working individually or with 1-2 colleagues.

We Bring:

• Competitive Compensation
• Annual Bonus Incentives
• PTO
• Health, Dental, and Life Benefits
• 401K Matching