Business Analyst II
About The Position
The Business Analyst II applies analytical skills to business challenges across Chartway, working collaboratively on a horizontal team that supports several business units. The role uses data analysis while considering product dynamics, marketing influences, and member impact to develop recommendations. It extracts and interprets complex data and communicates findings to inform and influence leaders. The position develops and maintains reporting, dashboards, and visualizations using Power BI, SQL, and DAX. It gathers and integrates data from multiple sources, translates business inquiries into analytics requirements, and presents actionable insights that support organizational goals and decision-making. The role also collaborates with Data Engineering, Application Technology, business line managers, and other teams to support initiatives, track performance, validate data, and review SQL code. The position is full-time, based in Virginia Beach, Virginia, with department hours Monday through Friday, 8:30 AM to 5:00 PM. The hiring range is $28–$37 per hour; higher compensation may be considered based on experience, qualifications, and internal equity. Candidates must have a good credit history for consideration. Salary requirements must be included, and resumes must be accompanied by a Chartway Employment Application.
Requirements
- Skilled in writing, optimizing, and validating complex SQL queries, including joins, aggregations, temporary tables, data transformation and integration, and debugging.
- Skilled in Power BI data modeling, dashboard design, DAX formula creation, and visually presenting data stories with actionable insights.
- Strong critical-thinking, problem-solving, and troubleshooting skills, with the ability to work independently and take initiative.
- Detail-oriented, with good analytical and organizational skills.
- Able to analyze, interpret, and derive insights from business reports, analytical models, and data sources.
- Able to multitask and work in a fast-paced environment while maintaining attention to detail.
- Able to work independently and demonstrate initiative.
- Able to communicate complex analytical information clearly and concisely, including to non-analytical audiences.
- Skilled in querying data with SQL and independently accessing, retrieving, organizing, and analyzing data.
- Able to perform peer SQL code reviews to ensure accuracy.
- Candidates must have a good credit history for consideration.
- Salary requirements must be included with the application; resumes must be accompanied by a Chartway Employment Application.
Nice To Haves
- Bachelor’s degree preferred, or equivalent work experience in Business Analytics.
- Master’s degree in a related field or related certifications are encouraged.
- Power BI or Tableau experience preferred; comparable data visualization systems and transferable skills are acceptable.
Responsibilities
- Develop and maintain action-based reports and dashboards using Power BI and SQL, and deliver monthly metrics to identify trends and opportunities.
- Collaborate with Data Engineering, Application Technology, business line managers, and other cross-functional teams to support data-driven initiatives and ensure data accuracy and validity.
- Provide analytical insights and recommendations for business initiatives, communicating findings through SQL queries, Power BI visuals, and DAX expressions.
- Work with teams to obtain necessary data and track performance on projects.
- Translate complex data into clear, actionable recommendations aligned with organizational goals, using DAX measures and SQL where appropriate.
- Gather, clean, and integrate data from sources such as data warehouses and spreadsheets to create centralized, accurate, accessible reporting.
- Convert strategic and operational inquiries into analytics requirements, extract and analyze data using SQL, and present insights in a clear narrative to inform decisions and drive action.
- Develop and maintain advanced Power BI reports, dashboards, and visualizations, incorporating drill-through features, bookmarks, tooltips, and parameterized filters.
- Develop SQL queries and DAX expressions for custom reports tailored to business-line needs.
- Participate in SQL code reviews to ensure best practices, query performance, and data integrity.
Benefits
- Competitive salary and a comprehensive benefits package.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
