Brillio · 21 hours ago
BI Architect - R01559434
United States
Full-time
Remote
Mid Level
$145K/yr - $150K/yr
4+ years expBrillio is a rapidly growing digital technology service provider that partners with Fortune 1000 companies to leverage innovative digital adoption. The BI Architect role involves designing and building BI products, optimizing data pipelines, and translating business requirements into Microsoft Fabric solutions while ensuring data governance and performance strategies are in place.
AnalyticsArtificial Intelligence (AI)Big DataCloud ComputingConsultingEnterprise ApplicationsMachine LearningMobile
Responsibilities
Architecture, Data Modeling & Governance
Design and build new BI products (e.g. datasets, reports, dashboards) following reference architecture (data sources → staging/ETL → warehouse/data lake → semantic models → reports) emphasizing security, lineage, and reusability
Design and build data models for reporting
Establish and enforce development standards (naming, versioning, code review, test/data validation, documentation)
Optimize pipelines (SQL/ETL) and ensure reliable, well modeled datasets for reporting
Implement performance strategies (partitioning, aggregations, incremental refresh, caching, index tuning)
Solutions Delivery (Dashboards & Reporting)
Translate business requirements into Microsoft Fabric solutions; iterate quickly with stakeholders
Write advanced T-SQL, Power Query, and DAX scripts; build reusable measures and shared data models
Drive adoption: publish content, manage workspace/app security, and conduct training/office hours
Analytics & Decision Support
Perform descriptive/diagnostic analyses; run sensitivity/what if scenarios to inform inventory, pricing, and service trade offs
Build forecasts or simple statistical models where appropriate; validate results and quantify business impact
Create clear data stories—narratives that highlight drivers, risks, and recommended
Perform other duties assigned that support the overall success of the team, department, or organization. This may include participating in cross-functional initiatives, contributing to process improvements, or assisting with special projects as needed
This list is intended to describe the general nature and level of work performed. This is not an exhaustive list of all responsibilities required for this role
Regular, predictable, in-person attendance on the business days the Company requires in-person attendance at this facility. (In-person attendance is optional on the other workdays.) For non-required-in-person attendance days, employees are expected to be present and engaged during the designated work hours for this role
Qualification
Required
Bachelor's degree in Analytics, Information Systems, Computer Science, Finance, Statistics, or related field or equivalent practical experience
4+ years in BI/Analytics with combined experience in data modeling and dashboard development
Strong proficiency with Microsoft BI tools (Power BI) and visualization best practices
3+ years of experience in the Consumer Packaged Goods (CPG) or food manufacturing industry
1+ years of experience with Dynamics 365 Finance & Operations (D365 F&O)
1+ years of experience with Microsoft Fabric
Proficiency in T-SQL, Microsoft database technologies, and DevOps
Advanced SQL; working knowledge of ETL tooling and Python (e.g. PySpark, SemPy) for data wrangling/automation
Proven ability to gather requirements, define KPIs, and convert business questions into analytical outputs
Experience tuning dataset/report performance and implementing row level security
Excellent communication and stakeholder management skills
Strong skills in technical draftsmanship and working knowledge of standard software and database documentation artifacts
Excellent critical thinking, analytical, problem-solving, interpersonal, time management, multi-tasking and communication skills
Passion, humility, integrity, credibility, and commitment to values
Excellent people skills that generate respect and trust from stakeholders
Data-driven with an affinity for business process enhancement and automation
Preferred
Familiarity with Azure data services or equivalent cloud data platforms
Exposure to forecasting/statistical methods and data quality frameworks
Company
Brillio
Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.
5001-10000 employees
H1B Sponsorship
Brillio has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (258)
2024 (240)
2023 (281)
2022 (314)
2021 (196)
2020 (406)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
The Orogen Group
2023-09-05Private Equity
2019-01-14Acquired
Leadership Team
Raj Mamodia
Chairman, Founder & CEO
Santosh Padmanabhan
Architect
Recent News
Financial Express
2025-03-21
Canada NewsWire
2025-03-12
Company data provided by crunchbase