Business Intelligence Analyst-Intermediate II

Aculocity:
Join the dynamic and fast‑paced world of Aculocity, a global technology consulting company dedicated to revolutionizing business processes through cutting‑edge technology solutions. Since our formal inception in 2006 (and informal in 1999), we've been at the forefront of delivering tailor‑made software development solutions, seamless software system implementations, powerful business intelligence, and innovative business process solutions. As a proud member of the GVW Group, LLC portfolio of companies, we are a premier provider of technology services for GVW’s extensive portfolio and a rapidly growing external client base.

Join a team that is driving innovation and transforming businesses worldwide. Elevate your career with us at Aculocity.

The Business Intelligence (BI) Analyst (Intermediate II) supports the delivery of enterprise BI solutions, ensuring dashboards, reports, and analytical outputs are accurate, timely, and aligned with established standards. This role is responsible for designing and standardizing core BI components, including source‑to‑target mappings, semantic data models, and business measures, ensuring consistency and alignment between business definitions and technical implementation. Operating with a high degree of independence, this role owns defined initiatives and engages directly with stakeholders to gather requirements, deliver solutions, and communicate insights.

The BI Analyst is accountable for high‑quality data analysis, solution design, and delivery, leveraging strong expertise in SQL, BI tools, and data modeling to build scalable and reliable reporting solutions. This position contributes to BI work streams supporting the Microsoft Fabric platform strategy, ensuring alignment with defined architecture, standards, and governance practices.

• Collect, aggregate, and analyze data from multiple internal and external sources to generate actionable insights.
• Translate business requirements into technical specifications, including data mappings, model structures, and reporting outputs.
• Support user acceptance testing (UAT) and ensure release readiness for assigned deliverables.
• Own delivery of assigned BI initiatives, dashboards, and paginated reports in alignment with business priorities and required timelines.
• Complete all defined standard work items, including documentation, testing validation, deployment checklists, and release procedures.
• Respond to ad‑hoc reporting requests while maintaining prioritization discipline.
• Support migration of legacy reports to Fabric work spaces.
• Manage end‑to‑end delivery of assigned data projects, coordinating activities across stakeholders, data engineering, data science & AI and BI Development teams to ensure timely and high‑quality execution.

• Design and maintain Source‑to‑Target Mappings, defining how data moves from source systems into curated models, ensuring traceability and alignment with business requirements.
• Ensure data lineage, transformation rules, and assumptions are clearly documented and maintained. Translate business processes and requirements into scalable dimensional data models (facts & dimensions) aligned with enterprise standards.
• Define and coordinate implementation of semantic layer structures within Power BI / Fabric to support consistent and reusable reporting.
• Collaborate with data engineering and BI development teams to ensure data pipelines align with defined mappings and business logic.
• Support the integration of AI‑driven features within BI solutions, ensuring alignment with enterprise data standards and governance.

• Collaborate with business stakeholders to gather requirements, validate outputs, and ensure alignment with business needs.
• Communicate analytical findings clearly and provide data‑driven recommendations to support decision‑making.
• Educate and train users on reporting tools and semantic models to drive adoption of the Momentum platform.

• Ensure BI solutions meet established standards for data quality, usability, documentation, naming conventions, governance, and…