Summary
We are seeking a highly skilled and experienced Senior Power BI Developer to join our dynamic team and drive our business intelligence initiatives. This role is critical in transforming complex data from multiple sources into actionable insights through interactive and visually compelling Power BI reports and dashboards. The ideal candidate will play a pivotal role in enabling data-driven decision-making across the organization by collaborating closely with business analysts, data engineers, and other stakeholders. This position offers an exciting opportunity to work with large-scale integrated systems and leverage advanced data warehousing and ETL processes within a modern cloud environment.
Responsibilities
- Design, develop, and deploy interactive Power BI reports and dashboards tailored to meet business needs. Ensure reports are intuitive, visually appealing, and provide actionable insights.
- Collaborate with data engineers to integrate data from SQL Server databases, data warehouses, and other large-scale systems. Develop and optimize ETL workflows to ensure data accuracy, consistency, and timeliness.
- Apply best practices in data visualization to present complex data in a clear and meaningful way, enabling stakeholders to quickly grasp key metrics and trends.
- Monitor and optimize the performance of Power BI reports and dashboards to ensure fast load times and smooth user experience, even with large datasets.
- Conduct thorough data analysis and validation to ensure the integrity and reliability of the data presented in reports.
- Work closely with business analysts, data engineers, and other stakeholders to gather requirements, provide technical guidance, and deliver solutions that align with business objectives.
- Create comprehensive documentation for Power BI reports, data models, and ETL processes. Provide training and support to end-users to maximize adoption and effective use of BI tools.
- Continuous Learning: Stay current with the latest Power BI features, industry trends, and best practices. Proactively suggest improvements and innovations to enhance the BI environment.
Requirements
Must-Have Skills
- Power BI: Expert-level proficiency in Power BI Desktop and Power BI Service, including report creation, data modeling, DAX (Data Analysis Expressions), Power Query, and deployment. Ability to create complex, interactive dashboards that provide deep insights.
- SQL & SQL Server: Strong command of SQL for querying, transforming, and managing data within SQL Server databases. Experience with writing optimized queries and stored procedures to support BI reporting.
- Data Warehousing: Solid understanding of data warehousing concepts, including star and snowflake schemas, fact and dimension tables, and data marts. Experience working with large-scale data warehouses to support enterprise reporting.
- ETL (Extract, Transform, Load): Hands-on experience designing and implementing ETL processes to extract data from various sources, transform it according to business rules, and load it into data warehouses or BI platforms.
- Data Visualization: Deep knowledge of data visualization principles and best practices to create clear, effective, and user-friendly reports that facilitate decision-making.
- Data Analysis: Strong analytical skills to interpret data trends, identify anomalies, and provide actionable insights that drive business outcomes.
- Data Integration: Experience integrating data from multiple heterogeneous sources, ensuring data consistency and quality across systems.
- Communication Skills: Excellent verbal and written communication skills to effectively collaborate with cross-functional teams, translate technical concepts for non-technical stakeholders, and document BI solutions.
Nice-to-Have Skills
- Azure Data Factory: Familiarity with Azure Data Factory for orchestrating and automating data workflows in the cloud. Experience with cloud-based ETL pipelines and data integration within the Azure ecosystem is a plus.
Target Start Date: ASAP
Engagement Length: 6 months
Time Zone: EST
Working Hours: From 8:00 am to 5:00 pm