Entry-level BI Analyst resume example

• With a senior colleague reviewing the change, built SQL data modeling and ETL checks for a compliance reporting mart, separating event time from load time; reconciled control totals before publishing the dataset to dashboards.
• Within an assigned workstream, created QuickSight dashboards with row-level access and data visualization that exposed missing evidence; used Python checks to compare exported totals with the reporting mart after each refresh.
• With a senior colleague reviewing the change, published a Tableau revenue dashboard using the same SQL definitions as the finance reconciliation. Validated refunds, time zones, and late-arriving orders before release, giving finance and account teams a shared view without conflicting totals.
• Within the assigned scope, built a Power BI measure dictionary and reconciled DAX totals at detail and aggregate levels; tested row-level access with accounts representing different reporting teams.
• Within the assigned scope, owned a SQL data-model reconciliation using known reference totals, resolved inconsistent Tableau and QuickSight measures and completed a shared metric dictionary.
• Within the assigned scope, built Python ETL checks using data-quality assertions, reduced weekly dashboard reconciliation from 95 to 40 minutes and published the statistics validation notebook.

• The team trained 52 business users on governed self-service analysis and reviewed adoption; my scope was data preparation, quality checks, and follow-up documentation under senior review. The team kept the lower-effort process in place after handoff; documented my assigned work separately from the team result and confirmed it with a senior colleague.
• Within the assigned scope, investigated a discrepancy between a published metric and its source records, traced the transformation that changed the population, and corrected the calculation with a reproducible query.
• Within the assigned scope, compared the last successful data refresh with a failed run, separated missing source data from transformation errors, and reran only the affected interval. Kept the original query and corrected result together for review.

• Within the assigned scope, the team implemented freshness, reconciliation, and ownership checks for 31 executive metrics; my scope was data preparation, quality checks, and follow-up documentation under senior review
• Generated synthetic source records with duplicates, late arrivals and corrected values; wrote assertions for row counts and key uniqueness, and recorded the expected effect of each case on the reported metric.
• Compared the analytical output with a manually calculated reference table, traced differences to a transformation step, and retained a data dictionary and rerun instructions alongside the corrected query.
• Owned the synthetic-data validation using a manually calculated reference, resolved duplicate-key inflation and completed a notebook that reproduces the corrected totals.

Relevant coursework: Algorithms, operating systems, databases, computer networks

• Published an independent methods note using reproducible queries, explaining the data grain, excluded records and sensitivity of the result to a changed denominator.