Senior Business Analyst

The role

This person will design and implement data architecture and data models to optimize processes. They will build data pipelines, write SQL queries, and use Python to automate workflows and provide business insights.

What you will do

• Design and implement data architecture and data models.
• Build and maintain reliable, scalable data pipelines in Snowflake or another database.
• Write and optimize SQL queries to extract and analyze large datasets.
• Use Python to integrate, transform, and automate data workflows.
• Analyze data to find patterns and root causes.
• Present findings with clear visualizations using Tableau, Sigma, or similar.
• Collaborate with cross-functional teams to translate business requirements into technical specifications.
• Optimize and streamline existing analytics processes.
• Manage relationships with key stakeholders and deliver actionable insights.

Required qualifications

• Bachelor’s or Master’s degree in Data Science, Computer Science, Information Systems, or a related field.
• 4+ years in data analytics, data architecture, and process optimization.
• Strong analytical and problem-solving skills.
• Expert at writing complex SQL queries, tuning query and database performance, and managing large datasets.
• Designed scalable data models and platforms (dimensional, star/snowflake schemas).
• Strong working knowledge of Python for data integration, manipulation, and automation.
• Communicates clearly with both technical and non-technical teams.

Nice to have

• Experience with Snowflake and ELT/orchestration tools (dbt, Airflow).
• Git/CI-CD for analytics code.
• Data quality, observability, and governance practices, such as validation checks, lineage, and SLAs.
• Snowflake cost and performance tuning (warehouse sizing, clustering, query profiling).
• AI-driven analytics: hands-on use of LLMs and AI tools (for example Snowflake Cortex or Claude) for text-to-SQL, automated insights, or anomaly detection.

About the company

Ocrolus is a remote-first company that provides an AI workflow and analytics platform for lenders. They help financial institutions automate workflows and evaluate borrowers with high accuracy.