BI and System Analyst (Remote)

ForFutures Financial, Planning, a financial advisory practice of Ameriprise Financial Services LLC; Santa Ana (CA); Remote; USD 72,000 - 97,000; Full time

Job summary

A national commercial services company is looking for a BI Analyst in Santa Ana, California. The ideal candidate will have strong experience with BI tools, data analysis, and a Bachelor’s degree in a related field. Responsibilities include developing dashboards and ensuring data integrity. The role offers a competitive salary and comprehensive benefits package.

Benefits

Medical and dental insurance

401k plan

Employee stock purchase plan

Qualifications

• 5+ years of experience in analytics, data management, and data intelligence.
• Experience with cloud-based BI solutions is a plus.
• Understanding of data governance and security best practices.

Responsibilities

• Gather and analyze business requirements to identify improvement opportunities.
• Develop and optimize BI dashboards and reports.
• Ensure data integrity through validation and mining.

Skills

BI tools experience

SQL

Data analysis

Problem-solving

Communication

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

Tableau

SQL databases

Job description

Join a team that puts its People First! As a member of First American's family of companies, National Commercial Services provides single-point service for simple to multi-property/multi-state national commercial real estate transactions. Since 1889, First American (NYSE: FAF) has held an unwavering belief in its people.

As a member of the BI & Analytics team, you will play a crucial role in bridging business needs with technological solutions. This position involves analyzing data, designing, and maintaining reporting systems, and ensuring that business processes are optimized through effective use of technology.

Key Responsibilities

• Gather and Analyze Requirements: Collect, analyze, and document business requirements from stakeholders to identify opportunities for data-driven improvements.
• Develop and Optimize BI Solutions: Create, maintain, and enhance BI dashboards, reports, and visualizations to support informed decision-making.
• Ensure Data Integrity: Conduct data mining, cleansing, and validation to guarantee data accuracy and integrity.
• Collaborate on Data Solutions: Work with IT and business teams to design, implement, and maintain data warehouses and reporting systems.
• Enhance Systems and Processes: Evaluate existing systems and processes, recommend enhancements, and support system integration efforts.
• Provide User Training and Support: Offer training and support to end users on BI tools and reporting systems.
• Monitor and Troubleshoot BI Solutions: Oversee the performance of BI solutions and address issues as they arise.
• Stay Informed on Industry Trends: Be up-to-date with industry best practices, trends, and emerging technologies in BI and system analysis.

Qualifications

• Bachelor’s degree in computer science, data analytics, or a related field.
• Proven experience as a BI Analyst, System Analyst, or in a similar role, with 5+ years of expertise in analytics, data management, and data intelligence.
• Strong hands-on experience with BI tools such as Power BI, Tableau, or Domo.
• Strong knowledge of SQL and experience working with relational databases.
• Familiarity with data warehousing concepts and ETL processes.
• Experience with data pipeline tools in modern data platforms (Databricks, BigQuery, or Snowflake).
• Excellent analytical, problem-solving, and communication skills.
• Ability to translate business requirements into technical specifications.
• Experience with system analysis methodologies and process mapping.

Preferred Skills

• Experience with cloud-based BI solutions (e.g., Azure, AWS).
• Knowledge of programming languages such as Python or R for data analysis.
• Understanding of data governance and security best practices.
• Project management experience or certification is a plus.

Pay Range: $72,100- $96,100 annually

First American is an equal opportunity employer in every sense of the term. We are proud to foster an authentic and inclusive workplace For All. You are free and encouraged to bring your entire, unique self to work.

Note that First American will consider for employment all qualified applicants, including those with arrest or conviction records, in a manner consistent with the requirements of applicable state and local laws.

Based on eligibility, First American offers a comprehensive benefits package including medical, dental, vision, 401k, PTO/paid sick leave and other great benefits like an employee stock purchase plan.