Senior BI & Data Analyst — Cloud Migrations & Databricks

CAI Computer Aid, Inc.; United States; On-site; USD 48,000 - 55,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401k retirement plan

Paid time off

Job summary

CAI Computer Aid, Inc. is seeking a motivated Business Intelligence & Data Analyst to support BI, data analytics, cloud data migration, and reporting initiatives. You will work with Product and Engineering teams to connect large datasets, migrate legacy data to the cloud, and translate business needs into actionable insights.

This is a contract, onsite role in Miramar, FL. The position requires advanced SQL, Databricks, Power BI, and Python experience, plus strong Excel skills and the ability to

Qualifications

• 3–5 years of experience in data analysis, business intelligence, or a similar role.
• Bachelor’s degree in Data Science, Computer Science, Information Systems, Statistics, Business, or a related field, or equivalent professional experience.
• Advanced proficiency in SQL, including complex joins, CTEs, window functions, and query optimization.
• Strong experience creating and maintaining reports and dashboards in Power BI, including DAX, data modeling, and row‑level security
• Advanced Excel skills, including pivot tables, Power Query, complex formulas, and data modeling
• Working proficiency in Python for data manipulation, automation, and analysis, including pandas and NumPy
• Advanced hands‑on experience with Databricks, including organizing and hosting datasets, building notebooks, and connecting external data sources and BI tools
• Experience connecting and integrating multiple databases and large datasets using Databricks
• Proven experience migrating legacy data to cloud environments, including migration planning, execution, reconciliation, and validation
• Demonstrated experience cleaning, transforming, standardizing, and organizing large, complex datasets
• Ability to read and understand existing queries and develop queries to support business and reporting needs
• Experience creating and maintaining recurring BI reports and analytics
• Strong communication skills with the ability to serve as a liaison between technical and non‑technical stakeholders

Responsibilities

• Plan and execute migration of legacy data sources and databases to the cloud, ensuring data accuracy, completeness, and minimal business disruption
• Validate migrated data through reconciliation checks and document data migration processes and lineage
• Identify and support the retirement of redundant or outdated legacy data assets
• Host, organize, and manage large datasets within Databricks, including tables, schemas, workspaces, and notebooks
• Connect Databricks with upstream and downstream databases, applications, and BI tools
• Build and optimize queries, notebooks, and workflows using SQL and Python
• Partner with Data Engineering teams on pipeline design, performance tuning, and data access
• Clean, transform, standardize, and organize large datasets from multiple sources
• Establish and maintain data quality checks, naming conventions, and supporting documentation
• Troubleshoot data discrepancies and identify root causes
• Create and maintain dashboards and recurring reports using Power BI and Excel
• Translate business questions into meaningful metrics, KPIs, reports, and visualizations
• Ensure reporting is accurate, performant, and refreshed according to business requirements
• Use operational data to support business decisions such as staffing levels, room‑cleaning requirements, food supply planning, and resource allocation
• Work as a liaison between Product and Engineering teams, translating business requirements into technical specifications and communicating technical constraints to business stakeholders
• Gather requirements, prioritize requests, manage stakeholder expectations, and present findings to technical and non‑technical audiences

Skills

SQL

Power BI

Python

Databricks

Excel

Data analysis

Education

Bachelor's degree in Data Science, Computer Science, Information Systems, Statistics, Business, or a related field

Tools

Databricks

Job description

CAI Computer Aid, Inc. is seeking a motivated Business Intelligence & Data Analyst to support BI, data analytics, cloud data migration, and reporting initiatives. You will work with Product and Engineering teams to connect large datasets, migrate legacy data to the cloud, and translate business needs into actionable insights.

This is a contract, onsite role in Miramar, FL. The position requires advanced SQL, Databricks, Power BI, and Python experience, plus strong Excel skills and the ability to