Business Intelligence Analyst

Job Description Will be responsible for the project from inception to end using Power BI, SSDT, SSRS, SSAS, MSSQL, Visual Studio, JIRA. Will design and develop interactive dashboards and analytical reports using Microsoft Power BI to support data-driven decision-making. Will collaborated with data modeling teams to build and enhance SQL Server Analysis Services (SSAS) Tabular models for optimized reporting and analytics. Will work extensively with relational databases, including Microsoft SQL Server, to extract, transform, and load data for reporting purposes and develop complex calculations using Data Analysis Expressions (DAX), including measures, calculated columns, and KPIs within Power BI and SSAS models. Will write and optimize T‑SQL queries, including views, stored procedures, CTEs, and functions, to improve data retrieval efficiency, overall system performance and create, maintain pixel‑perfect and parameterized reports using SQL Server Reporting Services (SSRS) with enhanced visualization features for improved user experience. Will monitor, maintain SQL Server Agent jobs, troubleshooting ETL failures and ensuring timely data pipeline execution and perform root cause analysis on ETL job failures and implement corrective actions to ensure data integrity and reliability. Will utilize Jira to gather business requirements, manage tasks, track progress across reporting and development cycles and engage with stakeholders to understand existing business processes and translate requirements into technical reporting solutions. Will review, enhance existing reports, identifying opportunities for performance improvements and better visualization techniques. Will deliver reports in multiple formats (PDF, Excel, Power BI Service) to meet diverse business needs and accessibility requirements. Will manage end-to-end report lifecycle including requirement gathering, development, testing, deployment, and maintenance. Will ensure data accuracy and consistency by validating data sources and implementing quality checks across reports and dashboards. Qualifications Master’s in computer science & technology with 12 months or Bachelor of Technology in Computer Science & Engineering with 60 months of experience as Software Engineer or Web Developer, BI Analyst will be considered in lieu of Master’s Degree, foreign equivalent accepted, 40 hrs. a week, Physical Demands Employee is regularly required to sit, use hands, handle controls, talk and hear, reach with hands and arms, stand, walk and stoop. Vision requirements include close vision and ability to focus Equal Opportunity We are committed to inclusion, diversity, and equal employment opportunity, regardless of race, color, ancestry, religion, sex, gender, national origin, sexual orientation, age, citizenship, marital status, disability, veteran status, or any other factor protected by applicable federal, state, or local laws. #J-18808-Ljbffr AECOM