Freddie Mac's Enterprise Risk Business Technology Office needs to transform the Enterprise Risk and Compliance organizations by defining strategies, roadmaps, objectives, and delivering capabilities. This role will support data-driven initiatives, collaborate with business partners and technology teams, and design/implement data modeling solutions to assess and track risks, issues, controls, and compliance, and enable effective ERM data analytics and reporting.
Requirements
- 5 years’ extensive knowledge and experience in the Data technologies for Data Analytics, Data Lake/Mart/Warehouse, Databases SQL/NoSQL (DB2, Oracle, Sybase, Mongo, Postgres), Big Data Technologies (Spark or PySpark), ETL (Informatica, Talend), CDC (Attunity), REST API, Integration/EAI technologies like Informatica
- 3+ years’ experience in BI tools (MicroStrategy/Tableau), Data Management tools
- 3+ years’ experience with Technologies including Web Service API, XML, JSON, JDBC, Java, Python.
- 3+ years working with SaaS platforms such as Snowflake, Collibra, Mongo/MongoDB Atlas,
- 5-7 years’ experience in a logical/physical data modeling, data architecture, data analysis, and data management role
- Experience with data modeling tools like ERwin, ER/Studio or Power Designer
- Experience with database technologies such as Oracle, DB2, Sybase, PostgreSQL, Snowflake, S Server, MySQL, and AWS cloud databases
Responsibilities
- Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
- Architecting and documenting data warehouse solutions using data modeling
- 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.
- Assist team with finding patterns and relationships in data and identifying opportunities to monitor data quality
- Analyze and resolve data issues
Other
- 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
- Excellent problem-solving skills and attention to detail
- Effective communication and interpersonal skills
- Ability to work independently and in a team environment
