Job Description
Summary:
We seek a seasoned Power BI Report developer to collaborate on delivering reports for a new product rollout. Regular progress reviews and report visualization adjustments will be conducted with key stakeholders.
The successful candidate will develop Power BI reports from hundreds of millions of unaggregated rows of IoT data stored in AWS Redshift. Proficiency in creating highly optimized aggregate queries, leveraging partitioning and indexing, is essential.
Responsibilities:
* Collaborate with stakeholders to understand objectives, important metrics, and business performance measurement.
* Develop visualizations empowering internal customers to make informed decisions.
* Maintain and secure data and reporting according to best practices.
* Validate data accuracy through execution of validation processes and testing procedures.
* Assemble complex data sets meeting business requirements.
* Optimize data models ensuring efficient data retrieval and analysis.
* Investigate and resolve issues in BI tools and reports reported by end users.
Required Skills and Qualifications
We require the following skills and qualifications:
* Advanced Power BI development skills (5+ years) including data visualization, performance tuning, and UX optimization.
* Experience with AWS Redshift Database.
* Ability to interpret stakeholder requests and translate into actionable insights through data analysis and report preparation.
* Proficiency in data modeling (star schema designs) and SQL for data preparation, optimization, and transformation.
* DAX expertise for calculations, measures, and Calculation Groups in Power BI.
* Power Query and M code proficiency for data transformation and troubleshooting.
* Excellent writing and communication skills for documentation, collaboration, and user support.
* Working knowledge of version control systems (git) and local development environments.
* Basic understanding of data engineering concepts (ETL processes and data pipelines).
* Ability to work independently.
Benefits
Our ideal candidate will have the opportunity to grow professionally, contribute to innovative projects, and enjoy a dynamic work environment.