BI Reporting Analyst

Location: Denver (local applicants only)

Type: Full-Time, Direct Hire

Schedule: Onsite

Salary Range: $80k - $95k (depending on experience level)

The BI Reporting Analyst will turn raw data into meaningful insights that drive smart business decisions. Their typical day revolves around working closely with stakeholders to understand data needs, to uncover trends, to maintain data accuracy within BI systems, and to translate business requirements into technical specs. The BI Analyst will be working with data - connecting to various sources, cleaning and shaping the data to make it usable, and then creating compelling visualizations that tell a story.

Essential Job Functions:

• Translate business requirements into effective BI solutions by designing data models that transform raw data into actionable insights


• Develop and maintain interactive dashboards and reports in Power BI to support business decision-making


• Define and track key performance indicators (KPIs) aligned with organizational objectives, ensuring consistent monitoring and reporting


• Analyze complex datasets and present findings in a clear, meaningful format for stakeholders


• Convert business needs into technical specifications, including effort estimation and task timelines


• Design, develop, and deploy Power BI solutions, including advanced DAX queries and calculations for detailed analysis


• Create and document data visualizations, algorithms, parameters, and data models with clear explanations of relationships and logic


• Contribute to the design and development of data warehouses, ensuring optimized structures for reporting and analytics


• Write and optimize SQL queries to extract, manipulate, and analyze data efficiently


• Evaluate current ETL processes and propose improvements for scalability, reliability, and performance


• Enhance and maintain existing BI systems by implementing technical changes that improve functionality and performance

Education and/or Experience:

• At least 3 years' experience working with data management and analysis applications


• Bachelor's degree in computer science, business, or data science related field.


• Intermediate to advanced skills in Microsoft Excel, Power BI, Power Apps, and Power Automate.


• Excellent problem-solving, verbal and written communication, design development, and debugging skills.


• Ability to work independently using strong organizational skills and operate effectively in team settings using an agile software development approach.


• Maintain and support application(s) according to changing business/mission requirements.

Required Skills:

• Experience in SQL querying and scripting languages (DAX, MDX, etc.)


• Experience with data warehousing, data lakes, and data pipelines.


• Proficient in data visualization tools (e.g., Tableau, Power BI).


• Experience working with complex datasets, including both structured and unstructured data.


• Excellent communication and collaboration skills.


• Strong problem-solving and analytical skills to identify and solve data-driven problems.


• Ability to work independently and manage multiple projects simultaneously.

Benefits:

• Medical, Health Savings Account, Dental Insurance, Vision Insurance


• Flexible Spending & Dependent Care


• Life & Accidental Death & Dismemberment Insurance


• Short-Term Disability & Long-Term Disability


• Accident & Critical Illness Insurance


• Life Assistance Program 24/7


• Identity Theft Protection


• Money Coaching


• Will Preparation Services


• Travel Protection Services 24/7/365


• 401(k) - 3% employer match


• 10 holidays & 3 weeks PTO

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.