Power BI Lead

Cloud Analytics Technologies, LLC; Bolingbrook (IL); On-site; USD 110,000 - 170,000; Full time

Job summary

Cloud Analytics Technologies is seeking a Power BI Lead to design, develop, and implement Power BI solutions that meet business requirements. You will collaborate with stakeholders and technical teams to identify data visualization needs and create scalable BI solutions.

The role emphasizes data modeling, performance optimization, security governance, and automated data refreshes. The candidate should have strong skills in Power BI Desktop/Service, DAX, SQL, and data warehousing concepts, with

Qualifications

• Proven experience designing and implementing Power BI solutions (end-to-end).
• Experience resolving performance issues on large-scale BI deployments.
• Familiarity with data integration, ETL and data warehousing concepts.

Responsibilities

• Design Power BI solutions aligned with business goals.
• Develop data models and data flows to support dashboards and reports.
• Create visually appealing and interactive dashboards and reports.
• Collaborate with data engineers to source data from databases, data warehouses, and APIs.
• Optimize performance and implement caching for faster data retrieval.
• Implement security and data governance policies and access controls.
• Schedule and manage data refresh processes for up-to-date reports.
• Monitor data accuracy, performance, and system health; perform maintenance and updates.

Skills

Power BI

Data modeling

Data warehousing

BI concepts

CI/CD

Monitoring

Security governance

Data visualization

SQL knowledge

Tools

Power BI Desktop

Power BI Service

Power Query

DAX

M

SQL

Job description

As a Power BI Lead, you will be responsible for designing, developing, and implementing Power BI solutions that meet the business requirements of the organization. You will work closely with business stakeholders and technical teams to identify data visualization needs and create robust and scalable Power BI solutions. This role requires a deep understanding of data modeling, data visualization, and business intelligence concepts, as well as strong technical and analytical skills.

Roles and Responsibilities:

• Design:Collaborate with business stakeholders and technical teams to understand data requirements, define business intelligence objectives, and design Power BI solutions that align with the organization's goals and strategies.
• Data Modeling:Develop data models and data flows to support efficient and accurate data visualization. Design and implement data transformations, aggregations, calculation groups and calculations to create meaningful insights and metrics.
• Data Visualization:Create visually appealing and interactive dashboards, reports, and visualizations using Power BI. Ensure data accuracy and consistency throughout the visualizations and provide insights in a clear and understandable manner.
• Data Integration:Work closely with data engineers and developers to identify and extract data from various sources such as databases, data warehouses, and APIs. Transform and cleanse data as needed for effective analysis and reporting. Implement data security and access controls to ensure data confidentiality.
• Performance Optimization:Optimize Power BI solutions for improved performance and scalability. Identify and resolve performance bottlenecks, enhance query performance, and implement caching mechanisms to optimize data retrieval.
• Security and Governance:Implement security measures and data governance policies to ensure the confidentiality, integrity, and availability of data. Define and enforce data access controls, data classification, and data retention policies in line with organizational standards and compliance requirements.
• Data Refresh and Automation:Schedule and manage data refresh processes to ensure the availability of up-to-date information in Power BI reports and dashboards.
• Monitoring and Maintenance:Monitor Power BI solutions for data accuracy, performance issues, and system health. Proactively identify and resolve issues, perform regular maintenance tasks, and apply necessary updates and patches to keep the system up to date.

Qualifications:

• Proven experience as a Power BI Developer with expertise in designing and implementing Power BI solutions.
• Experienced in resolving performance issues on large scale BI implementation on big data platforms.
• Experienced in CI/CD and setting up automated testing of Power BI reports
• Experienced in setting up monitoring and alerting for performance and operational issues with Power BI reports and environment.
• Strong knowledge of data modeling, data warehousing, business intelligence concepts
• Proficiency in Power BI Desktop, Power Query, DAX, M, Power BI Service
• Experience with data integration, ETL processes
• Familiarity with SQL and relational databases
• Solid understanding of data visualization principles and best practices.
• Experience with data warehousing concepts and technologies.
• Knowledge of cloud platforms GCP and their integration with Power BI is a plus.
• Relevant certifications such as Microsoft Certified: Data Analyst Associate or Microsoft Certified: Power BI Certified is preferred.

CLOUD ANALYTICS TECHNOLOGIES is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.

Equal Opportunity Employer

CLOUD ANALYTICS TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. CLOUD ANALYTICS TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will CLOUD ANALYTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: