Data Analyst - Iowa

This is a full-time position working on-site at Ruan Center located downtown Des Moines, IA

PowerBI and SQL experience is a must.

This position is responsible for collecting, analyzing, and interpreting data to transform it into valuable information that enhances data-informed, business decision-making. This role involves working with large datasets, developing complex reports and dashboards, and providing actionable insights to support the companys customers and operations. It collaborates with various business operations to support and improve operational efficiency. By leveraging advanced analytical techniques and tools, the position ensures data integrity and delivers meaningful insights that drive strategic initiatives. This role requires a commitment to learning and growing in analytical skills, while adhering to the companys values and guiding principles.

Responsibilities:

Carrying out the Companys organizational values and operating in accordance with applicable laws, regulations, and Company policies are required functions. Essential and other important responsibilities and duties may include, but are not limited to, the following:

• Data Collection and Transformation: Extract, clean, and transform data for complex analyses and large datasets. Automate repetitive tasks in data preparation, applying best practices in coding and documentation. Ensure data integrity and accuracy by maintaining databases and performing regular audits.
• Power BI Development: Build, develop, and maintain reports and dashboards, leveraging reporting tools to perform advanced data field transformations and to create sophisticated and streamlined data models. Provide meaningful insights to leadership and other stakeholders using data from a variety of sources to tell a compelling story for data-informed decision-making.
• Data Exploration and Analysis: Conduct in-depth analysis to uncover deeper insights and actionable recommendations for business units. Apply statistical techniques and advanced exploratory data analysis (EDA) to provide nuanced insights that answer key business questions to improve operations through descriptive and diagnostic analytics.
• Cross-Functional Collaboration: Work with operations teams to establish business needs and to develop and understand product specifications. Present insights and visualizations to stakeholders, explaining the methodology and business implications of findings. Develop awareness of and familiarity with issues and events affecting the organization, department, and/or customer. Collaborate closely with data engineering teams to communicate data requirements and address data quality issues.
• Report Presentation and Documentation: Present findings in a clear, concise format, preparing visualizations and summaries for stakeholder meetings. Document methods used and steps taken in analyses, maintaining organized records of data sources and transformations. Ensure accuracy and clarity in all reports and documentation.
• Database Applications: Use and support database applications and analytics tools. Assess data systems and programs.
• Continuous Improvement: Identify opportunities for process improvements and assist in implementing solutions. Research new data sources and analytical tools, exploring new data collection and analysis processes.
• Perform other job-related duties and special projects as required.