Business Analyst II

Job Title: Business Analyst II

Job Type: Full-time

Department Hours: Monday – Friday 8:30 AM – 5:00 PM

Location: Virginia Beach, Virginia

Hiring Range: $28 - $37 per hour

(Higher compensation may be considered based on experience, qualifications, and internal equity)

All of us at Chartway stand united in our strong culture of listening and learning. We treat people with respect, integrity, and kindness, and are committed to continuously developing a diverse and inclusive workplace where team members are empowered to be their authentic selves. All backgrounds, viewpoints, and life experiences are welcome, knowing this commitment strengthens our credit union family and communities.

The Business Analyst will apply analytical skills to business challenges across Chartway. This position will work in a collaborative environment on a horizontal team supporting several business units who will value the insights and recommendations you will bring. This position will problem-solve through data while thoughtfully incorporating product dynamics, marketing influences, and wide range of member impact into recommended solutions. Using rigorous analytical techniques, be able to extract and interpret complex data elements and in a refined manner communicate to inform and influence leaders across Chartway.

Responsible and Accountable for:

• Develops and maintains action-based reporting and dashboards using Power BI and coding in SQL, writing and optimizing SQL queries delivering monthly metrics to identify trends and opportunities.

• Collaborates with cross-functional teams, including Data Engineering, Application Technology, and business line managers, to support data-driven initiatives and ensure the accuracy and validity of data.

• Supports business initiatives by providing analytical insights, makes recommendations and clearly communicates findings through custom-coded SQL queries, Power BI visuals, and DAX expressions.

• Works closely with various teams on projects to obtain necessary data, and track performance.

• Translate complex data into clear, actionable recommendations that align with the organization’s goals and objectives, leveraging DAX measures and SQL code where appropriate.

• Translate complex data into clear, actionable recommendations that align with the organization’s goals and objectives, leveraging DAX measures and SQL code where appropriate.

• Gather, clean, and integrate data from multiple sources (data warehouse, spreadsheets, etc.) to create centralized, accurate, and accessible reporting.

• Transform strategic and operational inquiries into actionable analytics requirements, extract and analyze data using SQL, and present insights in a clear, compelling narrative to inform decision-making and drive action.

• Personally develop and maintain advanced performance reports, dashboards, and visualizations using Power BI, incorporating drill-through features, bookmarks, tooltips, and parameterized filters.

• Develop and code SQL queries and DAX expressions to create custom reports aligned with the specific needs of our various business lines.

• Participate in thorough SQL code review to ensure best practices, optimize query performance, and maintain data integrity.

Knowledge, Skills and Abilities:

• Skilled in writing, optimizing, and validating complex queries using SQL (joins, aggregations, temp tables, data transformation, data integration, debugging, etc.).

• Skilled in using Power BI to visually present data stories with actionable insights, including expertise in data modeling, dashboard design, and DAX formula creation.

• Demonstrates strong critical thinking, problem-solving, and troubleshooting skills, with the ability to work independently and take initiative.

• Must be detail oriented and possess good analytical and organizational skills.

• Self-starter who is able to be hands-on and can analyze, interpret and derive insights into business reports, analytic models, and data sources

• Ability to multi-task and be detail orientated in a fast-paced environment.

• Ability to be self-directed, work independently, and demonstrate strong initiative.

• Analytic and problem-solving skills with the ability to communicate complex information in a clear and concise manner.

• Strong communication skills with proven ability to explain complex analytical concepts to non-analytical audiences.

Education and Experience:

• Education: Bachelor’s degree preferred or equivalent work experience in Business Analytics. Master's in related field or related certifications encouraged.

• Experience: Skilled with querying data using SQL; able to independently access, retrieve, organize and analyze data; able to perform peer SQL code review to ensure accuracy

• Skilled with data visualization tools. Power BI (Tableau) experience preferred, but similar systems with transferrable skillsets are acceptable.

Chartway offers a competitive salary and a comprehensive benefits package. Candidates must have a good credit history for consideration. Salary requirements must be included, and resumes must be accompanied by a Chartway Employment Application for consideration.

Chartway Federal Credit Union is an EOE/M/F/Disability/Vet Employer.

If a reasonable accommodation is needed for the job interview process, please contact our Talent Acquisition Team at 1-877-319-4818 extension 45863 or email us at [email protected].