IAM Data Analytics, Senior

Freddie Mac; McLean (VA); On-site; USD 126,000 - 190,000; Full time

Job summary

Freddie Mac is seeking a Senior Data Analyst to join our Cyber Security team. You will develop and implement automated IAM processes, build data-driven security controls, and generate audit-ready documentation. The role emphasizes SQL-based data retrieval, risk assessment, and collaboration with enterprise stakeholders.

You will contribute to reducing security risk while enabling business outcomes, support ad hoc analyses, and explore AI-assisted replication of IAM services as needed.

Qualifications

• Typically, 5 - 7 years of related data analysis experience; bachelor's degree or relevant experience is required.
• Proven experience working with SQL at an enterprise level.
• Proficient with automated data processing flows including ETL and data semantics/normalization.
• Proficient with visual presentation tools, specifically within Microsoft PowerAutomate/PowerBI, Amazon QuickSight, Tableau Prep, and/or Tableau.
• Experience working in a regulated environment.
• Excellent written and verbal communication skills with the ability to clearly articulate in business and user-friendly languages.
• Ability to establish credibility across the enterprise to key business stakeholders, including directors, managers, system engineers, and end users.

Responsibilities

• Develop and administer data security policies and safeguard information.
• Support ad hoc data retrieval and analysis requests using SQL queries.
• Create audit-ready reference documentation.
• Support rapid AI-based extrapolation/replication of IAM services as needed.

Skills

SQL

Data analysis

Education

Bachelor's degree or relevant experience

Tools

Power BI

Tableau

Tableau Prep

Amazon QuickSight

Power Automate

Job description

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:

The Cyber Security team at Freddie Mac is searching for a strong data analyst to collaborate on developing and administering data security policies as well as safeguarding information, evaluating existing data security procedures and identifying new areas of risk for Freddie Mac.

Our Impact:

We develop and train the enterprise on relevant Identity and Access Management best practices, develop and support automated IAM processes, and develop and implement ongoing IAM efficiency improvements with limited oversight by managers. The role will work closely with Enterprise partners and security control owners on IAM automation development activities and alignment of IAM processes with InfoSec maturity targets as described in the InfoSec Strategy.

Your Impact:

Senior Data Analyst who can develop and implement new and updated business process automation for all Identity and Access Management activities. Develop and proposes strategies to reduce security risk in the organization by implementing procedural prevention, detection, and response measures, while still enabling positive business outcomes. Comfortable supporting ad hoc data retrieval and analysis requests using SQL queries and Copilot/Excel . Creating audit-ready reference documentation. This role will allow for and support rapid AI-based extrapolation/replication of these services as future automated IAM microservices.

Qualifications:

• Typically, 5 - 7 years of related data analysis experience; bachelor's degree or relevant experience is required
• Proven experience working with SQL at an enterprise level Proficient with automated data processing flows including ETL and data semantics/normalization
• Proficient with visual presentation tools, specifically within Microsoft PowerAutomate/PowerBI, Amazon QuickSight, Tableau Prep, and/or Tableau
• Experience working in a regulated environment
• Excellent written and verbal communication skills with the ability to clearly articulate in business and user-friendly languages
• Ability to establish credibility across the enterprise to key business stakeholders, including directors, managers, system engineers, and end users

Keys to Success in this Role:

• Experience with other modern data analysis processes, techniques, and tools (e.g., Alteryx Designer, SQL, Collibra, etc.)
• Financial Services Industry experience

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.

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 $126,000 - $190,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.