Mid-level Data Analyst - Finance Industry Required
The Mid-level Data Analyst at Confidential Client supports the Alternative Investments Data Strategy team by transforming fragmented data into actionable insights to aid sales efforts. This role involves hands-on data analysis, reporting, process improvement, and automation using SQL and Python within Databricks and Snowflake environments, requiring strong analytical skills and the ability to develop scalable data solutions in a fast-paced setting.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Financial Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
What You’ll Do
This is a hands-on, mid-level data analyst role on a small, business-facing team that turns fragmented alternatives and sales-related data into reporting, analytics, and repeatable data products for the sales organization.
- Build and maintain reporting and analytics for sales, flows, opportunities, fundraising, transactions, product usage, and advisor/firm targeting.
- Write production-quality SQL and Python to extract, transform, reconcile, validate, and analyze data.
- Develop and improve ETL/data-transformation workflows and scheduled reporting pipelines in cloud environments.
- Automate manual data-prep, validation, reporting, notification, and exception-management processes.
- Troubleshoot production workflow and data quality issues and implement sustainable fixes.
- Translate recurring business questions into scalable reports, dashboards, and data products.
- Coordinate with sales, operations, and enterprise data partners to deliver prioritized initiatives.
Qualifications
Required
- Bachelor’s degree in analytics, computer science, information systems, engineering, finance, economics, or equivalent experience.
- 2+ years of experience in data analytics, business intelligence, data operations, or reporting.
- Strong, hands-on SQL and Python skills.
- Experience with ETL, data transformation, and cloud data lake/warehouse environments.
- Strong analytical, troubleshooting skills and attention to data quality.
Preferred
- Experience creating dashboards or visualizations (Power BI, Tableau, or similar).
- Experience with Databricks and Snowflake, including Python + SQL workflows.
- Exposure to financial services, asset management, or alternative investments.
- Familiarity with sales/CRM, transaction, flow, advisor, or product datasets.
- Experience replacing manual Excel/reporting processes with automated, scalable solutions.
- Familiarity with Git, APIs, workflow-orchestration tools, or approved AI-assisted development tools.
Skills & Tools (keywords)
- SQL
- Python
- Databricks
- Snowflake
- ETL / Data Pipelines
- Power BI / Tableau
- Git, APIs, workflow orchestration
- Data validation & automation
Details & Logistics
- Employment type: CONTRACTOR
- Location: Telecommute (role is remote; candidate should be eligible to work in the USA; see applicant location requirements)
- Salary range (provided by our client): USD 70,000 – 95,000 per year
- Industry: Financial Services
Why This Role
You’ll join a small, fast-moving team where you’ll own technical solutions that directly impact sales effectiveness. This role is ideal for pragmatic problem-solvers who like combining engineering (pipelines, automation) with actionable analytics and stakeholder collaboration.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range