Business & Data Analyst

Aqua Finance - Wisconsin, MN

Full-time - Mid Level

Wisconsin, MN

Credit Intermediation and Related Activities

About the position

The Business & Data Analyst is responsible for identifying data elements in IT delivery systems and processes to assist with gathering requirements for developing business intelligence reports. This role involves performing data analysis by developing and executing SQL queries, maintaining data dictionaries for changes in data fields and their use, and identifying IT data enhancement releases and updates that impact Aqua business intelligence reports.

Responsibilities

• Independently works and communicates with all levels of management and across multiple product lines to determine reporting/project requirements and to research/resolve technical issues with reporting tools and functionality.
• Collaborate with stakeholders to identify, gather, and document business requirements for reporting deliverables and processes.
• Document business and data requirements, functional reporting specifications, use cases, and process flows to communicate effectively with stakeholders and Reporting development teams to ensure accurate dashboards and reports are created and developed by business intelligence reporting teams.
• Utilizing data analysis techniques and tools analyze gathered data requirements to identify patterns, trends, and inconsistencies, ensuring that they align with business goals and objectives.
• Manage the Data Dictionary for Snowflake, including updating it with new fields as they are introduced from system projects.
• Identify business problems, challenges, and opportunities through data analysis in Snowflake and document, report in Jira tickets to propose innovative solutions or process improvements to address them.
• Collect, structure, interpret, and extract complex data into actionable insights through the use of SQL skills.

Requirements

• Bachelor's degree in Business or technical discipline, or commensurate work experience, required
• 3 years of Data Analysis, or related work experience, required
• Ability to use SQL skills to extract data from system application data tables
• Experience with SQL required
• Proficient in Microsoft Office Suite (Word, Excel, PowerPoint, Visio)
• Proficient in requirements management tools (e.g., JIRA, Share Point)
• Proficient in data analysis tools (e.g., SQL, Microsoft Sql Server Management Studio, Datadog, Snowflake)
• Attention to detail and accuracy required
• Excellent verbal and written communication skills required
• Ability to thrive in a fast-paced work environment.

Nice-to-haves

• Knowledge of Snowflake is preferred
• Financial industry experience preferred