Data Analyst Porto

Data Analyst
Porto
Porto, Porto District, Portugal

Social network you want to login/join with:

We are seeking a skilled data analyst with expertise in data integration and modeling, as well as proficiency in SQL and DAX. The successful candidate will be pivotal in transforming raw data into insights, enabling informed
- making across the organization. The role focuses on building, maintaining, and improving data models and business reports. We are looking for someone with a
- oriented mindset, capable of adapting to different business realities and providing solutions for various customer lifecycle scenarios.

Academic background

Bachelor’s Degree in Information Systems, Management, Engineering, or similar.

Technical skills:

SQL, Python, Power BI

How You Will Make An Impact

Transform raw data into structured information, analyze data to drive strategic decisions, enhance analytical and reporting functions, and supervise performance and quality assurance processes.

Responsibilities include:

1. Data Source Integration:

• Establish connections to various data sources, including databases, monitoring tools, CRM systems, and cloud platforms using APIs or custom connectors.
• Configure API connections to extract, transform, and load data from external sources into internal databases.
• Set up, build, and maintain production data pipelines.

• Design and implement robust data models to support analytical reporting requirements.
• Utilize Power Query and M language for data transformations, cleansing, and enrichment.
• Develop descriptive, prescriptive, and predictive models.

• Create datasets through ETL processes, ensuring data is clean, accurate, and
  - ready.
• Translate complex data sets into clear visualizations to communicate insights effectively.
• Design and build interactive dashboards and reports, especially in Power BI.

• Implement
  - based access controls and data protection measures.
• Write and optimize complex DAX queries for efficient data retrieval.
• Develop automated workflows and macros to streamline data management tasks.