BI Reporting Analyst at Roth Staffing Companies in Denver, Colorado

Job Description:

Location: Denver (local applicants only)



Type: Full-Time, Direct Hire



Schedule: Hybrid (4 days onsite)



Salary Range: $80k - $95k (depending on experience level)
Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US.

Please note that we cannot work C2C or with 3rd Party Vendors.


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:

• To understand business requirements in the BI context and design data models to convert raw data to meaningful insights


• To create dashboards and visual interactive reports using Power BI


• To identify KPIs with clear objectives and monitor them consistently


• To analyze data and present it through reports that can help in decision-making


• To be able to convert business requirements into technical specifications and decide the timeline to accomplish tasks


• To design, develop, and deploy Power BI scripts and perform efficient detailed analysis


• To perform DAX queries and functions in Power BI


• To create charts and document data with algorithms, parameters, models, and relations explanations


• To conduct data warehouse development


• To perform SQL querying for best results


• To define and design new systems by analyzing current ETL processes


• To make technical changes to existing BI systems in order to enhance their functioning

Education and/or Experience:

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


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


• 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 Ser Apply Now