AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.

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.

• 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

• 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 users
• Ability to clearly communicate across multiple teams, and the ability to communicate and escalate major issues when appropriate
• Ability to perform the tasks in Power BI with minimal assistance
• Candidate should be willing to explore & research new tools and technologies based on the guidance from SA team

Technical Skills               Proficiency Level             Required (R) /Optional (O)

SQL                                                  3                                              R

Power BI                                           3                                              R

Power BI Report Builder/SSRS        2                                              R

PowerApps                                       2                                              O

Microsoft Flow                                  2                                              O

 Visualization Software                     3                                              R

Excel VBA Scripting                          2                                              O

R/Python                                           1                                              O

JavaScript/ Angular JavaScript         2                                              O

• BS in Computer Science, Information Technology degree, Data Analytics or equivalent