Job Description
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 company's 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 company's values and guiding principles.
Responsibilities:
Carrying out the Company's 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.
Qualifications
Job Requirements/Minimum Qualifications:
Education: Bachelor's Degree or equivalent work experience
Course(s) of Study: Mathematics, Statistics, Computer Science, Data Analytics, or a related field.
Experience: 3-5 years
Type of Experience: Experience in data analysis and reporting.
Required Knowledge, Skills, and Abilities:
- Must be able to commit to Ruan's value statement by acting with integrity in everything we do.
- Must be able to meet behavioral expectations and perform in alignment with our guiding principles: safety, people, customer, performance, and continuous improvement.
- Demonstrate strong analytical and problem-solving abilities, with the ability to conduct in-depth data analysis and generate actionable insights independently.
- Proficient in SQL, data querying, and data visualization tools, such as Power BI. Advanced skills in data cleaning, transformation, and automation.
- Exhibit clear communication skills, both written and oral, and interpersonal skills with the ability to convey analytical findings to non-technical audiences and collaborate effectively with cross-functional teams.
- Maintain detailed and accurate documentation of methods and processes, ensuring clarity in all reports and records.
- Develop an intermediate understanding of the company's core services and how data analysis supports business operations.
- Show flexibility and adaptability in handling changing business needs and priorities, and in learning new tools and techniques to enhance data analysis capabilities.
Physical Demands of the Job:
Team member must be able to twist, bend, pull, push and lift up to 25 pounds. May work in excess of 8 hours per day, 40 hours per week, as required to perform essential functions. Team member will be required to stand, walk, sit, use fingers, reach with hands and arms, stoop, kneel, and crouch. Team member will present a neat, clean appearance of self, and use professional business etiquette and language. Must be able to operate office equipment; including telephone, copy/fax machine, personal computer, have reasonable accuracy and speed on ten key skills or/and keyboarding.
Environmental Demands of the Job:
Typical office environment
Reporting Relationships:
Reports To: Manager, IT or Director, IT
Direct Reports: None
Benefits:
Ruan provides benefits which include: Medical, Dental, Vision, Disability, Life, as well as 401k and Paid Time off.
