Director, Business Intelligence
Model N
AzureSQL
Data Analytics and Governance Lead
Visio Lending
full-time
Posted on:
Origin: • 🇺🇸 United States • Alabama, Arizona, Florida, Illinois, Kansas, Kentucky, Louisiana, North Carolina, Ohio, South Carolina
Visit company websiteSalary
💰 $95,000 - $120,000 per year
Job Level
Senior
Tech Stack
AzureSQL
About the role
- Lead collaboration with business units to identify critical data sources, KPIs, and reporting needs
- Manage ingestion of structured data into the enterprise data warehouse using tools such as Azure Synapse pipelines (formerly Azure Data Factory)
- Build reports, dashboards, and data alerts using Power BI; develop, publish, and maintain Power BI semantic models (tabular) including DAX measures, incremental refresh, and composite/DirectQuery models
- Administer Power BI Service (tenant settings, workspace & capacity management for Pro/Premium, data gateways, deployment pipelines, RLS/OLS) and enforce governance policies for secure self-service
- Collaborate with SMEs to define and maintain KPIs and standardized metrics; maintain a centralized KPI Registry and Business Glossary
- Monitor and maintain operational health of the enterprise data warehouse and related BI systems
- Partner with the AI Enablement Lead to ensure data quality and availability for AI-powered solutions, including integration with Azure AI Foundry/Azure ML and data contracts
- Provide guidance to business users on self-service BI platform usage and support data governance efforts, including stewardship, access control, and documentation
- Establish and lead Visio’s data governance program; identify systems of record, single sources of truth, and data ownership using Microsoft Purview for cataloging and lineage
- Define and maintain data standards, naming conventions, and documentation protocols; track and prioritize enhancement requests and promote consistent practices across teams
- Coordinate with IT on performance, permissions, and platform maintenance; plan for Microsoft Fabric readiness where appropriate
- Maintain centralized documentation of KPIs, definitions, and metadata in support of self-service analytics
Requirements
- Bachelor’s degree in information systems, business analytics, computer science, or a related field, or equivalent experience
- 3–6 years of experience working with enterprise data platforms, reporting tools, or business intelligence systems
- Expertise with Microsoft Azure Synapse pipelines (formerly ADF) and Power BI Service configuration, including building and maintaining Power BI semantic models
- Demonstrated ability to define KPIs and build dashboards for operational or strategic insights
- Highly skilled at using SQL for querying and manipulating structured datasets
- Understanding of data governance, metadata, and data quality management concepts
- Ability to use standard office equipment, printer, scanner, copier, fax, telephone, personal computer, and other peripheral devices
- Internal Applicants: 6 months of Visio Lending work experience with no disciplinary actions; current manager notification required to apply
