The company is seeking a Data Analyst to collect, process, and analyze data to support informed business decisions by identifying trends, developing reports, and creating visualizations that translate complex data into actionable insights.
Requirements
- Proficient in Power BI, DAX, SQL, and Power Query M.
- Advanced Microsoft Excel skills, including macros and VBA.
- Strong experience in Python for data analysis and transformation.
- Understanding of data warehousing concepts and data modeling (star/snowflake)
- Experience with Microsoft Fabric Warehouse, Databricks, or other modern data platforms.
- Familiarity with medallion architecture for scalable data refinement.
- Experience using GIS software (e.g., ArcGIS, QGIS, or equivalent) for spatial analysis and map-based reporting.
Responsibilities
- Develop and maintain impactful dashboards and reports using Power BI for business performance monitoring and decision support.
- Write advanced DAX measures and Power Query (M language) transformations to enhance report functionality and optimize performance.
- Perform thorough data analysis, identifying trends, anomalies, and opportunities using tools such as Python (Pandas, NumPy, Seaborn) and Excel (including macros and VBA programming).
- Conduct spatial data analysis and mapping using GIS tools (ArcGIS, QGIS) to support location-based business use cases.
- Support implementation of data warehousing concepts, including dimensional modeling and SQL-based analysis.
- Support ETL/ELT pipelines in collaboration with cross-functional teams, ensuring scalable and accurate data ingestion.
- Monitor data pipelines and proactively resolve data integrity or quality issues.
Other
- detail-oriented and analytical
- work closely with cross-functional teams
- Document data models, definitions, processes, and best practices to support governance and enable self-service analytics.
- Partner with business stakeholders to understand data needs and translate them into actionable insights and reports.
- Bachelor’s degree in business administration, economics, management information systems, or related field.
