Business Intelligence Analyst

$135,000 - $145,000/Yr

Zachary Piper Solutions - McLean, VA

Full-time - Mid Level

McLean, VA

Professional, Scientific, and Technical Services

About the position

The Business Intelligence Analyst will play a crucial role in supporting data-driven decision-making within one of the nation's largest credit unions. This position involves collaborating with BI Developers and the channel manager to extract, manipulate, and visualize data, while also ensuring the integrity and security of data solutions. The role is hybrid, based in Mclean, VA, and focuses on designing and maintaining data warehouse solutions, developing dashboards, and performing data analysis.

Responsibilities

• Design, develop, and maintain data warehouse solutions using Snowflake, including data modeling, schema design, and ETL processes.
• Develop and optimize SQL queries, stored procedures, and scripts for data extraction, transformation, and loading.
• Build and maintain Tableau dashboards and reports to visualize data insights and provide actionable insights to stakeholders.
• Collaborate with cross-functional teams to gather requirements, understand business needs, and translate them into technical solutions.
• Perform data analysis and profiling to identify data quality issues and implement solutions.
• Ensure data security, integrity, and compliance with regulatory requirements.

Requirements

• 4+ years of experience in data analysis and related areas, including trend analysis, extracting actionable insights, and supporting decision-making with data.
• Experience in a field related to Consumer Banking products, including auto loans, personal loans, student loans, and credit cards.
• Extensive and proven data analytical skills.
• Hands-on skills in Tableau, SQL, and working with large datasets.
• Experience with R, Python, and Snowflake is a plus.
• Expertise in presenting findings, conclusions, alternatives, and information clearly and concisely.
• Extensive experience in demonstrating initiative-taking, decision-making, and creativity in solving business problems.
• Bachelor's degree in economics, mathematics, statistics, finance, engineering, computer sciences, or a related field.

Nice-to-haves

• Experience with R and Python.
• Experience with Snowflake.

Benefits

• Healthcare
• Dental
• Vision
• 401k
• Flexible work schedule