Staff Analytics Engineer

• Design and implement scalable and automated processes for data collection, validation, reporting, and analysis using Python and SQL.
• Develop, test, and document complex SQL queries, stored procedures, and robust ETL/ELT processes to support Business Intelligence and advanced analytics initiatives.
• Extrair, transform and analyze data from multiple sources, consistently ensuring data integrity and high quality.
• Build and maintain interactive dashboards and reports in Power BI, ensuring efficiency, scalability, and significant business impact.
• Collaborate effectively with cross-functional teams and influence data-driven decision-making throughout the organization.
• Define and document clear reporting requirements, data governance processes, and validation methodologies.
• Provide strategic recommendations based on deep data analysis, proactively identifying trends and business opportunities.
• Offer technical support and troubleshooting for existing Power BI reports and other BI tools, continuously identifying areas for improvement.
• Mentor and provide technical guidance to junior analysts, fostering best practices in data visualization, SQL, and Python optimization, and analytical problem-solving

• 5+ years of experience working with data analytics, Business Intelligence, or data engineering roles.
• Advanced SQL skills, including extensive experience with query optimization, stored procedures, and performance tuning for large datasets.
• Proven expertise in Python for data manipulation, analysis, and process automation (e.g., Pandas, SQLAlchemy).
• Strong hands-on experience with Power BI, including advanced dashboard creation, data modeling, and interactive visualizations.
• Must have strong knowledge and practical experience with Microsoft Azure services for data (e.g., Azure Data Lake, Azure Synapse Analytics, Azure Data Factory). Experience with GCP is a plus.
• Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT best practices.
• Experience mentoring and supporting junior team members, fostering a culture of continuous learning and development.
• Strong experience in data storytelling, effectively presenting complex insights to both technical and non-technical stakeholders.
• Demonstrated ability to collaborate effectively with executives, engineers, and business teams to translate data insights into actionable strategies.
• Advanced English (written and spoken).

• Collaborative Environment: We value a sense of community where ideas are shared, and achievements are celebrated as a team.
• Work from Anywhere: Enjoy the freedom and flexibility to work from wherever you feel most productive and comfortable.
• Global Connection: An opportunity to interact with people from different countries and cultures, expanding your network and worldview.
• Physical Health Support: Through TotalPass and Mediquo, we provide resources and programs, and telemedicine dedicated to your physical well-being.
• Mental Health Care: Team Care provides initiatives and actions to support your emotional and mental balance in daily life.

DBServices Portugal