Business Intelligence Analyst Senior Job at SGS Consulting, Texas

  • SGS Consulting
  • Texas

Job Description

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.

Job Tags

Full time

Similar Jobs

VCA

Cardiologist Job at VCA

 ...position may also be eligible for other variable pay programs. Health & Well-being Innovative Associate health and well-being resources (Headspace app, Vault financial wellness tool, and access to additional mental health resources including Lyra Health) 401k retirement... 

Prato - Bethesda

Restaurant Manager Job at Prato - Bethesda

 ...are seeking an energetic and dedicated Restaurant Manager to lead our dynamic hospitality team. In...  ...exceptional customer service, efficient food and beverage management, and a positive...  ...management to make a meaningful impact in a fast-paced environment. Responsibilities... 

Ergomed

Senior Clinical Research Associate (West Coast based) Job at Ergomed

 ...Medicine moves forward here. So will you. Clinical trials, safety studies, and audits make safe and innovative pharmaceutical-led...  ...join a passionate and collaborative team of experts in clinical research, pharmacovigilance, and quality consulting. We are diverse in... 

Designer Fund

Customer Service Representative (German-speaking) Job at Designer Fund

 ...globally. As a Customer Service Representative at Via, you will be the human...  ...about making public transit work better for real people - [see...  ...by providing telephone, live chat, and email support. Work scheduled...  ...We Offer ~100% work from home, as long as you're based in... 

Asheville City Schools

CTE Technology Engineering and Design Education Teacher Job at Asheville City Schools

 ...General Description William Randolph Campus is seeking a qualified and innovative Technology, Engineering, and Design (TED) Teacher to join our Career and Technical Education (CTE) team. The ideal candidate will inspire students to explore STEM-related careers through...