Application Analyst Associate

• Please provide name and contact information for three professional references
• This is a full-time, on-site position
• This position is not eligible for work authorization sponsorship.

High school diploma or equivalent and 2 years of related experience

• Knowledge of SQL query development, design principles, and database querying techniques.
• Knowledge of PL/SQL programming concepts and development practices.
• Knowledge of Microsoft SQL Server Management Studio (SSMS) tools and functionality.
• Knowledge of T-SQL programming and stored procedure development methodologies.
• Knowledge of Oracle and Microsoft SQL Server database security concepts, standards, and best practices.
• Knowledge of Extract, Transform, and Load (ETL) processes and data integration principles that support accurate and efficient analytics.

1. Develop stored procedures and data pipelines to support daily refresh of data warehouse supporting Power BI reporting infrastructure
2. Develop semantic models optimized for reusability while supporting departmentally distinct data definitions as necessary
3. Populate and maintain data dictionary, acting as technical authority to support interdepartmental data governance processes
4. Directly support reporting needs with appropriate functional offices and users
5. Follow standard procedures, oversee technical development and testing of reports, dashboards, and procedures
6. Author and maintain documentation to ensure freshness
7. Support Functional and Technical personnel in fine-tuning current data models and reports, tuning for scalability and performance

1. Provide support for legacy reporting environments
   
   
   • Support the development, deployment, and administration of Argos reporting
   • Assist with tasks related to Operational Data Store (ODS)-based reporting
   
   
   
   
   
2. Assist in the implementation and support of Banner's ODS, including modifications to ETL processes and feeds from Banner to ODS.
3. Write SQL queries to extract required information to conduct data analysis, build and interpret predictive models, and troubleshoot issues
4. Compile data into meaningful data visualizations including dashboards, tables and graphs and present findings to team members, leadership and clients
5. Coordinate Change Management for assigned production changes and coordinate enhancement releases
6. Troubleshoot, manage, and support batch jobs and APIs used to support reporting processes
7. Manage monitoring facilities related to reporting processes

1. Manage monthly patching cycles
2. Apply security-related triggers to applicable users, system accounts, and processes
3. Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
4. Gather information as requested by management in support of internal and state audits.
5. Coordinate security-related modifications to database tables and attributes

1. Maintain custom database level roles for Banner, Operational Data Store, Microsoft Fabric workspaces and SQL servers. Revise access level for these roles as needed.
2. Apply security related triggers to applicable users, system accounts, and processes
3. Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
4. Gather information as requested by management in support of internal and state audits.
5. Coordinate security-related modifications to database tables and attributes