TSG Risk Management ยท 5 months ago
Power BI Architect - Data Engineering & Security Analytics
new york city, NY
Full-time
Hybrid
Senior Level, Lead/Staff
8+ years expTSG Risk Management is seeking a Power BI Architect to lead enterprise-level analytics initiatives across operations, finance, and security domains. The role involves designing scalable data models, implementing governance frameworks, and delivering analytical solutions that enable strategic decision-making in a high-compliance environment.
Security & Investigations
Responsibilities
Design and implement end-to-end BI architectures integrating Power BI, Snowflake, and Azure data platforms
Build semantic layers and star schemas to enable intuitive, high-performance analytics
Work with Snowflake, other cloud/on-prem data sources, and design optimized data structures
Collaborate with business stakeholders and data teams to define KPIs, dimensions, and fact tables
Develop optimized Power BI reports, dashboards, and paginated reports
Define and enforce best practices for data modeling, governance, and security (Row-Level Security, data masking, and access control)
Provide mentorship and architectural guidance to BI developers and analysts
Qualification
Required
8+ years of experience in data analytics and BI architecture roles
Advanced expertise in Microsoft Power BI (DAX, Power Query, visualization best practices)
Strong background in Snowflake and star schema design for analytics
Proven experience in dimensional modeling and supply chain data (inventory, procurement, demand planning, logistics, etc.)
Strong SQL skills and ability to work with large, complex datasets
Demonstrated experience implementing secure BI solutions with RLS, data masking, and governance controls
Security-minded approach to data design, with awareness of sensitive data handling and access best practices
Ability to align technical solutions with business goals
Preferred
Prior experience working with security-related datasets or analytics in regulated industries (e.g., security operations, risk analytics, compliance reporting)
Microsoft certifications (Power BI, Azure Data Engineer)
Experience with Azure Synapse, Databricks, or dbt
Familiarity with Agile methodologies and CI/CD for BI workflows
Company
TSG Risk Management
11-50 employees
H1B Sponsorship
TSG Risk Management 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 (1)
Funding
Current Stage
Early StageCompany data provided by crunchbase