Responsibilities:
Design and develop reports, dashboards, and ad-hoc queries.
Collaborate with business users to understand and meet their requirements.
Utilize data modeling techniques using Power Query/Power Pivot.
Develop and optimize DAX queries.
Use Power BI Report Builder and/or create Paginated Reports.
Manage and query SQL Server or any other relational databases.
Must-Have Skills:
Data modeling using Power Query/Power Pivot.
Proficiency in DAX.
Experience with Power BI Report Builder and/or Paginated Reports.
Strong SQL skills, particularly with SQL Server or similar relational databases.
Nice-to-Have Skills:
Working knowledge of Data Flows.
Experience with PBRS (Power BI Report Server).
Familiarity with Power On.
Experience with Snowflake data warehouse.
Qualifications:
- Minimum of 7+ years of combined experience in data warehousing, business intelligence, analytics, and reporting systems.
- At least 3+ years of experience in relational and multi-dimensional (OLAP) data modeling.
- Proficiency in SQL, including relational and dimensional database structures and query optimization.
- Ability to analyze user requirements, make recommendations, and implement solutions.
- Self-driven with the ability to troubleshoot and provide quick resolutions to issues.
- Experience with full project management and development life cycle.
- Strong oral and written communication skills.
- Strong presentation and interpersonal skills.
- Ability to prioritize and manage tasks in a high-pressure environment.