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

Stellent IT LLC

AMISYS Data Engineer || Remote Job at Stellent IT LLC

 ...Title: AMISYS Data Engineer Location: Remote Overview: The client is transitioning from AMISYS to QNXT and is seeking a Data Engineer with strong AMISYS experience within a healthcare payer environment. Need Strong AMISYS knowledge, legacy data structures... 

Domino's Franchise

Assistant Manager - Navy Blvd Job at Domino's Franchise

Twomays Inc and Teamdriven Inc operate as one Franchise within Domino's Pizza and we are looking to provide opportunity to new team members who are looking for the FUN job, develop skills and grow fast within our organization. Opportunities are limitless with Domino...

Confidential

French Teachers (online and offline) Job at Confidential

teaching group or one to one Chinese students from 6-12 years old Group classes with 2-4 students are available for outstanding professional teachers Variety of courses are available , Working from anywhere with a well-functioning computer and stable internet...

Swank Motion Pictures

Controller Job at Swank Motion Pictures

 ...schools, hospitals, cruise lines, libraries, and many other unique venues worldwide. We are seeking an experienced and hands-on Controller to join our leadership team and partner closely with the CFO in driving the company's financial success. This critical role is... 

InterMed Cost Containment Services

Temporary Worker's Compensation Claims Adjuster II Job at InterMed Cost Containment Services

 ...force service contracts and company guidelines. Review and approve all vocational rehabilitation plans. Establish, monitor, and adjust monetary case reserves when warranted and in strict accordance with assigned authority levels. Review all medical bills for...