Descrição do trabalho
PURPOSE OF THE JOB:
As a Sr BI Engineer, you will build and scale data models, pipelines, and self-service analytics across the organization and highly loaded database solutions for various businesses cases including reporting, product analytics, marketing optimization and financial reporting.
You’ll focus on developing a reliable aggregation layer and reporting structure that meets growing business needs, enabling teams to access and analyze data independently. And contribute as part of self-organized team of experienced data engineers working in a challenging, innovative environment for our client, creating the foundation for decision-making at a company dealing with billions of events per day.
Investigate, create, and implement the solutions for existing technical challenges. Provide guidance, instruction, direction, leadership to a development team with the purpose of achieving project goals.
- MAIN TASKS AND RESPONSIBILITIES:
- Analyzes scope of alternative solutions and makes decision about area implementation based on his/her experience and technical expertise.
- Leads functional and architectural design of assigned areas. Make sure design decisions on the project meet architectural and design requirements.
- Addresses area-level risks, provides and implements mitigation plan.
- Reports about area readiness/quality, and raises red flags in crisis situations which are beyond his/her AOR.
- Responsible for resolving crisis situations within his/her AOR.
- Consult and perform design reviews to ensure business needs are met.
- Identify and execute risk mitigation and compliance exercises.
- Utilize Business Intelligence tools to build and support dashboards.
- Partner with other team members as well as cross-functional partners to support business processes and system solutions.
- Manage and resolve client issue escalation and systemic improvements.
- Partner with Business Analysts to bring new scalable solutions to business functions.
- Lead validation efforts to ensure data quality.
- Design, develop, and maintain robust data models to support analytical and product data needs across the organization.
- Own and define business KPIs, their measurement plans, data requirements, and reporting.
- Design, develop and implement large scale, high-volume, high-performance data models and pipelines for Data Lake and Data Warehouse.
- Initiates and conducts code reviews, creates code standards, conventions, and guidelines.
- Suggest technical and functional improvements to add value to the product;
- Constantly improves his/her professional level.
- Collaborates with other teams.
- REQUIRED EDUCATION AND EXPERIENCE:
- Must have:
- 8+ years of total experience with 4-5 years of total experience working in business intelligence, data analytics, Data engineering or a similar role.
- University degree in Computer Related Sciences or similar.
- BI Tool Proficiency: Deep knowledge of ThoughtSpot; experience with Tableau/Power BI is a plus.
- Years of hands-on Thoughtspot experience is a must.
- Strong SQL skills and experience with data modeling techniques (e.g., dimensional modeling, 3 Nf, data vault) , data warehousing (ETL/ELT) and performance tuning experience
- Proficiency in programming language Python.
- Experience with modern data warehousing platforms (e.g., Snowflake, DataBricks, Redshift) and knowledge of data visualization tools (e.g., Looker, Tableau).
- Excellent communication skills and experience working with technical and non-technical teams.
- Excellent analytical abilities, problem-solving, communication, and ability to translate business needs into technical solutions.
- Comfortable working in fast paced environment, self-starter and self-organizing.
- English level: C1 or higher (mandatory) – able to communicate fluently with international stakeholders.
- Working hours(mandatory): Lisbon (WET): 14:00 – 00:00 - Alignment with EST working hours (09:00 – 19:00 EST)
- Nice to have:
- Experience with real-time data processing and streaming technologies
- Familiarity with machine learning concepts and their data requirements.
- SKILLS:
- Python (proficiency)
- Strong SQL skills (data modeling, data warehousing, performance tuning)
- Data warehousing platforms (Snowflake, DataBricks, Redshift etc.) and Data visualization tools (Looker, Tableau, etc.)
- Thoughtspot (proficiency)
- Work model: 100% remote - Lisbon (WET): 14:00 – 00:00 - Alignment with EST working hours (09:00 – 19:00 EST)
- Languages: English C1 or higher
- Year of exp: 8+ total with 4-5 years working in BI, data analytics, data engineering or similar.
Client sector: Technology/ Local c