What are the responsibilities and job description for the Analyst position at Ascendum Solutions?
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
Salary : $35 - $45
