Analyst

Ascendum Solutions

Ascendum Solutions

IT
Cincinnati, OH, USA
Posted on Apr 6, 2025

Analyst Position

12 month Contract position, potentially longer

Hybrid position, must be able to report to Downtown Cincinnati 2-3 days a week

No C2C's please

This position reports directly to the Senior Manager of Analytics and Asset Protection and is responsible for supporting reporting needs across multiple departments and levels of the organization. The ideal candidate will have hands-on experience developing Power BI reports from the ground up, utilizing a wide range of data sources including databases, Excel files, flat files, and both structured and unstructured data formats.

Key competencies for this role include advanced proficiency in DAX (Data Analysis Expressions), strong skills in Power Query, and the ability to establish robust data relationships within Power BI. The role also requires a solid command of SQL, with the ability to write complex queries involving joins, nested logic, and recursive statements. Onboarding will include a detailed overview of existing reporting frameworks and data integration workflows.

In addition to creating new reports, the candidate will be responsible for maintaining, improving, and automating existing Power BI dashboards to ensure timely and accurate data delivery.

Must-Have Skills and Experience (1–3 years):

  • Power BI: Ability to design reports from scratch and maintain/update existing reports
  • SQL: Proficiency in writing advanced queries with complex logic
  • Microsoft Excel: Strong working knowledge
  • R or Python: Experience with either language is acceptable
  • Statistical and Analytical Skills: Capable of interpreting and communicating data insights to various audiences
  • Database Knowledge: Ability to link data sources to ensure all metrics are readily accessible

Nice-to-Have Skills:

  • Python
  • Alteryx

Soft Skills:

  • Strong verbal and written communication: Comfortable interacting with team leads, executives, and cross-functional stakeholders
  • Collaborative mindset: Willing to support teammates and shift focus when needed
  • Initiative-driven: Thinks creatively and works independently with minimal direction

Key Responsibilities:

  • Automate existing reports and processes to enhance data accessibility
  • Collaborate with the Analytics and Asset Protection team to assess reporting needs and recommend improvements
  • Create and maintain data connections to ensure comprehensive and up-to-date metrics
  • Leverage available technologies to modernize and streamline reporting solutions