BI Analyst

Job DescriptionJob Description

Summary: Seeking a BI Analyst to collaborate with business units in delivering BI solutions and ad hoc analysis that support and track the decisions of the business. You’ll work closely with stakeholders to translate business requirements into actionable dashboards, reports and visualizations. Using tools like SQL, Power BI, Excel, and Python, you’ll provide insights that drive informed decision-making and highlight key trends and opportunities for the business.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

 

·       Collaborate with business units to gather technical requirements and deliver tailored BI solutions.

·       Design and develop actionable dashboards, scorecards, reports and data visualizations using Power BI, Excel, Python, and other BI platforms.

·       Conduct routine and ad hoc analysis to support strategic business decisions.

·       Build, refine, and optimize datasets in Power BI, incorporating complex DAX calculations and KPIs.

·       Ensure consistency in business logic and KPI definitions across all BI solutions.

·       Maintain metadata and custom mappings used in reporting and analysis.

·       Evaluate existing BI solutions, looking for opportunities to improve them.

·       Maintain comprehensive data dictionaries, documentation, and source control for all BI processes and solutions.

·       Work closely with the Data Operations team to develop and document data warehouse collections and datasets needed for BI solutions.

·       Analyze and understand source system data for validity and completeness, troubleshooting basic data integrity issues and documenting findings.

·       Implement robust data monitoring practices to maintain high data quality, proactively addressing and resolving any data discrepancies.

 

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

Education/Experience:

 

·       Bachelor's degree in Business Analytics, Data Science, Computer Science or another analytically focused field (Master’s degree is a strong plus).

·       3-5 years of experience as a BI analyst or similar analytical role, with a proven track record of supporting strategic business decisions through data analysis and BI solutions.

·       Advanced proficiency in SQL, with expertise in writing complex and optimized T-SQL queries for data extraction, transformation, and analysis.

·       Expertise in Power BI for building impactful dashboards, reports, and visualizations, with proficiency in writing complex DAX calculations.

·       Extensive experience with Excel for data modeling and analysis, including advanced functions such as Power Query, DAX, XLOOKUP, cube functions, etc.

·       Proficiency in using Python for data analysis and enhanced visualization. Experience with web scraping or dashboarding capabilities a plus.

·       Thorough understanding of dimensional data modeling (star schema).

·       Strong understanding of data governance principles, ensuring consistent business logic & KPI definitions across BI solutions.

·       Proven ability to identify opportunities to enhance BI solutions, applying strong analytical and problem-solving skills.

·       Excellent communication skills, with the ability to convey complex data insights clearly to both technical and non-technical audiences.

 

Certificates, Licenses, Registrations:

None

 

 

Company DescriptionStaffSource is committed to creating long-term partnerships where we can truly affect both clients’ and candidates’ lives for the better. Our success is rooted in matching talented professionals with environments that suit their goals, personalities, lifestyles, and skills. A perfect placement allows candidates to thrive in their new role and hiring managers to fill their openings with top talent that aligns with both the needs of their team and the company’s culture.

Founded in 2003, StaffSource now has a 20+ year company history with business units operating within Information Technology, Accounting and Finance, Sales, Executive Search and more. Still headquartered in Knoxville, TN and lead by our founder John Sharpe, we are now serving clients and candidates all across the United States. We conduct national, regional, and localized talent searches based on the specific needs of each client and the unique goals of top talent everywhere.Company DescriptionStaffSource is committed to creating long-term partnerships where we can truly affect both clients’ and candidates’ lives for the better. Our success is rooted in matching talented professionals with environments that suit their goals, personalities, lifestyles, and skills. A perfect placement allows candidates to thrive in their new role and hiring managers to fill their openings with top talent that aligns with both the needs of their team and the company’s culture.\r
\r
Founded in 2003, StaffSource now has a 20+ year company history with business units operating within Information Technology, Accounting and Finance, Sales, Executive Search and more. Still headquartered in Knoxville, TN and lead by our founder John Sharpe, we are now serving clients and candidates all across the United States. We conduct national, regional, and localized talent searches based on the specific needs of each client and the unique goals of top talent everywhere.

---