BI Architect
Beacon Hill Staffing Group, LLC
Saint Davids, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 160KJob location
Saint Davids, United States of America
Tech stack
Business Analytics Applications
Azure
Cloud Database
Cloud Engineering
Continuous Integration
Information Engineering
Data Governance
ETL
Relational Databases
PostgreSQL
Meta-Data Management
Microsoft SQL Server
MySQL
Oracle Applications
Query Optimization
Power BI
Powerquery
Data Lineage
Software Version Control
Redshift
Job description
- Architect, design, and develop scalable, enterprise-grade semantic models to support self-service Power BI analytics
- Partner with Data Architects and ETL teams to ingest, transform, and prepare large and complex data models for analytics consumption
- Implement and manage data governance, access controls, and security policies across BI platforms
- Collaborate with business stakeholders to gather requirements and translate them into effective BI and reporting solutions
- Optimize Power BI report and dataset performance through advanced data modeling, DAX optimization, and query tuning
- Monitor Power BI workspaces and Fabric capacities to ensure performance, scalability, and efficiency
- Troubleshoot and resolve performance issues related to reports and dashboards
- Establish and enforce enterprise standards and best practices for Power BI development
- Lead initiatives related to metadata management, data lineage, documentation, and data quality
- Provide technical leadership and mentorship to IT staff and business users
- Support enterprise reporting strategy to ensure consistency, scalability, and reliability across analytics platforms
Requirements
- 5+ years of experience in BI architecture and data engineering, with 10+ years of overall IT experience
- Expert-level Power BI experience including DAX, Power Query, and advanced data modeling
- Strong expertise with relational databases and SQL (Oracle, PostgreSQL, MySQL, SQL Server, Redshift)
- Deep knowledge of AWS cloud architecture and RDS environments
- Experience with Informatica IDMC Cloud Data Catalog and governance tools
- Strong understanding of cloud data warehousing, analytics platforms, and ETL/ELT processes
- Proven ability to design and manage large-scale semantic models for self-service analytics environments
- Experience with Azure DevOps for source control and CI/CD pipeline deployments
About the company
Beacon Hill was founded to set a new standard in search, career placement and flexible staffing., Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs.
Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles.