Business Intelligence Developer III
About The Position
The Business Intelligence/Analytics Engineer 3 is a specialized mid-level technical professional who exercises independent judgment to architect, engineer, and govern the enterprise "Semantic Layer." Unlike a report builder, this role acts as a "Logic Architect," designing the reusable data models, security frameworks, and metric definitions that serve as the Single Source of Truth for the organization. This position is a key independent contributor and member of the System Data & Analytics team in Digital. The Analytics Engineer 3 is responsible for the full lifecycle engineering of the department's semantic infrastructure. This role requires the exercise of discretion to determine the appropriate modeling strategy—choosing between Import, DirectQuery, or Direct Lake modes—to balance performance with data freshness. The ideal candidate moves fluidly between managing legacy SSAS partitions and architecting modern Microsoft Fabric semantic models using engineering tools like Tabular Editor and ALM Toolkit. This role operates with minimal oversight, defining the governance and security logic for their domain. Technical professional with advanced DAX and SQL and expert in semantic models (SSAS tabular model) and Reporting (Power BI).
Requirements
- Bachelor's in Applied Statistics, Computer Analytics, Computer or related field (Equivalent experience will be accepted in lieu of the required degree or diploma).
- 5 years recent relevant experience.
- Advanced knowledge of BI tools such as Microstrategy and Tableau.
- Advanced knowledge of database programming and statistics.
- Advanced knowledge of Microsoft Access, Excel, PowerPoint, and Word.
- Expert knowledge of Structured Query Language (SQL).
- Expert knowledge of Server Reporting Service or other BI applications.
- Advanced DAX and SQL.
- Expert in semantic models (SSAS tabular model) and Reporting (Power BI).
Responsibilities
- Architect, engineer, and govern the enterprise "Semantic Layer."
- Design reusable data models, security frameworks, and metric definitions.
- Responsible for the full lifecycle engineering of the department's semantic infrastructure.
- Determine the appropriate modeling strategy (Import, DirectQuery, or Direct Lake modes).
- Manage legacy SSAS partitions.
- Architect modern Microsoft Fabric semantic models using engineering tools like Tabular Editor and ALM Toolkit.
- Define the governance and security logic for their domain.
- Establish and maintain cooperative working relationships with clients, IS team members, management, and executive personnel/staff.
- Communicate effectively with diverse groups such as executives, managers, and subject matter experts.
- Set priorities which accurately reflect the relative importance of job responsibilities and prioritize assignments to complete work in a timely manner.
- Analyze information, problems, situations, practices, or procedures in order to identify relevant concerns and factors.
- Perform a variety of duties and often change from one task to another of a different nature with frequent interruptions and/or distractions.
- Develop documentation at a technical and user level.
Benefits
- Comprehensive benefits package
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
