Senior Data Engineer

Freddie Mac

Dallas, TX

Full Time

Senior

127k-191k

27 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 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 enhance reliability and efficiency.

Requirements

Bachelor's degree in computer science, information technology, or related field; advanced studies/degree preferred.
5 years' extensive experience with Data Analytics technologies, Data Lake/Mart/Warehouse, SQL/NoSQL databases (e.g., DB2, Oracle, Sybase, Mongo, Postgres), Big Data Technologies (Spark or PySpark), ETL tools (Informatica, Talend), CDC (Attunity), REST API, and Integration/EAI technologies like Informatica.
3+ years' experience with BI tools such as MicroStrategy or Tableau and Data Management tools.
3+ years' experience with Web Service API, XML, JSON, JDBC, Java, Python.
3+ years' experience working with SaaS platforms such as Snowflake, Collibra, 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, MySQL, and AWS cloud databases.
Knowledge of data warehousing and business intelligence concepts including data mesh, data fabric, data lake, data warehouse, and data marts.
Experience in logical/physical data modeling, data architecture, data analysis, and data management roles for 5-7 years.

Nice to Have

Risk and GRC products experience.

Qualifications

Bachelor's degree in computer science, information technology or related field; advanced studies/degree preferred.

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 security obligations, and a Vigilance-first approach to work. The organization emphasizes regulatory compliance, privacy, security, and providing reasonable accommodations for applicants and employees. It promotes a diverse, inclusive workplace and adheres to fair employment practices.

Apply Now