METER Group is seeking a Data Engineering & Analytics Intern to help build their next-generation data platform, focusing on developing a robust datalake within Microsoft Fabric and leveraging that data to create powerful Power BI dashboards to turn raw data into actionable insights and build a data-driven culture.
Requirements
- Strong Python Proficiency: Demonstrated experience using Python for data manipulation, scripting, and automation (familiarity with libraries like Pandas is essential).
- Advanced SQL Skills: Ability to write complex queries, perform data transformations, and understand database and data warehousing concepts.
- Power BI Experience: Proven ability to build reports, create data models, and write DAX (Data Analysis Expressions) for complex calculations.
- Understanding of ETL/ELT: Knowledge of data pipeline architecture and the principles of Extract, Transform, Load (ETL) and/or Extract, Load, Transform (ELT).
- Data Modeling Concepts: Familiarity with data modeling techniques (e.g., star schema) to structure data for efficient and accurate analysis.
- Direct experience with Microsoft Fabric or Azure data services (e.g., Azure Data Factory, Synapse Analytics).
- Familiarity with version control systems (e.g., Git).
Responsibilities
- Datalake Development: Design, build, and maintain data ingestion pipelines within the Microsoft Fabric environment to populate the new datalake from various company data sources.
- Data Transformation: Author robust data cleansing, validation, and transformation logic using Python and SQL to ensure high standards of data integrity and reliability.
- BI Dashboard Creation: Collaborate with business stakeholders to gather requirements, then design, develop, and deploy intuitive and accurate Power BI dashboards and reports.
- Process Documentation: Create and maintain clear documentation for all data sources, transformation logic, data models, and BI reports to ensure long-term maintainability (in line with ITIL best practices).
Other
- Currently pursuing or recently graduated with a degree in Computer Science, Data Science, Information Systems, or a related field.
- Knowledge of REST APIs for data extraction.
- Basic understanding of corporate accounting.
- Excellent problem-solving and analytical skills.
- Strong verbal and written communication skills are important.
