• Business Analyst-SQL Jobs in United States Of America - 25309929

  • First American Financial Corporation Ltd.
  • United States Of America, Usa
  • Save Job
  • 2 - 5 Years
  • Posted : above 1 month

Job Description:

Employment Category Full Time Regular

Company Summary

Join our team! First Americans Mortgage Solutions division provides lenders with solutions to originate, close and service quality loans As a global leader in providing title insurance, settlement services and risk solutions for real estate transactions, First American (NYSE FAF) is an ideal place to build your career We have been entrusted with helping our customers achieve and protect their dream of homeownership since 1889 We believe that our people are the key to the companys continued success, and we invest in diverse talents and backgrounds and empower our teams to achieve more than they could anywhere else First American has created an award-winning culture and has been named to the Fortune 100 Best Companies to Work For list for the fourth consecutive year and to more than 50 regional Best Places to Work lists For more information, please visit wwwfirstamcom/mortgagesolutions/

Job Summary

Experienced Analyst with advanced SQL query language and report writing skill set Has business and operations knowledge and is able to use that knowledge to bring insight to the role, identify issues and inefficiencies, and recommend process improvements

Essential Functions

Gathers and analyses requirements to design and implement customized solutions and provide improvement per best practices
Creates complex reports using tools such as SQL Server Reporting Services (SSRS) and Power BI Gather and document functional and technical report requirements and translate requirements into reporting solutions
Ability to communicate business needs to technical staff as well as understand business requirements and design user-friendly reports and dashboards
Develops in-depth knowledge of underlying data, data structures, and business uses to ensure reports meet business needs
Creates test cases and performs QA to ensure accurate and complete testing
Creates technical documentation of report logic and processes
Work with developers and analysts to understand code changes that will impact reports
Guide other IT resources in coding and report writing best practices
Working with business partners and SMEs, creates documentation of business processes, training procedures, and standard operating procedures

Job Complexities

Works in a dynamic, multi-functional environment with numerous priorities
Works on a wide range of problems where analysis of situations or data requires a review of a variety of factors
Acts in an advisory capacity, influencing and making recommendations which may have an important bearing on the conduct of the business segment
Exercises judgment within defined procedures and practices to determine appropriate action Has the creative latitude to work outside policy and develop new solutions
Negotiates, persuades, and gains consensus from implementation team and/or management

Supervision Received or Extended

No responsibility for the supervision of others
Works independently setting own priorities and objectives with supervisory consultation
Regularly makes recommendations to and influences department policies and procedures
Actively contributes to the results of a team and works towards achieving team goals and objectives
Uses expertise of more senior level Business Analysts and team members and leverages additional resources to confirm solution or explore customized applications as a solution

Knowledge and Skills/Technology Used

Analytical skills to determine root cause of problems and apply creative and effective solutions
Ability to analyze a situation, interview, formulate questions, and probe for deeper knowledge/ understanding
Data management skills
Advanced SQL/TSQL query writing skills
Experience optimizing queries to minimize load on system resources
Excellent prioritization skills and ability to change course as required by the business
Has basic knowledge of general business, production, and/or operation environment and general cost benefit awareness
Excellent written and oral communication skills in order to define parameters to meet business requirements
Presentation skills
Standard MS skill set
Experience with Star and Snowflake schemas preferred

Experience with relational databases preferred

Typical Education

Generally requires BS Degree or equivalent work experience

Typical Range of Experience

Typically have 2- 5 years of directly related experience

First American invests in its employees development and well-being, empowers them to provide superior customer service and encourages them to serve the communities where they live and work First American is committed to diversity and inclusion We are an equal opportunity employer For more information about our Company and our dedication to putting People First, check out firstamcom/careers

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Financial Services/Stockbroking, Banking
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status