Senior Data Engineer

Freddie Mac

Dallas, TX

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 to executive audiences with varied 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 data 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 related field; advanced studies/degree preferred.
At least 5 years of extensive experience with data technologies for analytics, data lakes, data warehouses, and databases such as SQL/NoSQL (e.g., DB2, Oracle, Sybase, Mongo, Postgres).
Over 3 years of experience with BI tools (MicroStrategy, Tableau) and data management tools.
More than 3 years of experience with technologies including Web Service API, XML, JSON, JDBC, Java, Python.
Experience working with SaaS platforms such as Snowflake, Collibra, MongoDB Atlas.
Knowledge of enterprise data models, information classification, metadata models, taxonomies, and ontologies.
Experience with data modeling tools like ERwin, ER/Studio, or Power Designer.
Proficiency with query languages such as PL/SQL, T-SQL, and ANSI SQL.
Experience with database technologies including Oracle, DB2, Sybase, PostgreSQL, Snowflake, MySQL, and AWS cloud databases.
Understanding of data warehousing and business intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts.
Strong analytical, problem-solving, and interpersonal skills, with the ability to work independently and in teams.

Nice to Have

Experience with risk and GRC products.
Exposure to full-stack enterprise application development (Angular, Spring Boot, Selenium, Cucumber).
Knowledge of cloud platforms and automation testing.

Qualifications

Bachelor's degree in a related field; advanced degree preferred.

Benefits & Perks

Competitive compensation package.
Market-leading benefit programs.
Participation in an annual incentive program.
Total rewards including health, retirement, and other benefits.

Working at Freddie Mac

Freddie Mac values a safe and secure environment, emphasizing employee commitment to policies, regulatory mandates, and best practices for security and privacy. The organization promotes a VIGILANCE-FIRST approach, supporting diversity and inclusion, and providing reasonable accommodations for applicants and employees.

Apply Now