Analysis Skills, Business Intelligence, Business Solutions, Cloud Computing, Computer Science, Data Analysis, Data Mapping, Data Modeling, Data Quality, Data Science, Data Sets, Database Extract Transform and Load (ETL), Design Flows, ERP (Enterprise Resource Planning), Enterprise Data Integration, Error Handling, Identify Issues, Information Technology & Information Systems, Metrics, Performance Analysis, Performance Metrics, Performance Tuning/Optimization, Power BI, Process Flow, Reconciliation, Requirements Management, SAP, SQL (Structured Query Language), Standards Development, Systems Scalability, Technical/Engineering Design, Usability Engineering, Warehousing, Willing to Travel
Business Intelligence Solutions Analyst 2
Location: Chandler, AZ, US, 85224 Job Category: Information Technology Shift: Shift 1 Full Time / Part Time: Full-Time Job Level: Individual Contributor Approximate Travel: 0%
Summary: The Business Intelligence Solution Analyst is responsible for designing end-to-end, reporting-ready data solutions that integrate data from multiple enterprise systems into trusted scalable models. This role partners closely with business stakeholders, data engineering, and BI teams, ensuring business requirements are translated into technical design specifications for integration pipelines, and governed reporting layers.
Essential Functions:
- Work directly with business stakeholders to translate business data needs into end-to-end data process flows and integration designs.
- Convert business concepts (KPIs, metrics, rules, hierarchies) into scalable data architecture and integration patterns.
- Balance business requirements with technical realities, articulating tradeoffs and recommendations clearly.
- Design dimensional and analytical data models optimized for reporting performance and usability.
- Define standards for facts, dimensions, grain, conformed dimensions, and aggregations.
- Ensure semantic/reporting models align with underlying curated and warehouse models.
- Ensure reporting data is delivered through governed, certified datasets rather than ad hoc or raw data access.
- Perform source to target mapping for data integrations, including field level lineage, transformation logic, defaults, derivations, and exception handling.
- Produce implementation ready technical specifications that engineering teams can execute with minimal ambiguity.
- Define validation and reconciliation approaches (counts, totals, balancing, variance thresholds) to ensure data quality for reporting.
- Other duties as assigned.
Qualifications: Bachelor's degree in Data Analytics, Data Science, Computer Science, or related field. May consider equivalent work experience in lieu of education. 5+ years of Business Intelligence or Data Analytic experience Advanced SQL skills for analysis, validation, and troubleshooting Experience designing business intelligence and analytics architecture with strong experience in ETL/ELT design and integration pipelines Experience with cloud data platforms and layered/medallion architecture concepts Advanced knowledge in reporting-optimized data modeling and report development (Preferably with PowerBI) Experience integrating ERP data into analytic platforms (SAP S4HANA) preferred Experience modernizing or evolving legacy BI/DW environments to cloud platforms preferred Understanding of data governance, KPI standardization, and reporting certification practices preferred
No additional requirement needed