Business Intelligence Analyst

• Reviewing and redlining Pharma's data reporting contracts
• Assessing the feasibility of delivering data according to Pharma's contractual needs
• Collaborating with CVS Specialty & Retail Trade teams
• Creating and maintaining business requirements documentation
• Acting as the designated point of contact for Pharma and their third parties
• Leading data-related discussions and addressing data-related questions
• Reviewing and investigating data issues and concerns
• Partnering with external and internal teams to address data questions and issues
• Conducting root cause analysis of incoming data concerns
• Executing and modifying simple and moderately complex SQL queries
• Collaborating with the development team and Account Managers to analyze and collect meaningful metrics
• Tracking Pharma reporting projects/intake for successful delivery

Senior Pharmaceutical Reporting Analyst

• The Principal, IT Business Systems will be responsible for designing and delivering scalable, secure, and high-performing data and analytics solutions that enable informed decision-making across Finance and enterprise functions.
• This role blends data architecture, advanced analytics, and reporting with cross-functional support for all technology solutions managed by the Finance Business Applications team.
• This individual serves as a strategic partner and subject matter expert, translating business needs into technical solutions while ensuring consistent data definitions, security, governance and standards, optimized performance, and alignment across systems, tools, and stakeholders.
• Translate business and Finance requirements into technical solutions, data models, semantic layers, and reporting solutions.
• Serve as SME for data interpretation, ensuring consistent understanding of metrics across the organization.
• Present insights and recommendations and facilitate alignment when stakeholders have differing interpretations of data meaning.
• Validate that technical implementations accurately represent original business intent.
• Collaborate with Finance, HR, IT, and other business partners.
• Design enterprise Power BI semantic layer architecture, including data models, relationships, and calculation frameworks.
• Define standardized business logic, measures, and time intelligence patterns.
• Ensure alignment of calculations and metrics across multiple data sources and domains.
• Partner with data warehouse teams to support “analytics-ready” data structures.
• Design scalable solutions supporting multi-source data integration.
• Implement row-level security and data access controls across user groups.
• Optimize performance through aggregation strategies, DAX tuning, and query optimization.
• Ensure solutions meet enterprise standards for scalability, reliability, and performance.
• Provide data and analytics support across all Finance-owned technology solutions (e.g., ERP, planning tools, workforce systems, BI solutions).
• Partner with product owners and system leads to ensure reporting, data structures, and integrations support business needs.
• Identify opportunities to enhance tools, eliminate redundancies, and improve end-to-end data flows.
• Serve as a point of contact for Finance Business Applications solutions.
• Apply enterprise Power BI standards.
• Establish architectural patterns within enterprise framework.
• Document architectural decisions, trade-offs, and rationale.
• Validate implementations against architectural standards through design reviews.
• Document data definitions, architecture decisions, and solution designs.

Business Intelligence Architect

• Actively manage a team of data professionals to achieve strategic priorities and performance goals.
• Collaborate with key stakeholders to standardize, promote, and evangelize the responsible and ethical use of data needed to improve the firm's performance.
• Serve as a subject matter expert of our enterprise-class data warehouse and analytics solution.
• Leverage our data to support performance initiatives.
• Assist with the build, development, and maintenance of data models, reporting systems, data automation systems, dashboards, and performance metrics that support key business decisions.
• Support in driving data initiatives and efforts to improve firm-wide decision-making.
• Partner with the Information Security and Data Protection teams to implement controls, policies, and standards that meet organizational expectations while still complying with regulatory requirements.
• Present operational updates, issues, and proposals to directors and executive leadership on a regular basis.
• Help govern and support a culture that manages data as an enterprise asset.
• Cultivate, foster, and maintain positive working relationships with data-centric user and peer groups.
• Promote a culture of continuous improvement on the team.

Manager, Business Intelligence & Data Insights

