Compensation RangeHourly: $30.55 - $46.40 (Amount based on relevant experience, skills, and competencies.)
About This JobThe main purpose of this job is to leverage various vended and internal data sets to deliver meaningful reporting, analysis, and data solutions for IT leadership and other customers of the IT Project Management Office in support of delivering business strategic objectives.
Job functions are approximately 80% report development/analysis, 20% other data solutions, and minimal consulting.
**Must be eligible to work in the US without sponsorship now or in the future
Essential Functions- Develop and maintain accurate recurring reporting with guidance from leadership
- Refresh, update, and investigate interactive visualization interfaces utilizing Planview/PowerBI/etc
- Design, develop and maintain interactive and visually pleasing PowerBI reports and dashboards with leadership guidance
- With guidance from leadership consult with our external Planview Enterprise partners and IT partners on data structure development, maintenance, troubleshooting and data transmission
- Meet deadlines with planning assistance from leadership
- Communicate and concisely present process results and methodology to manager and peers
- Adhere to department best practices and policies
- Perform other duties as assigned
Knowledge, Skills & Abilities Required- Basic understanding of relational databases
- Ability to effectively utilize data visualization software (SAP Business Objects/ PowerBI/Tableau)
- Basic SQL query development skills
- Basic understanding of Project Management & Agile methodologies
- Willingness to assist team on complex projects
- Motivated and organized self-starter with strong attention to detail and the ability to manage multiple priorities
- Inquisitive, agile, and strong team player with excellent written, verbal, and interpersonal communication skills
- Ability to remain adaptable and resilient to all situations with an optimistic outlook and cast a positive shadow that is aligned with our culture and Core Values
- Exposure to Planview Enterprise
- Exposure to various programing languages
- Basic knowledge of Microsoft Word, Excel, Outlook, SharePoint and Teams
Education & Experience- Bachelor's degree in Data Analytics, Information Systems, or similarly related field or equivalent combination of education and experience required
- 2+ years data analysis experience required
*Hybrid Schedule: In office 1 day per week
**Level of role is determined by knowledge, experience, skills, abilities, and education
***For individuals applying, assigned and/or hired to work in areas with pay transparency requirements, Commerce is required by law to include a reasonable estimate of the compensation range for some roles. This compensation range is for the IT Data Analyst I & II job and contemplates a wide range of factors that are considered in determining most appropriate job level and making compensation decisions, including but not limited to location, skill sets, education, relevant experience and training, licensure and certifications, and other business and organizational needs. The disclosed range estimate has not been adjusted for any applicable differentials (geographic, bilingual, or shift) that could be associated with the position or where it is filled. At Commerce, compensation decisions are dependent on the facts and circumstances of each situation. A reasonable estimate of the current base pay is $30.55 to $46.40 per hour.
#LI-CR1
The candidate selected for this position may be eligible for the following employment benefits: employer sponsored health, dental, and vision insurance, 401(k), life insurance, paid vacation, and paid personal time. In addition, we offer career development, education assistance, and voluntary supplemental benefits. Click here to learn more.
Location: 922 Walnut St, Kansas City, Missouri 64106
Time Type:
Full time