Strategic Analytics is a new, growing team at Arch. The team develops innovative predictive models and analytical tools to improve profitability and growth. This position will help support the technical needs of the Strategic Analytics team. The focus of the position is to create and support dashboards developed in Microsoft Power BI, R/Python, and other visualization software that will assist the business in uncovering actionable insights. As a key member of the team, you will work closely with business users, data engineers, and data scientists to provide customized visualizations that facilitate an interactive and user-friendly experience.
Job Responsibilities
- Develop dashboards from a wireframe in Microsoft Power BI
- Understand the data and build complex data models in the visualization tool sufficing reporting needs
- Develop SQL Scripts as needed to pull the data from various sources (SQL Server, Azure SQL Server, Snowflake) and transform as needed for reporting
- Develop pixel perfect reports where appropriate
- Build & support applications in Power Apps and integrate it with Power BI
- Automation of various manual tasks
- Research marketplace visuals and R/Python visuals to create new dashboard enhancements
- Microsoft Power BI regression testing
- User Maintenance - adding new users and removing ones from the system. Keeping track and re-assigning licenses as needed
- PowerBI log analysis
- Ability to troubleshoot and maintain existing VBA scripts
- Monitor email outputs from existing scripts and escalate as needed