• Partnered with a customer to scope and implement state-specific NIBRS compliance requirements within the Mark43 platform.
• Collaborated with agency stakeholders to identify reporting issues, recommend workflow improvements, and resolve data quality challenges.
• Analyzed incident and records data to validate compliance with state and federal reporting standards.
• Worked closely with cross-functional teams to address complex reporting scenarios and improve customer outcomes.
• Assisted customers in understanding NIBRS reporting requirements and provided guidance on best practices for maintaining compliance.
• Investigated data discrepancies, documented findings, and supported customers through corrective actions to ensure accurate reporting.

Compliance & Reporting Analyst – NIBRS

• Keep current with new accounting pronouncements and the impact on the company.
• Research accounting issues, identify applicable GAAP, and help prepare position papers.
• Prepare quarterly and year-end financial statements and assigned footnote disclosures in accordance with U.S. GAAP, statutory and SEC requirements.
• Complete assigned sections of the quarterly and annual GAAP disclosure checklist.
• Support the monthly ASC 842 leasing process and maintain the Company’s leasing software.
• Coordinate the annual audit process, including interim and year-end audit requests with the external auditors.
• Develop reports and analyze monthly flash results across all businesses using the Company’s OneStream consolidation system.
• Assist with preparation of quarterly and annual bank, board and/or statutory reporting requirements.
• Support the valuation process for goodwill, equity and/or business combinations as needed.
• Provide technical accounting support to business operations teams on projects and new initiatives.
• Maintain effective internal controls over financial reporting to ensure compliance with Sarbanes-Oxley and accurate reporting of financial position.
• Develop and update policies and procedures as needed.
• Other Duties as Assigned

Senior Financial Reporting Analyst

• Actively manage a team of data professionals to achieve strategic priorities and performance goals.
• Collaborate with key stakeholders to standardize, promote, and evangelize the responsible and ethical use of data needed to improve the firm's performance.
• Serve as a subject matter expert of our enterprise-class data warehouse and analytics solution.
• Leverage our data to support performance initiatives.
• Assist with the build, development, and maintenance of data models, reporting systems, data automation systems, dashboards, and performance metrics that support key business decisions.
• Drive data initiatives and efforts to improve firm-wide decision-making.
• Partner with the Information Security and Data Protection teams to implement controls, policies, and standards that meet organizational expectations while still complying with regulatory requirements.
• Present operational updates, issues, and proposals to directors and executive leadership on a regular basis.
• Help govern and support a culture that manages data as an enterprise asset.
• Cultivate, foster, and maintain positive working relationships with data-centric user and peer groups.
• Promote a culture of continuous improvement on the team.
• Prior experience managing a small team of onshore and near-shore developers.
• Experience managing projects in an agile environment.
• Hands-on development experience with Microsoft SQL Server, Azure SQL, Azure Synapse and Azure SQL.
• Managed Instances a plus.
• Deep understanding of Data Warehousing, Business Intelligence, Master Data Management, and Reporting.

Director – Business Intelligence, Data Insights

• Build Strategic Relationships: Develop and maintain strong relationships with key stakeholders across client organizations.
• Collaborate Cross-Functionally: Partner with internal teams to deliver integrated solutions and ensure client success.
• Utilize Sales Tools and Platforms: Leverage Circana’s proprietary platforms to support client engagements and solution delivery.
• Champion Client Success: Ensure client satisfaction by proactively addressing challenges, identifying growth opportunities, and delivering consistent value.
• Advanced Analytic Skills: Demonstrated ability to deliver fact-based analyses, providing clients with clear, actionable data observations.
• Maintain Industry Expertise: Stay current on retail trends to position Circana as a trusted advisor.
• Drive Client Growth: Identify and pursue opportunities to expand client relationships by aligning Circana’s solutions with their strategic goals.

Business Intelligence Analyst jobs in Ohio

See all jobs on JobTailor

Senior Pharmaceutical Reporting Analyst

Business Intelligence Architect

Manager, Business Intelligence & Data Insights

Compliance & Reporting Analyst – NIBRS

Senior Financial Reporting Analyst

Manager, Business Intelligence & Data Insights

Director – Business Intelligence, Data Insights

Business Insights Analyst