Data Analytics Tech lead

Job Description At Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. Position Overview Are you a seasoned data professional ?. We are looking for a Data guru who has worked on creating Data Marts , Data warehouses on-premise and on cloud for real time and batch processing frameworks .Ideal candidate has extensive hands-on experience building and optimizing data structures for data analytics, data science and business intelligence. Experience building self-service data consumption patterns and knowledge of cloud-based data Lake platforms are a must. Desired practical experience including, but not limited to wrangling data (structured and unstructured), in-depth knowledge of database architecture, both on-premise and cloud-based, and optimizing data systems and building them from the ground up in support of analytic and reporting applications. To learn more about our excellent benefits, apply and learn why there's MoreAtFreddieMac! Our Impact Information, Intelligence, and Insights team is responsible for creating Dashboards, Analytics, AI ML models for our single family business partners The Data team in I3 helps collection, processing and storage of data to provide data to the developers in an agile and governed manner Our team is leading the efforts of I3 team to move the data to target state on Cloud We manipulate, process, and extract value from large disconnected datasets We assemble large, complex data sets that meet functional non-functional business requirements We Identify, design, and implement internal process improvements automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Your Impact Responsible for simplifying the complexity of our ecosystem for customer reporting, analytics, and BI consumption patterns Serve as a liaison with IT for structuring the data for analytics and BI Build Data Marts and Data warehouses to facilitate analytical capabilities across the varied sources of data across Freddie Mac Coordinate, convince and create a centralized data provisioning process for analytical capabilities of the team Design and implement data patterns on cloud using cloud Data warehouse and data virtualization tools Evaluate new tools and technologies for target state on cloud Learn and implement new ETL, BI tools and data warehousing technologies Qualifications Bachelor's degree in Computer Science, Data Analytics, Information Systems, or a related degree or equivalent experience Master's degree preferred 8+ years of related work experience Knowledge of an analytical tool ( SAS , Python ), ETL tools (i.e. Informatica Talend), and a virtualization tool (i.e. Denodo, Dremio ) or another analytical tool Experience working with AWS cloud-native technologies, S3, Athena Advanced working SQL knowledge and experience working a variety of databases technologies (PLSQL, MySQL, JDBC, NoSQL) Experience building and optimizing big-data data pipelines and data sets including Postgres, AWS Relational Data Service Experience shredding XMLJSON files and MongoDB as a data source Knowledge of Tableau andor MicroStrategy a plus Knowledge of Snowflake a plus Familiarity with Secondary Mortgage Market andor Freddie Mac business and operations also a plus Strong leadership experience in highly matrixed environment Strong verbal and written communication skills, including the ability to present content from low to high levels of complexity to audiences of varying levels of seniority. Ability to interact cross-functionally and participate in both business and technical discussions. Proven track record serving as lead on major projects andor programs People management experience a strong plus Keys to Success in this Role Multi-task prioritize Relationship builder inside and outside of I3 Harness the power of data to formulate and advise communications Keep calm under pressure Convince teams to adhere to the processes and data patterns Stay current on policies and regulations that may affect the industry and be comfortable with transition and change Current Freddie Mac employees please apply through the internal career site. Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you'll do important work for the housing finance system and make a difference in the lives of others. We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. Notice to External Search Firms Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee. If interested in learning more, please visit www.BountyJobs.com httpwww.bountyjobs.com and register with our referral code MAC. Time-typeFull time Job CategoryData Management FLSA StatusExempt