Data Analytics Senior (Oracle EPM Cloud)

At Freddie Mac, our mission of Making Home Possible is what motivates us, and it’s at the core of everything we do. Since our charter in 1970, we have made home possible for more than 90 million families across the country. Join an organization where your work contributes to a greater purpose.

Position Overview:

Finance’s Hyperion Reporting team is primarily responsible for creating, enhancing, and maintaining data cubes that are used for multiple critical business functions including budgeting, forecasting, and scenario analysis. The senior on the team is responsible for providing technical support for Hyperion’s Enterprise Performance Management (EPM) Cloud capabilities as well as providing end user support as needed. Additionally, the team owns and supports the Workiva Wdesk application used to consolidate and publish the company’s financial statements and board reporting.

Our Impact:

The Data Analytics Senior will help to maintain the Hyperion Reporting team’s relationships with cross-divisional internal customers and support the roadmap of future strategy and application development. The senior will also provide technical and business support for the team’s applications including several Hyperion cubes that comprise the EPM Cloud as well as the Wdesk application. The senior will interact directly with internal users to assist with technical issues and support reporting. The senior will also support the relationship with the EPM Cloud and Wdesk vendors.

Your Impact:

Support and champion the team’s strategy and technology roadmap

Serve as the technical domain expert for changes impacting the Hyperion Reporting team’s applications

Engage with partners to identify emerging needs and opportunities

Work with the team to find patterns and relationships in data and see opportunities to monitor data quality

Use experience and application knowledge to analyze and resolve data issues

Apply understanding of data warehouse / database concepts, as well as experience in relational database structures, research methods, sampling techniques, and system testing

Good understanding and demonstrable experience with Automation processes using ETL tools and python scripts (experience with EPM Automate is a plus)

Solid understanding of API Calls and Rest API processes

Solid experience in developing application code for Oracle EPM solutions such as Calc Scripts, Business Rules and Data Management/Data Exchange Rules, specifically in the EPBCS space

Support the Finance data office in developing the data strategy implementation roadmap

Qualifications:

Bachelor’s degree or foreign equivalent in Computer Science, Engineering, Statistics or related quantitative field

5+ years data analytics/data science experience with at least 3+ years hands-on experience with Oracle EPM Cloud (Hyperion EPM Cloud)

In depth understanding of internal Freddie Mac system functionality highly desirable

Good experience in scripting languages (Python, Batch scripting, Oracle EPM Business Rules)

Solid understanding of relational databases, SQL, and data modeling

Prior experience working with an agile team in a business role preferred

Ability to convey complex ideas in a clear, concise fashion to technical and non-technical audiences

Ability to manage multiple efforts and customers simultaneously and effectively

Strong organization and time management skills: Operates independently with minimal guidance and keeps partners and management informed of critical updates and developments

Keys to Success in this Role:

Ability to translate sophisticated financial data into relevant analysis and presentations

Ability to understand and communicate well

Ability to work in a dynamic, constantly evolving business environment

Intellectually curious and strong attention to details and be able to multi-task

Ability to work well in a collaborative environment as well as individually

Experience working in a team environment including interacting with customers or partner

Current Freddie Mac employees please apply through the internal career site.

We consider all applicants for all positions without regard to gender, race, color, religion, national origin, age, marital status, veteran status, sexual orientation, gender identity/expression, physical and mental disability, pregnancy, ethnicity, genetic information or any other protected categories under applicable federal, state or local laws. We will ensure that individuals are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

A safe and secure environment is critical to Freddie Mac’s business. This includes employee commitment to our acceptable use policy, applying a vigilance-first approach to work, supporting regulatory mandates, and using best practices to protect Freddie Mac from potential threats and risk. Employees exercise this responsibility by executing against policies and procedures and adhering to privacy & security obligations as required via training programs.

CA Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com and register with our referral code: MAC.

Time-type:Full time

FLSA Status:Exempt

Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.

This position has an annualized market-based salary range of $104,000 - $156,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.