Business Intelligence Analyst Senior

SGS Consulting; Austin (TX); Vor Ort; USD 110.000 - 140.000; Vollzeit

Zusammenfassung

SGS Consulting is seeking a Senior BI professional to design and implement robust data models and interactive Power BI dashboards. You will manage architecture, gateways, and premium capacities while integrating with Azure Data Factory and SQL Server.

Collaboration with data engineers and stakeholders is essential to deliver scalable BI solutions. The role emphasizes governance, security standards, and performance optimization, including incremental refresh and large dataset handling.

Qualifikationen

• Bachelor's degree in related fields or equivalent experience.
• 4-6 years of SQL programming experience with large data assets.
• Experience with Power BI design and development using normalized/denormalized data models.

Aufgaben

• 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.
• Build interactive dashboards and reports aligned with business requirements.
• 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.
• Monitor and optimize report performance, dataset refresh strategies, and query folding. Implement best practices for incremental refresh and large dataset handling.
• 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.

Kenntnisse

Power BI

DAX

Power Query

Data modeling

SQL

SQL Server

Power BI Architecture

Ausbildung

Bachelor's degree in related field

Tools

Azure Data Factory

SQL Server

Jobbeschreibung

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.

Employment Details

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.