Business Intelligence Analyst Senior
1 day ago
Clifton TX, Bosque County, TX; Texas, United States
SGS Consulting
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Job Responsibilities:
- Data Modeling & Architecture -Design and implement robust data models using star schema and snowflake techniques for optimal performance.
- Ensure proper relationships, hierarchies, and calculated measures in Power BI datasets.
- Optimize data models for scalability and maintainability. Power BI Development
- Build interactive dashboards and reports aligned with business requirements. -Implement row-level security (RLS) and manage workspace governance. -Utilize DAX and Power Query (M) for advanced calculations and transformations. Architecture & Integration
- Understand and manage Power BI architecture, including service layers, gateways, and premium capacities.
- Integrate Power BI with Azure Data Factory, SQL Server, and other enterprise data sources.
- Ensure compliance with organizational data governance and security standards. Performance Optimization -Monitor and optimize report performance, dataset refresh strategies, and query folding.
- Implement best practices for incremental refresh and large dataset handling. Collaboration & Leadership
- Work closely with data engineers, analysts, and business stakeholders to deliver high-quality BI solutions.
- Provide guidance on Power BI adoption, workspace design, and governance frameworks. Required Skills & Qualifications Technical Expertise -Advanced proficiency in Power BI Desktop and Service.
- Strong knowledge of DAX, Power Query, and data modeling principles.
- Experience with Power BI architecture, including gateways, capacity planning, and deployment pipelines. Data Management
- Familiarity with ETL processes, data warehousing, and SQL.
- Understanding of data governance, security, and compliance
Skills:
- Experience 4-6 years’ experience in SQL programming in platforms with large data asset within an OLTP, OLAP and MPP architecture.
- 3-5 years’ experience with Enterprise BI tool such as MicroStrategy or IBM Cognos or Power BI design & development based on normalized & denormalized data model required. Experience in corporate systems environments required. Experience with a variety of Information Management applications, programming languages, and technologies preferred.
- Experience with writing and debugging complex SQL queries. Licenses, Registrations, or Certifications in SQL or Power BI preferred. Work Schedule: 5 Days - 8 Hours Work Type: Full Time
Education/Experience:
- Bachelor’s degree in related fields of study or equivalent job-related experience required.