First Technology Federal Credit Union
BI Analyst, FP & Analysis
First Technology Federal Credit Union, Hillsboro, Oregon, United States, 97104
DescriptionThe Business Intelligence (BI) Analyst, Financial Planning & Analysis performs research, data extraction and analysis, building data and analytical tools and providing financial modeling to support profitability. Here's what you can expect from the job and what you need to be successful:
Job Duties
Provide financial modeling specific to profitability using external and internal toolsWrite, execute and maintain code proficiently to create and produce monthly and quarterly reporting and provide recommendations based on analysisResearch and analyze root causes of identified risk trends and validate data integrityAggregate data from multiple source systems to build data and analytical tools that offer deeper insight into enterprise data, allowing for critical decision making outputsDesign and build infrastructure for data extraction, preparation, and loading of data from a variety of sources using SQL and/or PythonValidate data, recognize errors, and make modifications to programs to meet changing needsOversee the maintenance of the operating procedures library and SQL/Python code for producing reportsEssential Skills
Minimum 2 years’ experience in a complex data analyst roleExperience building and optimizing “big data” pipelines, architectures and data setsExperience applying and developing analytical methods, including data mining techniquesExperience in the financial services industry is preferredAbility to anticipate needs and prioritize projects in a fast-paced environment with tight deadlines and high-volume peaks while producing high-quality workExcellent verbal and written communication skills; able to express ideas concisely and logically to all levelsStrong analytical and problem-solving skills with attention to detailDemonstrated effective time management skills and the ability to work independently or in a collaborative team environmentFamiliarity with Tableau is preferredStrong knowledge of non-Excel analytical tools such as Python, R, or SASStrong SQL skills and understanding of relational databasesAdvanced knowledge of Microsoft Office Suite, particularly Excel and VBAMinimum Education:
Bachelor’s degree in Statistical, Quantitative or Engineering is preferred, or equivalent work experienceLocation:
Hillsboro, OR 97124 | (HYBRID)
Target Compensation in Hillsboro, OR:
$86k - 93k annually + annual bonus
Benefits options include:
Traditional medical, dental, and vision coverage401K matching up to 5% per pay periodAccrue up to 17 days of Paid Time Off your first year of employment11 paid federal holidaysSpecial employee pricing on lending products such as mortgage, auto, and personal loans (eligibility for special employee pricing is subject to standard account requirements and underwriting criteria)What makes First Tech different? Click
here
to learn more!
First Tech is not currently offering Visa transfer/ sponsorship for this position
#LI-KW1
Job Duties
Provide financial modeling specific to profitability using external and internal toolsWrite, execute and maintain code proficiently to create and produce monthly and quarterly reporting and provide recommendations based on analysisResearch and analyze root causes of identified risk trends and validate data integrityAggregate data from multiple source systems to build data and analytical tools that offer deeper insight into enterprise data, allowing for critical decision making outputsDesign and build infrastructure for data extraction, preparation, and loading of data from a variety of sources using SQL and/or PythonValidate data, recognize errors, and make modifications to programs to meet changing needsOversee the maintenance of the operating procedures library and SQL/Python code for producing reportsEssential Skills
Minimum 2 years’ experience in a complex data analyst roleExperience building and optimizing “big data” pipelines, architectures and data setsExperience applying and developing analytical methods, including data mining techniquesExperience in the financial services industry is preferredAbility to anticipate needs and prioritize projects in a fast-paced environment with tight deadlines and high-volume peaks while producing high-quality workExcellent verbal and written communication skills; able to express ideas concisely and logically to all levelsStrong analytical and problem-solving skills with attention to detailDemonstrated effective time management skills and the ability to work independently or in a collaborative team environmentFamiliarity with Tableau is preferredStrong knowledge of non-Excel analytical tools such as Python, R, or SASStrong SQL skills and understanding of relational databasesAdvanced knowledge of Microsoft Office Suite, particularly Excel and VBAMinimum Education:
Bachelor’s degree in Statistical, Quantitative or Engineering is preferred, or equivalent work experienceLocation:
Hillsboro, OR 97124 | (HYBRID)
Target Compensation in Hillsboro, OR:
$86k - 93k annually + annual bonus
Benefits options include:
Traditional medical, dental, and vision coverage401K matching up to 5% per pay periodAccrue up to 17 days of Paid Time Off your first year of employment11 paid federal holidaysSpecial employee pricing on lending products such as mortgage, auto, and personal loans (eligibility for special employee pricing is subject to standard account requirements and underwriting criteria)What makes First Tech different? Click
here
to learn more!
First Tech is not currently offering Visa transfer/ sponsorship for this position
#LI-KW1