About the company:
Avenue Code is the leading software consultancy focused on delivering end-to-end development solutions for digital transformation across every vertical. We’re privately held, profitable, and have been on a solid growth trajectory since day one. We care deeply about our clients, our partners, and our people. We prefer the word ‘partner’ over ‘vendor’, and our investment in professional relationships is a reflection of that philosophy. We pride ourselves on our technical acumen, our collaborative problem-solving ability, and the warm professionalism of our teams.
Avenue Code has been believing in and promoting plurality actions for over 10 years, understanding that recognizing differences and fostering a safe environment, employment opportunities, representation, and support are the best ways to promote an increasingly equitable culture.
About the opportunity:
We are seeking a skilled Analytics Engineer with a strong background in data engineering and financial data. This role focuses on designing, building, and maintaining robust data pipelines and models that enable data-driven decisions. The ideal candidate excels in DBT, Airflow, and GCP, with expertise in data architecture, governance, and visualization. If you’re passionate about transforming data into actionable insights and thrive in a collaborative environment, this opportunity is for you.
For this project, it is important availability to work in the los Angeles time zone.
Responsibilities:
- Design and maintain scalable data pipelines and workflows using DBT (Cloud/Core/Command Line) and Airflow.
- Develop and implement data models, data architectures, and governance frameworks to ensure data quality and reliability.
- Create and optimize ETL/ELT processes for financial and business data.
- Perform data validation, ensuring high standards of accuracy, timeliness, and completeness.
- Collaborate with cross-functional teams to develop and monitor key metrics and analytics frameworks.
- Build intuitive dashboards and data visualizations using Looker and Looker Studio to communicate insights effectively.
- Apply advanced SQL and Python expertise within a GCP infrastructure to optimize data solutions.
- Handle complex scenarios such as slowly changing dimensions and snapshots to track historical data changes.
Required Qualifications:
- Solid experience in Analytics Engineering or Data Engineering.
- Proficiency in DBT (Cloud/Core/Command Line), Airflow, and advanced SQL and Python.
- Solid understanding of data architecture, data modeling, data governance, and data quality.
- Experience with data visualization tools like Looker and Looker Studio.
- Strong communication skills and business acumen to align data initiatives with strategic objectives.
- Background in financial data analysis and handling complex data structures like slowly changing dimensions and snapshots.
Nice to Have:
- Experience with tools like Stitch and Census for data integration.
- Expertise in working with financial datasets and related analytics.
- Proven track record of creating scalable and efficient data pipelines within GCP.
- Ability to simplify complex datasets and effectively communicate insights to stakeholders.
Avenue Code reinforces its commitment to privacy and to all the principles guaranteed by the most accurate global data protection laws, such as GDPR, LGPD, CCPA and CPRA. The Candidate data shared with Avenue Code will be kept confidential and will not be transmitted to disinterested third parties, nor will it be used for purposes other than the application for open positions. As a Consultancy company, Avenue Code may share your information with its clients and other Companies from the CompassUol Group to which Avenue Code’s consultants are allocated to perform its services.
#Li-Remote