Power BI Engineer/Data Engineer

**Job Title: Power BI Engineer / Data Engineer** **Position Summary:** We are seeking an experienced Power BI Engineer with strong Data Engineering skills to design, develop, and maintain scalable business intelligence and data solutions. The ideal candidate will have deep expertise in Power BI, DAX, Power Query, semantic/data modeling, SQL, and data visualization, combined with hands-on experience building and optimizing data pipelines, ETL/ELT processes, data warehouses/lakehouses, and cloud-based data platforms. This role will partner with business stakeholders, analysts, data engineers, and technology teams to transform complex data into reliable, governed, and actionable insights. **Key Responsibilities:** *Power BI & Business Intelligence* - Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models. - Build intuitive and interactive visualizations that translate complex datasets into actionable business insights. - Develop advanced calculations and business logic using DAX. - Use Power Query / M for data transformation, cleansing, and preparation. - Design efficient star and snowflake schemas, dimensional models, and reusable semantic layers. - Implement Row-Level Security (RLS) and appropriate data-access controls. - Configure and optimize Import, DirectQuery, composite models, incremental refresh, and data gateways as appropriate. - Optimize Power BI solutions for performance, scalability, usability, and maintainability. - Establish reusable reporting standards, templates, KPI definitions, and visualization best practices. - Support deployment and lifecycle management of Power BI solutions across development, testing, and production environments. - Troubleshoot report, refresh, gateway, semantic-model, and performance issues. *Data Engineering* - Design, build, and maintain scalable ETL/ELT data pipelines to support analytics and reporting. - Integrate structured and semi-structured data from databases, APIs, files, cloud platforms, and enterprise applications. - Develop complex and performance-optimized SQL queries, stored procedures, views, and transformation logic. - Build and maintain data warehouse, data lake, and/or lakehouse solutions. - Implement data cleansing, transformation, validation, reconciliation, and quality-control processes. - Develop reusable data pipelines and frameworks using technologies such as Python, PySpark, SQL, and cloud-native data services. - Implement pipeline monitoring, error handling, logging, alerting, and operational support processes. - Optimize large-scale datasets and pipelines for performance, reliability, and cost efficiency. - Support metadata management, lineage, data governance, and data-quality initiatives. - Work with engineering teams to implement appropriate CI/CD and version-control practices for BI and data solutions. ** Qualifications:** - Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related field, or equivalent professional experience. - 5+ years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or related roles. - Strong hands-on experience with Microsoft Power BI. - Advanced proficiency in DAX, Power Query/M, SQL, and dimensional data modeling. - Strong understanding of Power BI semantic models, relationships, filter context, performance optimization, security, and refresh strategies. - Experience designing and developing ETL/ELT pipelines. - Strong understanding of data warehousing, dimensional modeling, data lakes, and lakehouse architectures. - Experience working with large datasets and optimizing queries and data-processing workloads. - Hands-on experience with at least one major cloud data ecosystem, preferably Microsoft Azure. - Experience with Git/version control and CI/CD concepts. - Strong analytical, troubleshooting, and problem-solving skills. - Ability to communicate technical concepts effectively to both technical and non-technical stakeholders. **Preferred Technical Skills:** Experience with several of the following is highly desirable: *Business Intelligence* - Power BI Desktop - Power BI Service - DAX - Power Query / M - Power BI Gateway - Power BI REST APIs - Tabular Editor / DAX Studio - Microsoft Fabric *Data Engineering & Analytics* - SQL - Python / PySpark - Azure Data Factory - Azure Synapse Analytics - Azure Databricks - Microsoft Fabric Data Factory / Data Engineering - OneLake / Lakehouse - Delta Lake - SQL Server / Azure SQL - Snowflake - Data warehouse and dimensional modeling *DevOps & Governance* - Git - Azure DevOps / GitHub - CI/CD - Deployment pipelines - Data lineage and metadata management - Data quality frameworks - Role-based access and data security **Key Competencies:** - Strong understanding of the complete data lifecycle, from source ingestion → transformation → storage → semantic modeling → visualization. - Ability to balance business with scalable technical design. - Strong attention to data accuracy, quality, security, and governance. - Ability to diagnose performance bottlenecks across SQL, pipelines, semantic models, and Power BI reports. - Strong stakeholder-management and skills. - Ability to work effectively in Agile and cross-functional environments. - Ability to document architectures, data models, business rules, and operational processes. **Success in This Role:** The successful candidate will build more than dashboards. They will develop end-to-end analytics solutions that provide trusted, scalable, and high-performing data products—from ingestion and transformation through semantic modeling and executive-ready Power BI reporting.