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 Data Modeling and Analytics Specialist to enhance our data infrastructure and reporting capabilities. In our current setup, our database is designed using Third Normal Form (3NF) principles to minimize data duplication, prevent anomalies, ensure referential integrity, and simplify data management. The goal is to lay a solid foundation for all future dashboards by refining our data models before we restart the dashboard development process.
While this approach is robust for transactional operations, it has led to fragmented data tables that challenge our analysts when building comprehensive Power BI dashboards. The consultant will be responsible for reviewing existing data models, strategizing improvements, and providing actionable recommendations to optimize our data infrastructure.
Responsibilities:
- Data Model Optimization: Lead the transition from a Third Normal Form (3NF) design to more analytical-friendly data models, such as Star Schema or Data Cubes, to enhance reporting efficiency and dashboard usability.
- Data Integration: Design and implement an intermediate data layer to bridge our transactional database and reporting tools, enabling streamlined data aggregation and integration.
- Problem Solving: Address and resolve issues related to data fragmentation and complex joins, ensuring analysts have access to cohesive and usable datasets for accurate and effective dashboards.
- Solution Research: Explore and apply industry best practices and proven solutions from the past two decades to refine our data modeling approach and tackle common data-related challenges.
- Collaboration: Partner with analysts and stakeholders to understand their reporting requirements and ensure that the redesigned data model meets their needs for efficient and insightful data analysis.
- Performance Improvement: Enhance data structures and ETL processes to boost query performance and overall reporting efficiency, laying a robust foundation for future dashboard development.
Required Qualifications:
- Database Design and Administration: Expertise in MS SQL Server, with a solid understanding of database normalization, indexing, and query optimization techniques.
- Data Warehousing: Proven experience in designing and implementing data warehouses, particularly for real-time analytics and dashboard reporting scenarios.
- Business Intelligence Tools: Extensive experience with Power BI, including proficiency in DAX, Power Query, and setting up effective data models within the platform.
- SQL and ETL Processes: In-depth knowledge of ETL (Extract, Transform, Load) processes, principles, and best practices for data integration and transformation.
- Performance Tuning: Skilled in diagnosing and resolving performance issues in both database environments and Power BI dashboards to ensure optimal efficiency.
- Expertise: We are looking for a seasoned data model design expert, not merely a Power BI developer. The ideal consultant will have a robust background in data modeling and analytics.
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