Sr Advanced Analytics Analyst

Lafayette, CO, US • Posted 6 days ago • Updated 3 hours ago
Full Time
On-site
USD $60.00 - 70.00 per hour
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Advanced Analytics
  • Business Process
  • Data Management
  • Decision-making
  • Star Schema
  • Microsoft Excel
  • Database
  • Data Entry
  • Data Quality
  • Accessibility
  • Documentation
  • Version Control
  • Data Modeling
  • Microsoft Power BI
  • Dashboard
  • Semantics
  • KPI
  • SQL
  • Snow Flake Schema
  • Git
  • Communication
  • Collaboration
  • Sprint
  • Attention To Detail
  • FOCUS
  • Continuous Improvement
  • Medical Devices
  • Analytics
  • Business Data
  • Reporting
  • Publishing
  • Design Patterns
  • Performance Tuning
  • Optimization
  • DAX
  • Microsoft SharePoint
  • Workflow
  • Conflict Resolution
  • Problem Solving
  • Artificial Intelligence
  • Job Boards

Summary

Join a dynamic analytics team supporting a highly collaborative environment where your Power BI expertise will help improve visibility, decision-making, and operational execution across important business processes. This role combines advanced dashboard development, semantic model design, and practical data management solutions to create reliable, scalable reporting tools that make a real impact.
Responsibilities
  • Design and deliver clear, intuitive Power BI dashboards and reports that tell a compelling data story for business stakeholders.
  • Translate business questions and KPI definitions into effective visualizations, drill paths, filters, and tooltips that support quick decision-making.
  • Build and maintain reusable semantic models using dimensional and star schema best practices.
  • Develop practical business-facing data solutions such as SharePoint Lists, structured Excel tools, lightweight databases, and Power Platform-based workflows.
  • Create and maintain data-entry, validation, reconciliation, and exception-handling processes that improve data quality and traceability.
  • Write and optimize DAX measures and Power Query transformations using repeatable, maintainable patterns.
  • Apply reporting standards for consistency, accessibility, naming, and documentation across analytics assets.
  • Troubleshoot and improve report performance, including refresh timing, query responsiveness, and model size.
  • Partner with subject matter experts and end users to prototype, validate, and refine analytics solutions.
  • Use version control and peer review practices to support collaborative development and reliable delivery.
  • Support analytics delivery with adjacent tools such as SQL, Snowflake, Git, Power Automate, and Power Apps as needed.
  • Work independently on moderately complex assignments while helping maintain intake, prioritization, sprint planning, and backlog hygiene.
Skills
  • Bachelor's degree with 4+ years of related experience, or a master's degree with 2+ years of related experience.
  • At least 2 years of experience in data modeling and Power BI development.
  • Strong working knowledge of Power BI, including dashboard creation, semantic models, and KPI reporting.
  • Experience using DAX and Power Query to build maintainable reporting solutions.
  • Familiarity with SQL, Snowflake, Git, and branching workflows.
  • Ability to work independently with sound judgment and organize ambiguous work into actionable plans.
  • Strong communication and collaboration skills, with the ability to partner effectively across teams and with stakeholders.
  • Comfort working in a backlog or sprint-based environment and participating in peer review processes.
  • Detail-oriented mindset with a focus on accuracy, consistency, and continuous improvement.
Preferred Skills
  • Experience working in a regulated or medical device environment.
  • Experience translating business needs into analytics deliverables while setting expectations around assumptions, tradeoffs, and timelines.
  • Background creating and maintaining business-managed data solutions with documented controls and governance practices.
  • Exposure to data ownership, validation checks, reconciliation steps, and user guidance for business data processes.
  • Knowledge of report publishing, refresh monitoring, and troubleshooting practices.
  • Understanding of row-level security concepts and secure design patterns.
  • Experience with performance tuning, including model optimization and DAX improvements.
  • Working knowledge of Power Automate, Power Apps, and SharePoint Lists for data capture and workflow support.
  • Ability to adapt quickly to changing priorities, tools, and requirements.
  • Excellent interpersonal skills and a collaborative approach to problem-solving.

Horizontal is committed to fostering an inclusive, equitable, and welcoming environment where different perspectives are valued and everyone has the opportunity to contribute and succeed. We encourage candidates from all backgrounds to apply and bring their unique experiences to the team.

By applying for this position, you acknowledge and agree that Horizontal Talent may contact you regarding your application using automated technology, including phone calls, SMS/text messages, or email, which may be delivered by our virtual AI recruiter, Alex.

Please apply through this online posting or by visiting our Job Board at Applications will be accepted for 4 weeks. For those that join the team, we offer competitive compensation and benefits including medical, dental, vision, and retirement. Check out all we have to offer and how you can become part of the Horizontal Talent Team. The pay range for this role is $60 - $70 per hour based on qualifications and experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10123528
  • Position Id: 76386
  • Posted 6 days ago

Company Info

About Horizontal Talent

Horizontal Integration offers two service lines. Our staffing agency places IT, digital and creative talent in both contract and permanent roles. Our digital agency provides digital marketing strategy and technology consulting on a project basis. Many of our clients take advantage of both service lines.

We are a certified Minority Business Enterprise, with more than 200 employees across our offices in Minneapolis, Denver, Dallas and Vadodara, India. We ve been consistently growing and profitable since the company was founded in 2003.

Honors:
Recognized as a "2009 Best Place to Work" by Minneapolis/St.Paul Business Journal.

Fact:
Our people and our organization are deeply rooted in IT and interactive marketing.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact us. All applicants applying must be legally authorized to work in the country of employment.

About_Company_OneAbout_Company_Two
Contact the job poster
SS

Sonu Singh

Recruiter @ Horizontal Talent

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.