The KSOM Finance Department is seeking a SQL Business Intelligence/Web Developer to join its team.
This position will be responsible for:
Integration of data from multiple data sources on a regular basis.
Design and implement supporting database objects: fact & dimension tables, staging areas and data integration packages with validation plans for all stages
Design and implement changes to Microsoft Analysis services Tabular cube and reports with validation plans
Developing new user-facing features for reporting.
In collaboration with business partners, design and implement reports in Microsoft Sql Server Reporting Services, Power BI, Power Pivot and Excel, with corresponding validation plans.
Developing new user-facing features for data entry.
Design and implement supporting database objects
Optimization of applications for maximum speed, scalability and security
Successful Candidates Must Demonstrate:
5 years of Microsoft Sql Server design and architecture experience for data warehouse and data marts using Microsoft Sql Server, Analysis services (Tabular/Dax) and Integration services (SSIS)
5 years of Microsoft Sql Server programming for scalable and secure application and reporting support, including examination of query plans; designing and implementing appropriate indexing or partitions strategies for scalability; design and implementation of stored procedures, functions (UDFs), triggers, parsing of XML & JSON data structures; design, implementation and testing of application and object level security, row level filtering security
5 years of Microsoft Analysis Services (SSAS Tabular) design and architecture experience for reporting using star or snowflake schemas, slowly changing dimensions, normalized and denormalized dimensions.
5 years of reporting with Microsoft Reporting Services (SSRS) with DAX, Excel and Power BI
3 years of designing, implementing and maintaining Master data with Microsoft Master Data Services and appropriate EIM processes
Required Documents to Upload:
Minimum Education: Bachelor's degree, Combined work experience and education as equivalentMinimum Experience: 3 years, Combined education/experience as substitute for minimum experienceMinimum Field of Expertise: Sound knowledge of programming and documentation procedures, programming methods, program flow charts and operator instructions. Knowledge of one or more appropriate computer languages. Competent to work independently on complex programming activities.
Internal Number: REQ20076525
USC is the leading private research university in Los Angeles—a global center for arts, technology and international business. With more than 47,500 students, we are located primarily in Los Angeles but also in various US and global satellite locations. As the largest private employer in Los Angeles, responsible for $8 billion annually in economic activity in the region, we offer the opportunity to work in a dynamic and diverse environment, in careers that span a broad spectrum of talents and skills across a variety of academic and professional schools and administrative units. As a USC employee and member of the Trojan Family—the faculty, staff, students, and alumni who make USC a great place to work—you will enjoy excellent benefits, including a variety of well-being programs designed to help individuals achieve work-life balance.