Data Analyst – BI & SQL Expert (Mexico)

Farmers Insurance Careers Mexico; Ciudad de México; On-site; MXN 420,000 - 720,000; Full time

Benefits offered by this job

Competitive compensation

Performance-based bonuses

Comprehensive benefits

Ongoing training

Job summary

Farmers Insurance Careers Mexico seeks a data-focused professional to provide data in response to requests for reports or analysis. You will understand customer objectives, communicate system capabilities, and deliver available data while analyzing data quality and supporting reporting infrastructure.

Responsibilities include extracting data with SQL and BI tools, formatting results in Excel, and assisting with testing and data quality improvements.

Qualifications

• High school diploma or equivalent required. Bachelor’s degree preferred, in Information Systems or related field.
• 2+ years experience with data extraction, manipulation and presentation in usable format
• Internal candidates: 2+ years Farmers or other insurance claims experience. External candidates: 2+ years experience with data extraction, manipulation and presentation in usable format

Responsibilities

• Extract and manipulate data to solve business problems and respond to new report requests.
• Use Cognos ReportNet, OBIEE Answers, or similar interfaces to extract data.
• Query relational databases (Oracle, SQL Server) and data warehouses to gather data.
• Format data for business use in Excel or Access; create and maintain scripts/macros to automate reports.
• Support application testing for enhancements or system upgrades and identify data quality issues.
• Communicate clearly about data limitations and document unique data aspects for stakeholders.

Skills

Excel

SQL

Communication

Education

Bachelor’s degree in Information Systems or related field

Tools

Cognos ReportNet

OBIEE Answers

BusinessObjects

STATISTICA

MS Access

Job description

Farmers Insurance Careers Mexico seeks a data-focused professional to provide data in response to requests for reports or analysis. You will understand customer objectives, communicate system capabilities, and deliver available data while analyzing data quality and supporting reporting infrastructure.

Responsibilities include extracting data with SQL and BI tools, formatting results in Excel, and assisting with testing and data quality improvements.