Our client in the Mortgage / Finance space is seeking a Data and Reporting Analyst. In this role, the candidate will be responsible for updating current reports and creating new reports. Responsibilities include but is not limited to, data preparation and delivering reporting and business intelligence to end users through Power BI. Our main objective will be creating analytics for business units, transitioning our data from multiple sources to a SQL database. This role will not any direct reports.
This individual will need to be near or in Irvine, CA as this will be hybrid onsite, 2 days a week.
Responsibilities and Duties
o Interfacing with internal / external business SMEs to create and maintain operational reporting in Salesforce, Power BI and Excel
o Scoping out business requirements and creating reports from multiple sources
o Creating and maintaining performance queries to expedite data refresh times
o Analyzing and manipulating data as required for ad-hoc analysis
o Isolating and resolving data source issues with limited supervision and oversight
o Collaborating with other team members to assist in data related tasks
Qualification and Skills
o 5+ years of experience with SQL, SSIS, SSRS
o 5+ years of loading, importing, and exporting data into and from databases
o 2+ years of reporting and dashboard creation in Salesforce
o 2+ years of defining DAX measures and modeling in Power BI
o Experience with Python / VBA a plus
o Advanced Excel skills including Power Query
o Good written and verbal communication skills
o Problem-solver with the ability to understand business issues and implement robust solutions
o Excellent organization, prioritization and deadline focus skill sets
o Reliable, self-motivated, and accountable for assigned work
o Bachelors degree or equivalent
o 2+ year mortgage experience preferred
In this position, you may have access to client or customer systems, confidential and/or proprietary information or data, including financial information. This position is onsite and requires you to work closely with other individuals in a collaborative team environment.
Benefits
Benefits include Medical, Dental, and Vision insurance, company-paid life insurance, 401K with a generous employer match and additional benefits such as Free Legal Services and an Employee Loan Program.
Looking forward to receiving your resume through our website and going over the position with you. Clicking apply is the best way to apply, but you may also:
Email your resume in Word to:
allie.reilly@jobalert.creativecircle.com
**Please do NOT change the email subject line in any way. You must keep the JobID: : AR18-1826505 -- in the email subject line for your application to be considered.***
Allie Reilly - Lead Recruiter
For this position, you must be currently authorized to work in the United States without the need for sponsorship for a non-immigrant visa.
Creative Circle will consider for Employment in the City of Los Angeles qualified Applicants with Criminal Histories in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring (Ban the Box) Ordinance.
This job was first posted by Creative Circle on 10/22/2024 and applications will be accepted on an ongoing basis until the position is filled or closed.
Creative Circle is an Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, or any other characteristic protected by law. Creative Circle will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. If you need a reasonable accommodation in the application process, please contact your Recruiter (the person you'll be interviewing with) or a member of our Human Resources team to make arrangements. United Healthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Creative Circle.
Copyright 1999 - 2024. CreativeCircle, Inc. All rights reserved.
