Job Description
Job Description
We are seeking a Data and Reporting Analyst for a fast growing Fortune 500 financial services company located in Irvine. 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. The main objective will be creating analytics for business units, transitioning our data from multiple sources to a SQL database. This role will not have any direct reports.
We are seeking a person that thrives in a fast-paced environment and technically talented to provide support for our internal teams. If you are looking for a company that is continuously evolving and growing, this is the place for you.
Responsibilities and Duties
- Interfacing with internal / external business SMEs to create and maintain operational reporting in Salesforce, Power BI and Excel
- Scoping out business requirements and creating reports from multiple sources
- Creating and maintaining performance queries to expedite data refresh times
- Analyzing and manipulating data as required for ad-hoc analysis
- Isolating and resolving data source issues with limited supervision and oversight
- Collaborating with other team members to assist in data related tasks
Qualification and Skills
- 5+ years of experience with SQL, SSIS, SSRS
- 5+ years of loading, importing, and exporting data into and from databases
- 2+ years of reporting and dashboard creation in Salesforce
- 2+ years of defining DAX measures and modeling in Power BI
- Experience with Python / VBA a plus
- Advanced Excel skills including Power Query
- Good written and verbal communication skills
- Problem-solver with the ability to understand business issues and implement robust solutions
- Excellent organization, prioritization and deadline focus skill sets
- Reliable, self-motivated, and accountable for assigned work
- Bachelor’s degree or equivalent
- 2+ year mortgage experience preferred
Company Description
Are you seeking new opportunities? Connect with us to find your next role!
Company Description
Are you seeking new opportunities? Connect with us to find your next role!