Collaborate with business users to identify, analyze, and document business requirements and key performance indicators (KPIs)
Design, develop, and maintain data integration and automation using Power BI, Azure Databricks, Power Automate, and SmartSheets
Collect and transform data from multiple sources into a structured format for analysis
Develop and maintain data models and data sets for efficient and accurate reporting
Create Power BI dataflows and shared semantic models to consolidate data model definitions
Ensure data accuracy, integrity, and consistency within the BI solutions
Provide training and support to Power BI developers to optimize data models in Power BI for their development needs
Collaborate with IT teams to ensure data security, integrity, and compliance with data governance policies
Stay up to date with the latest trends in business intelligence and analytics tools, techniques, and best practices
Requirements
Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field
Proven experience of at least 3 years as a Data Engineer or similar role
Strong proficiency in Power BI, specifically modeling, row-level-security, and complex DAX formulations
Strong proficiency in Power Query, including writing M-code
Solid understanding and practice of data modelling: relational models (ERD), star/snowflake schemas, slowly changing dimensions, referential integrity, etc.
Proficient in SQL and data manipulation languages
Strong analytical and problem-solving skills with the ability to interpret complex data sets
Excellent communication and collaboration skills to work effectively with cross-functional teams and stakeholders
Ability to manage multiple projects simultaneously, prioritize tasks, and meet deadlines