SR Power BI Developer

This is a remote position.

About Advancio:

We are a global software company that is growing every day and we look to create a better world for those that come in contact with us while making our workplace communities and lives enjoyable.

We build the change we want to see in the world one interaction at a time one user session at a time using our core values we make small things great. We are passionate about what we do we collaborate positively and most important of all: have fun while we work!

Position Overview: The Senior Power BI professional will play a pivotal role in the organizations Business Intelligence (BI) team. They will be responsible for designing developing and maintaining BI solutions using Power BI to provide valuable insights that support strategic decisionmaking. Additionally this role will involve crossdepartmental collaboration and data management in complex environments.

Requirements

Responsibilities:

.

Architect scalable and efficient data models in Power BI leveraging DAX to create sophisticated calculations and aggregations.

.

Develop Power BI reports: Utilize Power BI tools to create reports and dashboards that provide actionable insights. Use direct query capabilities to connect to Azure SQL databases employ DAX functions for data manipulation and prepare Power Pivot tables in Excel.

.

Understand business requirements: Collaborate with stakeholders to gather and understand their business requirements. Translate these requirements into effective reports and visualizations that address key business needs and enable datadriven decisionmaking.

.

Craft visually compelling dashboards and reports that provide actionable insights utilizing DAX for advanced analytics and calculations.

.

Data analysis and optimization: Perform data analysis tasks including SQL queries tuning and optimization to ensure efficient and accurate data retrieval. Identify performance bottlenecks suggest improvements and implement optimizations for Azure SQL databases.

.

Optimize Power BI performance by finetuning DAX queries data models and report designs. Implement caching strategies and other performanceenhancing techniques to ensure a seamless user experience.

.

Data warehouse design: Possess knowledge of both logical and physical design concepts related to data warehousing. Contribute to the design and development of data warehouse solutions ensuring data integrity performance and scalability.

Qualifications:

.

Bachelors degree in Computer Science Data Engineering or a related field (or equivalent experience).

.

56 years of experience in data engineering with a strong focus on Power BI SQL Server SQL and analytic processes.

.

Strong experience with Power BI including direct query capabilities DAX functions and Power Pivot.

.

Proficiency in SQL and Azure SQL databases with a focus on performance tuning and optimization.

.

Knowledge of data warehousing concepts logical and physical design and ETL processes.

.

Strong analytical and problemsolving skills with the ability to translate business requirements into actionable insights.

.

Excellent communication and collaboration skills to effectively work with crossfunctional teams and stakeholders

Responsibilities: Architect scalable and efficient data models in Power BI, leveraging DAX to create sophisticated calculations and aggregations. Develop Power BI reports: Utilize Power BI tools to create reports and dashboards that provide actionable insights. Use direct query capabilities to connect to Azure SQL databases, employ DAX functions for data manipulation, and prepare Power Pivot tables in Excel. Understand business requirements: Collaborate with stakeholders to gather and understand their business requirements. Translate these requirements into effective reports and visualizations that address key business needs and enable data-driven decision-making. Craft visually compelling dashboards and reports that provide actionable insights, utilizing DAX for advanced analytics and calculations. Data analysis and optimization: Perform data analysis tasks, including SQL queries tuning and optimization, to ensure efficient and accurate data retrieval. Identify performance bottlenecks, suggest improvements, and implement optimizations for Azure SQL databases. Optimize Power BI performance by fine-tuning DAX queries, data models, and report designs. Implement caching strategies and other performance-enhancing techniques to ensure a seamless user experience. Data warehouse design: Possess knowledge of both logical and physical design concepts related to data warehousing. Contribute to the design and development of data warehouse solutions, ensuring data integrity, performance, and scalability. Qualifications: Bachelor's degree in Computer Science, Data Engineering, or a related field (or equivalent experience). 5-6 years of experience in data engineering, with a strong focus on Power BI, SQL Server, SQL, and analytic processes. Strong experience with Power BI, including direct query capabilities, DAX functions, and Power Pivot. Proficiency in SQL and Azure SQL databases, with a focus on performance tuning and optimization. Knowledge of data warehousing concepts, logical and physical design, and ETL processes. Strong analytical and problem-solving skills, with the ability to translate business requirements into actionable insights. Excellent communication and collaboration skills to effectively work with cross-functional teams and stakeholders