Business Intelligence Analyst Senior Job at SGS Consulting, Texas

b2didGM4OGJFWWxuaWI3Um5SeDZpcWt3NHc9PQ==
  • 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

Zoomed Xpedited Logistics LLC

Medical Courier Delivery Driver Job at Zoomed Xpedited Logistics LLC

 ...Job Description Medical Courier Delivery Driver (Cargo Van / Box Truck) Location: Livonia, MI (Servicing Metro Detroit) Schedule: Monday...  ...finish around 12:00 PM / Noon) Employment Type: Independent Contractor (1099) Pay: Per-stop rate starting at $14.00... 

Ilderton Dodge Chrysler Jeep RAM

Government Fleet Sales Associate Job at Ilderton Dodge Chrysler Jeep RAM

Overview:We are seeking a motivated and relationship-driven Government Fleet Sales Associate to support the sale of vehicles to government...  ...:* Develop and maintain relationships with local, state, and other government agencies and public-sector customers.*... 

SimIS Inc.

Sr. Operations Research Analyst (N2701) Job at SimIS Inc.

 ...To support our customer, SimIS, Inc. seeks a Senior Operations Research Analyst to enable capability development programme teams to drive...  ...propose possible risk management approaches. Benefits: ~ Medical, Dental, and Vision ~ Short-Term Disability (at no cost to... 

We Are Logistics East Point Inc.

Delivery Driver (FedEx Ground) Job at We Are Logistics East Point Inc.

 ...Delivery Driver - $150/Day | Paid Training | Full-Time | East Point, GA, 30344. Looking for a Delivery Driver, Courier, Non-CDL Delivery...  ...East Point, GA? Join We Are Logistics East Point Inc. with FedEx Ground! You'll deliver packages to local homes and businesses, work... 

Dandy

Remote Dental Field Trainer - California Bay Area Job at Dandy

 ...the Role: Were looking for a highly consultative Field Trainer in the California Bay Area (San Francisco, Oakland, San Jose)...  ...dentistry solutions. This role is field-based, with up to 85% travel nationwide , and is focused on helping dental practices adopt...