Overview:Data Analyst II Description & Duties:The Data Analyst II plays a significant role by using the data analysis process to understand, interpret, and predict patterns in business, and then use those data-driven insights to enhance the business and support it goals. This role is used to guide the business by understanding historical business to create future avenues of growth. Pay Range: USD $70,000.00 - USD $75,000.00 /Yr. Responsibilities:Essential Duties and 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.
Handles more complicated report requests, data visualizations and trend analysis.
Helps to define guidelines for data management, governance, and reporting.
Contribute to workflow or process change/redesign and to form a strong basic understanding of the specific product or process.
Other duties as assigned by management.
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. Must be able to react to change productively. Qualifications:Minimum Qualifications:
Bachelor’s degree in Finance, Business, Economics or related field required. MBA desired
3 years’ experience in data analytics required
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.
Description:About Foundation Finance:Foundation Finance Company (FFC) is one of the fastest-growing consumer finance companies in the U.S. We work with home improvement contractors nationwide to help them close more sales through the use of flexible financing plans. FFC's full-spectrum lending approach has driven billions in originations and helped many customers make needed improvements to their homes. We're making big investments in both infrastructure and employee talent to keep up with our growth, so the time is right to join our team! It's a fast-paced environment with room to advance. We offer a competitive salary, medical/dental/vision benefits, 401(k) with company match, a casual dress work environment and much, much, more.Working Conditions:Office environment with significant time spent sitting, typing and talking on the telephone.Foundation Finance Company provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.If you reside in the state of Colorado, please click on the following link to review our benefits:These benefits are designed to support our employees in their professional growth, health, and overall well-being. Eligibility, coverage details, and enrollment processes will be provided during the onboarding process. At Foundation Finance Company, we are committed to fostering a positive work environment where employees can thrive both personally and professionally. Remote Work:Foundation Finance Company LLC requires that remote employees must reside in one of the following states to be considered for any of our remote positions: AL, AR, AZ, CO, CT, FL, GA, IL, IN, KY, LA, MD, ME, MI, MN, MO, MS, NC, NJ, NV, NY, OH, OK, OR, SC, TN, TX, UT, VA, WA, and WI.