Foundation Finance Company is looking to solve business problems by using data analysis to understand, interpret, and predict patterns in business, and then use those data-driven insights to enhance the business and support its goals.
Requirements
- Advanced SQL or Python data querying, coding experience and understanding of basic coding syntax
- Advanced Excel skills to create/edit pivot tables
- Understand/create/manipulate database formulas
- Create/modify macros (VBA knowledge preferred)
- Adjust formatting to create professional reports; Advanced data visualization skills, preferably with Tableau
- Tableau Certified Data Analyst or Tableau Desktop Specialist (preferred)
- Certified Analytics Professional (CAP®) is preferred
Responsibilities
- Dive into data and quickly become an expert on internal and non-traditional data sets.
- Migrate existing queries reliant on old technology into newly created platforms.
- Maintain data and file integrity. Optimize existing data query scripts and develop new ones as needed.
- Create user-friendly reports and Tableau visualizations for staff and management. Enhance existing and build new Tableau dashboards as needed.
- Track, review, manage and audit software development projects, particularly from database access and usage perspectives.
- Work with staff, managers and executives on analytic projects and develop data-driven solutions and recommendations, including working within the BI team.
- Executes creation of tabular operational reports and aggregation reports with medium to high complexity.
Other
- Must be able to come to work promptly and regularly.
- Must be able to take direction and work well with others.
- Must be able to work under the stress of deadlines.
- Must be able to concentrate and perform accurately.
- Bachelor’s degree in Finance, Business, Economics or related field required. MBA desired
