Freddie Mac's Enterprise Risk Business Technology Office needs to define strategies, roadmaps, objectives, and deliver capabilities that transform the businesses. This role will be responsible for supporting our organization’s data-driven initiatives, collaborating with business partners and multi-discipline technology teams, and designing and implementing data modeling solutions to optimally assess and track all risks, issues, controls, and compliance.
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 different query languages such as PL/SQL, T-SQL, and ANSI SQL
Responsibilities
- Business requirements gathering and solutioning in alignment with enterprise business data strategy
- Architecting and documenting data warehouse solutions using data modeling
- Design, implement, and optimize end-to-end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data.
- Assist team with finding patterns and relationships in data and identifying opportunities to monitor data quality
- Analyze and resolve data issues
- 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.
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
