Business Intelligence Solutions Analyst 2 (Chandler, AZ, US, 85224)

<div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:14.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Summary:</b></H2> </div><div><div style="border:none;border-bottom:solid windowtext 1.0pt;padding:0.0in 0.0in 1.0pt 0.0in"> <p style="padding:0.0in;margin:0.0in 0.0in 8.0pt;line-height:107%;font-size:11.0pt;font-family:Calibri, sans-serif;border:medium none currentcolor">The Business Intelligence Solution Analyst is responsible for designing end<span style="font-family:&#39;Cambria Math&#39;, serif">‑</span>to<span style="font-family:&#39;Cambria Math&#39;, serif">‑</span>end, reporting<span style="font-family:&#39;Cambria Math&#39;, serif">‑</span>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.</p> </div></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:14.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Essential Functions:</b></H2> </div><div><ul style="margin-top:0.0in;margin-bottom:0.0in"> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Work directly with business stakeholders to translate business data needs into end-to-end data process flows and integration designs.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Convert business concepts (KPIs, metrics, rules, hierarchies) into scalable data architecture and integration patterns.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Balance business requirements with technical realities, articulating tradeoffs and recommendations clearly.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Design dimensional and analytical data models optimized for reporting performance and usability.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Define standards for facts, dimensions, grain, conformed dimensions, and aggregations.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Ensure semantic / reporting models align with underlying curated and warehouse models.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Ensure reporting data is delivered through governed, certified datasets rather than ad hoc or raw data access.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Perform source to target mapping for data integrations, including field level lineage, transformation logic, defaults, derivations, and exception handling.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Produce implementation ready technical specifications that engineering teams can execute with minimal ambiguity.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Define validation and reconciliation approaches (counts, totals, balancing, variance thresholds) to ensure data quality for reporting.</span></li> <li style="margin:0.0in 0.0in 0.0in 24.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Other duties as assigned.</span></li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:14.0px;word-wrap:break-word"><H2 style="font-size:1.0em;margin:0.0px"><b>Qualifications:</b></H2> </div><div><ul style="margin-top:0.0in;margin-bottom:0.0in"> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Bachelor’s degree in Data Analytics, Data Science, Computer Science, or related field.  May consider equivalent work experience in lieu of education.</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">5+ years of Business Intelligence or Data Analytic experience</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Advanced SQL skills for analysis, validation, and troubleshooting</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Experience designing business intelligence and analytics architecture with strong experience in ETL/ELT design and integration pipelines</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Experience with cloud data platforms and layered/medallion architecture concepts </span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Advanced knowledge in reporting-optimized data modeling and report development (Preferably with PowerBI)</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Experience integrating ERP data into analytic platforms (SAP S4HANA) preferred</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Experience modernizing or evolving legacy BI/DW environments to cloud platforms preferred</span></li> <li style="margin:0.0in 0.0in 0.0in 32.0px;line-height:normal;background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="font-size:11.0pt;line-height:107%;font-family:Calibri, sans-serif;color:black">Understanding of data governance, KPI standardization, and reporting certification practices preferred</span></li> </ul></div></div></div>