Professional Resume Template for
BI Analyst
Deandre J. Lawson
Atlanta, GA
(404) 555-0143
deandre.lawson@email.com
linkedin.com/in/deandre-lawson | github.com/deandrelawson
Professional Summary
Methodical Business Intelligence Analyst with 6 years of experience designing and deploying interactive data visualization and warehousing solutions for financial services and logistics industries. Expertise includes SQL database optimization, ETL pipeline development using dbt, and enterprise-wide Tableau and Power BI deployment. Successfully constructed unified financial dashboards that consolidated data from 4 disparate ERP systems, reducing monthly reporting cycle times by 32% and identifying $140,000 in annual operational cost savings. Proficient in Snowflake, PostgreSQL, Python, dbt, Tableau, and Power BI.
Work Experience
Business Intelligence Analyst — Novus Financial Group
Atlanta, GA | June 2023 – Present
- Designed and optimized 14 executive-level Tableau dashboards tracking regional revenue KPIs, improving page load speeds by 43% and enabling self-service analytics for over 150 business stakeholders.
- Developed and scheduled 8 automated ETL pipelines using Python and dbt in Snowflake, reducing manual data preparation tasks by 14 hours per week and lowering data discrepancy errors by 28%.
- Conducted SQL cohort analysis on 45,000 active customer records to identify churn patterns, providing critical insights that helped marketing teams improve retention rates by 12% over 6 months.
- Partnered with database administrators to redesign the corporate metadata registry, ensuring compliance with SOC 2 policies and reducing user data access provisioning times from 5 days to 24 hours.
Junior Business Intelligence Analyst — Vanguard Logistics Partners
Atlanta, GA | June 2020 – May 2023
- Automated 25 weekly operational logistics reports using Power BI and SQL Server Agent, saving supply chain managers 10 hours of manual spreadsheet assembly per week and eliminating manual entry errors.
- Wrote and tuned complex SQL queries and views across 5 schema tables containing 1.2M shipping entries, improving data retrieval efficiency by 34% and accelerating runtimes of critical reports.
- Trained 40 cross-functional logistics coordinators on basic SQL querying and Power BI dashboard navigation, reducing ad-hoc data extraction requests to the IT team by 25% over a 12-month period.
- Executed data profiling and data cleaning scripts on incoming vendor shipping data using Excel and SQL, resolving 95% of address formatting inconsistencies and saving 8 weekly processing hours.
Education
Bachelor of Science in Management Information Systems
Georgia State University · Atlanta, GA · 2020
Skills
SQL (PostgreSQL, SQL Server), Snowflake, dbt, Python, Excel, Power BI, Tableau, ETL pipeline development, Data warehousing, Data modeling, KPI dashboarding, Stakeholder communication, SOC 2 compliance
Projects
Enterprise ERP Dashboard Consolidation
Role: Lead Business Intelligence Analyst
Tools: Tableau, SQL Server, Python, Git
Consolidated financial data from 4 distinct ERP systems into a unified executive dashboard, saving 20 reporting hours per month and identifying $140,000 in logistics cost discrepancies.
Data Warehouse Migration Initiative
Role: Business Intelligence Analyst
Tools: Snowflake, dbt, PostgreSQL, Fivetran
Led the migration of historical sales tables containing 5M rows to Snowflake, reducing dashboard latency by 35% and saving $12,000 in annual database hosting expenses.
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (2024)
- Certified Business Intelligence Professional (CBIP) (2023)
Additional information
- Languages: English (Native), Spanish (Basic)
- Volunteer Work: Data mentor for local youth coding bootcamp initiatives (2022-present)
- Availability: 2 weeks notice
Job Market Insights
Market data and opportunities for
BI Analyst
Job Market Insights
$75,000
-
$115,000
Avg:
$95,000
Growth Outlook:
The demand for Business Intelligence Analysts in the United States is projected to remain highly robust, driven by the expanding need for data-driven corporate decision-making across all sectors. As artificial intelligence and machine learning tools automate basic data cleansing and query writing, BI Analysts are expected to pivot toward strategic stakeholder consulting and predictive business forecasting. Job opportunities within the broader computer and mathematical occupations group are forecasted to grow by 10% over the next decade, with tech and finance leading hiring efforts.
10% growth over 10 years (2024-2034)
Key Skills Required
Focus on these skills when customizing your resume for recruiter screenings.
Search Jobs
Explore live openings for
BI Analyst
roles and tailor your resume to match the market demand.
Search
BI Analyst
FAQ
Common questions about the
BI Analyst
position