Job Description
Position Summary: Position will support the Global Portfolio Services group responsible for the process of collecting asset, investment, and fund data, analyzing results, preparing financial reviews for Senior Management and quarterly investor reports for the Limited Partners of each of the respective Lone Star Funds. This role requires a unique blend of strong finance knowledge and advanced IT skills, particularly proficiency in Python. As a key member of the team, the candidate will actively contribute to the automation of processes, integration of Third-Party APIs, and the development of financial applications relating to modeling and analysis.Hudson Advisors (hudson-advisors.com)Essential Functions: Collect, analyze, and validate global portfolio data including asset data, debt data, cash flow projections, fair market value, and net book values for all investments in the respective Lone Star FundsManage and oversee quarterly investor reports directly responsible for data collection, insuring data integrity.Leverage finance expertise to manage quarterly investor reports and oversee investment summaries.Develop and implement customized applications using Python to automate data collection, analysis, and validation processes.Integrate third-party APIs to enhance data retrieval and reporting capabilities.Collaborate with internal teams to identify opportunities for process automation and efficiency improvements.Create and maintain financial applications that contribute to investment and fund performance metrics.Generate and maintain all investments and fund performance metrics.Analyze foreign projections and support the Treasury's hedging needs.Prepare and review quarterly sensitivity analyses and reports for the risk, currency, and compliance committees.Conduct Ad hoc scenario analysis requested by various parties.Required Knowledge, Skills, and Abilities:Advanced proficiency in Python for application development, scripting, and automation.Solid understanding of finance and accounting principles.Experience working with third-party APIs and integrating them into financial applications.Familiarity with databases and SQL for data manipulation.Proficiency in Word, Excel, Outlook, and PowerPoint (Microsoft Office Suite)Ability to be self-taught.Power BI Advanced Excel knowledge, including the ability to summarize data via formulas, lookups, Pivot Tables, Power Pivot, etc.Strong quantitative skills and demonstrated analytical and problem-solving ability.High attention to detail and accountability in analytical assessmentsExcellent interpersonal skills, including ability to communicate clearly and concisely both orally and in writing with all levels of management. Hard-working, detail-oriented, and committed to producing great end results.Ability to thrive in a fast-paced, rapidly changing work environment with many competing priorities.Self-starter with the ability to multi-task Ability to work in a dynamic, deadline-driven environment. Ability to work autonomously and as a member of a team.Strong organizational skills Develops and drives accountability for self and others.Strong customer/client focus with the ability to provide a superior customer/client experience and build long-term relationships.Education:You must have a bachelor’s or Master’s Degree in finance, Accounting, IT, Computer Science, or a related field.CPA, CFA or foreign equivalent preferredExperience:Entry Level1-2 years of experienceWork Environment:This job is remote and would require the candidate to have access to a dedicated work space This position’s hours vary depending on business activity, but are generally 40 or more hours per week.Desired Organizational Competencies:Accountability Demonstrates a commitment to and responsibility for accomplishing individual, team and business objectivesTechnical proficiency in IT and programming, with a creative mindset.Innovative thinking to develop technology-driven applications for financial analysis and reporting.Ability to work autonomously and take ownership of application development projects.Drive Consistently achieves challenging goals/objectives, and demonstrates an ability to create value and maximize results Planning Identifies business needs, problems and risks proactively, and develops well founded plans that specify strategies, actions/solutions, risk mitigants and desired results Critical Thinking / Judgment Commits to an action after developing alternative solutions that are based on logical assumptions and factual information and that take into consideration resources risks and organizational values Adaptability Exhibits the capacity to successfully change and evolve one’s actions, opinions and behavior as a result of changing priorities or environment Communication Skills Proactively communicates in the appropriate medium with clarity and focus at the right level to ensure delivery has the appropriate impact Influential Leadership Leads with confidence and conviction, and is able to establish credibility, trust, and respect among team members Team Work Fosters collaboration among team members and business partners, and uses capabilities to achieve team goals