Senior Data Engineer

Freddie Mac

Mclean, VA

Full Time

Senior

127k-191k

26 days ago

Job Description

About the Role

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. The Senior Data Engineer will be part of Freddie Mac's Enterprise Risk Business Technology Office, responsible for supporting data-driven initiatives, collaborating with business partners and technology teams, and designing and implementing data modeling solutions. This role requires strong experience in data analysis, modeling, and engineering with the ability to communicate complex technical issues effectively to executive audiences with varied technical backgrounds.

Key Responsibilities

Gather business requirements and develop solutions aligned with enterprise data strategy.
Architect and document data warehouse solutions using data modeling techniques.
Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
Assist the team in identifying patterns, relationships, and opportunities to monitor data quality.
Analyze and resolve data issues to ensure data integrity and accuracy.
Evaluate and implement data storage solutions including relational databases, NoSQL databases, data lakes, and cloud storage services.
Build and maintain integrations with internal and external data sources and APIs.
Monitor system performance, troubleshoot issues, and implement optimizations to improve reliability and efficiency.

Requirements

Bachelor's degree in computer science, information technology, or a related field; advanced studies/degree preferred.
5 years' extensive experience with Data technologies for Data Analytics, Data Lake/Mart/Warehouse, and Databases (SQL/NoSQL) such as DB2, Oracle, Sybase, Mongo, Postgres.
3+ years' experience with BI tools (MicroStrategy/Tableau) and Data Management tools.
3+ years' experience with Web Service API, XML, JSON, JDBC, Java, Python.
3+ years working with SaaS platforms such as Snowflake, Collibra, Mongo/MongoDB Atlas.
Knowledge of enterprise data models, information classification, meta-data models, taxonomies, and ontologies.
Experience with data modeling tools like ERwin, ER/Studio, or Power Designer.
Experience with query languages such as PL/SQL, T-SQL, and ANSI SQL.
Experience with database technologies including Oracle, DB2, Sybase, PostgreSQL, Snowflake, and AWS cloud databases.
Knowledge of data warehousing and business intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts.
Ability to operate as a self-motivated, pro-active, and result-driven problem solver with excellent analytical and interpersonal skills.
Quick learner of new technologies, tools, concepts, and ability to translate them to challenge the status quo.
Effective communication and interpersonal skills.
Ability to work independently and in a team environment.

Nice to Have

Risk and GRC products experience.

Qualifications

Bachelor's degree in computer science, information technology or related field.

Benefits & Perks

Competitive compensation and market-leading benefit programs.
Participation in an annual incentive program.
Total rewards package including comprehensive benefits.

Working at Freddie Mac

Freddie Mac values a safe and secure environment, employee commitment to policies and procedures, regulatory compliance, and best practices to protect the organization from threats and risks. The company emphasizes a vigilant-first approach, privacy and security obligations, and providing reasonable accommodations for applicants and employees.

Apply Now