Job description

Company Description

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.

Job Description

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.

Qualifications

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

Required Skills/Experience

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