Job Summary:
We are seeking a motivated and detail-oriented Power BI / SQL / Python Developer.
Key Responsibilities:
- Design, develop, and deploy visually compelling and interactive Power BI dashboards and reports to support business decision-making.
- Collaborate with stakeholders to study, analyze, and understand business requirements for business intelligence solutions.
- Identify and define key performance indicators (KPIs) and metrics relevant to business objectives.
- Write and optimize complex SQL queries to extract, transform, and load data from various sources.
- Develop and run DAX queries and functions to create robust calculations and models within Power BI.
- Apply data modeling techniques to structure data effectively for reporting and analysis.
- Analyze historical and present data to identify trends, patterns, and opportunities for improvement.
- Translate business requirements into clear technical specifications and documentation.
- Create and maintain comprehensive data documentation for algorithms, parameters, models, and data sources.
- Perform detailed analysis and troubleshooting on new and existing Power BI reports to ensure accuracy and performance.
Qualifications and Skills:
Required:
- Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
- Experience in a data analysis or business intelligence role.
- Proven proficiency in Microsoft Power BI, including creating complex reports, dashboards, and data visualizations.
- Strong expertise in SQL for data querying and manipulation.
- SSIS ETL experience required
- Scripting experience with Python - hands on scripting and coding in Python
- Solid understanding of Data Warehousing (DWH) concepts and principles.
- Experience with data modeling concepts and best practices.
- Proficiency in writing DAX queries and functions.
- Excellent analytical and problem-solving skills with the ability to understand business needs.
- Strong written and verbal communication skills.
- Ability to work both independently and as part of a collaborative team.