Job Summary
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
- Technical Skills : PowerBI, SQL, Power BI Report Builder/SSRS, Visualization Software, PowerApps
- The ideal candidate would have experience in developing and supporting visualization applications, and be aware on how to do build the data model in Power BI and have a very good understanding of Power query and DAX. Candidate should be able to do basic trouble-shooting and log analysis, root cause analysis, and coordination with multiple IT teams for support
- Power BI is the main application that the candidate will be developing and supporting, and the ability to work with the users to make change requests and potentially design dashboards is ideal
- Candidate with experience in building geomapping visualizations would be preferred
- Candidate should have intermediate experience building Paginated reports using Power BI Report Builder or prior experience in SSRS would be preferred
- Intermediate experience in building dashboards in Power BI embedded capacity or building BI solutions leveraging web technologies (JavaScript, Angular JS) would be plus
- Intermediate experience in Power Automate Platform
- Continue to maintain the existing PowerBI dashboards and to add new features and functionality as requested by the SA team and the business