Sign upLog in
See more jobs

Sr BI Report Developer (AI-Accelerated Analytics Engineering)

Prosum
  • Glendale, CA
  • $90.60 Per Hour
  • Quick Apply
30+ days ago

Job Description


Senior BI Report Developer – Analytics Engineering
Location: Glendale, CA (Hybrid – onsite 2–3 days per week)
Pay Rate: $90.60/hour 

Position Overview

We are seeking an experienced Senior BI Report Developer to lead the design, development, and modernization of enterprise reporting solutions. This role is responsible for delivering executive and operational dashboards, maintaining governed semantic models, and developing analytical reporting solutions that support strategic business decisions.

The ideal candidate combines strong SQL expertise with hands-on BI reporting experience and has experience leveraging AI-assisted development tools to improve productivity and accelerate dashboard modernization initiatives.

Key Responsibilities
  • Design, develop, and maintain enterprise dashboards and reporting solutions.
  • Translate business requirements into scalable, maintainable reporting assets aligned with established data governance standards.
  • Develop and manage semantic layers, including metrics, attributes, hierarchies, prompts, and security models.
  • Write, optimize, and troubleshoot complex SQL queries across enterprise data platforms.
  • Collaborate with data engineering teams to create curated datasets, aggregation tables, and performance-optimized reporting structures.
  • Perform data validation, profiling, and reconciliation activities to ensure reporting accuracy.
  • Support the design and implementation of dimensional data models, including fact and dimension tables.
  • Lead efforts to modernize legacy reporting solutions into contemporary web-based dashboard experiences.
  • Utilize approved AI coding and productivity tools to assist with SQL development, documentation, validation, and reporting workflows while maintaining appropriate human oversight and quality standards.
  • Conduct testing and validation activities to ensure reporting functionality, security, and metric consistency.
  • Mentor team members on reporting best practices, governance principles, and effective use of AI-assisted development techniques.

Required Qualifications

Business Intelligence & Reporting
  • 8+ years of experience developing enterprise BI reports and dashboards.
  • Demonstrated experience delivering reporting solutions from requirements gathering through deployment and support.
  • Strong understanding of governed metrics, semantic modeling, and enterprise reporting standards.

SQL & Data Engineering
  • Advanced SQL development experience with the ability to write and optimize complex queries.
  • Experience with:
    • Multi-table joins
    • Common Table Expressions (CTEs)
    • Recursive queries
    • Stored procedures
    • Dynamic SQL
    • Data profiling and reconciliation
    • Query performance tuning and optimization
  • Experience working with modern data platforms such as SQL Server, Snowflake, Databricks SQL, PostgreSQL, or similar technologies.

Data Warehousing
  • Strong understanding of dimensional modeling concepts, including:
    • Star and snowflake schemas
    • Fact and dimension table design
    • Slowly Changing Dimensions (SCDs)
    • Conformed dimensions
  • Experience supporting reporting solutions within modern data warehouse architectures.

AI-Assisted Development
  • Professional experience utilizing AI-enabled development tools to support coding, documentation, validation, or analytics workflows.
  • Understanding of AI limitations and the importance of human validation in production environments.

Required Technical Skills
  • SQL
  • Python
  • Experience working with AI-assisted coding tools

Preferred Qualifications
  • Experience with enterprise BI platforms such as MicroStrategy.
  • Experience with additional reporting tools, including Tableau or Power BI.
  • Knowledge of modern web technologies used in analytics applications (e.g., React or similar frameworks).
  • Experience with financial or regulatory reporting environments.
  • Familiarity with ETL/ELT processes and cloud-based analytics platforms.
  • Experience working within Agile/Scrum environments.
  • Prior experience mentoring analysts, developers, or other team members.

Desired Attributes
  • Strong analytical and problem-solving abilities.
  • High attention to detail and commitment to data accuracy.
  • Ability to evaluate metric definitions, data lineage, and reporting requirements critically.
  • Collaborative mindset with a focus on knowledge sharing and continuous improvement.
  • Ability to balance innovation with governance and quality standards.

Education
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field (or equivalent practical experience).

Numbers & Facts

LocationGlendale, CA

Skills

  • Agile Programming Methodologiesunmatched
  • Analysis Skillsunmatched
  • Artificial Intelligence (AI)unmatched
  • Best Practicesunmatched
  • Business Intelligenceunmatched
  • Business Supportunmatched
  • Cloud Computingunmatched
  • Computer Scienceunmatched
  • Continuous Improvementunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Profilingunmatched
  • Data Qualityunmatched
  • Data Setsunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Detail Orientedunmatched
  • Dimensional Modelingunmatched
  • Financial Regulationsunmatched
  • Financial Reportingunmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • Internet Technologyunmatched
  • Mentoringunmatched
  • Metricsunmatched
  • MicroStrategyunmatched
  • Microsoft SQL Serverunmatched
  • Multiplatform/Cross-Platformunmatched
  • Performance Analysisunmatched
  • Performance Tuning/Optimizationunmatched
  • PostgreSQLunmatched
  • Power BIunmatched
  • Problem Solving Skillsunmatched
  • Production Systemsunmatched
  • Productivity Managementunmatched
  • Programming Toolsunmatched
  • Python Programming/Scripting Languageunmatched
  • Quality Metricsunmatched
  • Query Optimizationunmatched
  • React.jsunmatched
  • Reconciliationunmatched
  • Regulatory Reportsunmatched
  • Reporting Dashboardsunmatched
  • Reporting Skillsunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Scrum Project Management and Software Developmentunmatched
  • Snowflake Schemaunmatched
  • Star Schemaunmatched
  • Stored Proceduresunmatched
  • Support Documentationunmatched
  • Tableauunmatched
  • Team Playerunmatched
  • Validation Documentationunmatched
  • Validation Testingunmatched
  • Workflow Analysisunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder