BI Data Analyst

• Education or certification requirements: Associates Degree and/or related
• Manager is targeting candidates with approximately 1-3 years of relevant experience who are eager to learn, can work independently, and demonstrate a strong self-starter mentality.
• Strong SQL experience is required. Candidates should be comfortable writing complex queries, including multi-table JOINs (INNER/LEFT), aggregations (COUNT, SUM, GROUP BY), WHERE clauses, and CASE statements.
• Candidate will be responsible for building and maintaining dashboards and reporting for customer data.
• Candidates should have a solid understanding of data modeling, relationships, measures vs. calculated fields, and be comfortable working with Import and/or DirectQuery modes.
• Strong analytical and investigative skills are required. Candidates should be able to identify data issues independently, troubleshoot root causes, and clearly communicate findings.
• Python experience is highly preferred. Candidates should be comfortable creating basic scripts to manipulate, analyze, and work with large datasets.

MUST HAVE technologies:

• Must have PowerBI (preferred) or Tableau Experience
• Proficiency in using computer applications such as Microsoft Office Suite (Excel, Word, PowerPoint)
• SQL (strong SELECT statements, Multi-table JOINs (INNER, LEFT), Aggregations(COUNT,SUM,GROUP BY, etc)
• Proficiency in using computer applications such as Microsoft Office Suite (Excel, Word, PowerPoint)

MUST HAVE Critical Skills:

1. Data Analysis & Research- Ability to research, analyze, and interpret data to support business needs.

2. Advanced SQL Troubleshooting * Read and understand existing SQL code. * Investigate data discrepancies, missing records, and validation issues. * Reconcile record counts across joins and datasets.

3. Dashboard Development & Reporting - Build and maintain Power BI/Tableau dashboards. Translate business requirements into meaningful visualizations.

4. Problem Solving & Investigative Skills- Able to independently identify root causes of data issues and explain findings.

Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally: as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with a service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.

Amerit Consulting 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.

Applicants with criminal histories are considered in a manner that is consistent with local, state and federal laws.