Onsite Technical Lead

Posted 3 hours ago

Apply now

About the role

  • BI Engineer with 8+ years experience focusing on data modeling and reporting solutions at IGT Solutions. Collaborating with stakeholders to create effective business intelligence reports.

Responsibilities

  • Design and implement efficient star schemas and other data models for data warehouses to optimize analytical performance.
  • Collaborate with business stakeholders to gather requirements and translate them into scalable data models.
  • Ensure data accuracy and consistency across warehouse systems.
  • Create and manage Power BI Premium data models and dashboards with a focus on usability, scalability, and performance.
  • Write complex DAX calculations to enable insightful and interactive data visualizations.
  • Optimize Power BI datasets for efficient querying and reporting.
  • Write and optimize T-SQL queries for data extraction, transformation, and analysis from data warehouses and other systems.
  • Develop stored procedures, views, and functions to support BI reporting needs.
  • Build SSRS/Paginated Reports to deliver detailed, print-friendly reports for operational needs.
  • Ensure reports meet business requirements and align with organizational standards.
  • Work closely with data engineers, analysts, and business users to support BI initiatives and resolve data-related issues.
  • Provide guidance on best practices in data modeling and visualization.
  • Leverage tools like Databricks SQL (if applicable) for advanced querying and analytics use cases.

Requirements

  • 8+ years of experience in BI development, data modeling, and reporting.
  • Expertise in Azure SQL , Power BI Premium , DAX , and T-SQL .
  • Strong proficiency in data warehouse design (e.g., star schema).
  • Hands-on experience in creating complex reports using SSRS or Paginated Reports .
  • Proficient in querying and analyzing data from large-scale data warehouses.
  • Ability to design user-friendly, scalable, and performant data models in Power BI.
  • Strong understanding of ETL/ELT processes and how they impact data warehouse performance.
  • Preferred Skills: Experience with Databricks SQL is a plus.
  • Familiarity with Power BI Premium features such as dataflows, incremental refresh, and large datasets.
  • Knowledge of data governance and data security best practices.
  • Strong analytical and problem-solving skills with attention to detail.
  • Soft Skills: Excellent communication and collaboration skills to work with cross-functional teams.
  • Strong ability to prioritize and manage multiple tasks in a fast-paced environment.
  • Self-motivated and eager to learn new technologies and methodologies.

Job title

Technical Lead

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Tech skills

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job