Responsibilities:
• Analyze data and design semantic models
• Transform raw data into silver/gold data for reporting consumption.
• Design, develop, and release deploy Power BI reports and dashboards meeting KPIs including accuracy, reliability and performance.
• Review business requirements (and related materials) to use as input for design/development of reports
• Design technical systems specifications to translate into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.
• Provide specialized skills for developing data access queries
• Works in conjunction with data analysts for developing dashboards and other end user reporting products
• Supports Client’s wide-ranging business information requirements, implementing and supporting OLAP analytical software solutions
• Develops and supports customized query applications which analyze key business data Requirements Experience and Skill Set
Requirements:
Must Haves:
• 6+ years experience as Azure technologies including
• Azure Databricks
• Azure DataLake Gen 2.
• Power BI development and semantic modeling
• Azure DevOps CI/CD
• PySpark
• Microsoft Fabric
• Star Schema or Snowflake data modeling experience
• Orchestration & Ingestion:
• Proficiency using Data Factory within Fabric to build complex, scalable data pipelines.
• Business Intelligence:
• Designing effective Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake.
• Use of semantic models to design and develop Power BI reports and dashboards. Develop operational and analytical PowerBI reports/paginated reports. Skill Set
Requirements:
Mandatory Skills and
Experience:
• 6+ years experience as Azure technologies including
• Azure Databricks
• Azure DataLake Gen 2.
• Power BI development and semantic modeling
• Azure DevOps CI/CD
• PySpark
• Microsoft Fabric
• Star Schema or Snowflake data modeling experience
• Orchestration & Ingestion:
• Proficiency using Data Factory within Fabric to build complex, scalable data pipelines.
• Business Intelligence:
• Designing efficient Direct Lake semantic models in Power BI using Silver/Gold layer models to ensure high-speed reporting directly from OneLake.
• Use of semantic models to design and develop Power BI reports and dashboards. Develop operational and analytical PowerBI reports/paginated reports. Desirable Skills and
Experience:
• Experience in Azure Data Factory (ADF) v2
• Data Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines, and implementing Medallion architecture (Bronze/Silver/Gold layers).
• Data Governance: Data security (row-level/column-level), and data lineage tracking.