This role is for one of the Weekdays clients
Key Responsibilities:
- Dashboard Development and Maintenance:
- Design develop and maintain advanced dashboards using Power BI or Tableau ensuring they meet high standards of quality user experience and functionality.
- SQL Query Optimization:
- Write and optimize complex SQL queries to facilitate efficient data extraction transformation and loading (ETL) processes.
- CrossFunctional Collaboration:
- Partner with finance marketing and customer analytics teams to gather requirements and translate business needs into analytical and visual solutions.
- Data Analysis and Insights:
- Conduct indepth analyses of data to derive actionable insights and provide recommendations. Present these findings through dynamic storytelling using dashboards and reports.
- Data Integrity and Consistency:
- Collaborate with technical teams to ensure the integrity and consistency of data across systems and maintain highquality data standards.
- Data Modeling and Scalability:
- Maintain enhance and optimize data models to ensure scalability and robust performance.
- Knowledge Sharing and Training:
- Develop best practices documentation and provide training to endusers on effective dashboard usage.
- Process Improvement:
- Stay updated on the latest advancements in Power BI SQL and related tools implementing new features to improve processes and outcomes.
Basic Qualifications:
- Experience: 45 years of relevant experience in data analytics focusing on Power BI and SQL.
- Technical Expertise: Proficiency in advanced SQL including complex joins common table expressions (CTEs) and stored procedures.
- Domain Knowledge: Strong background in finance analytics marketing analytics or customer journey mapping.
- Data Visualization Skills: Expertise in designing dynamic interactive dashboards and reports using Power BI.
- ProblemSolving Ability: Analytical and detailoriented approach to handling complex data landscapes.
- Communication Skills: Excellent written and verbal communication for effective stakeholder engagement.
Preferred Qualifications:
- Advanced degree in Data Science Computer Science Finance or a related field.
- Proficiency in DAX queries and creating calculated columns/measures in Power BI.
- Familiarity with Python or R for advanced analytics and predictive modeling.
- Knowledge of cloud platforms like AWS Azure or GCP for managing data storage and analytics pipelines.
- Experience in predictive analytics and statistical modeling.
Key Skills:
- Technical Tools: Power BI Tableau SQL (advanced) DAX Data Modeling ETL Tools Python/R (optional).
- Domain Expertise: Finance Analytics Marketing Attribution Campaign Effectiveness Customer Journey Mapping.
- Soft Skills: Stakeholder Management Data Storytelling Collaboration and Teamwork.
sql,extract, transform, load (etl),dax,marketing attribution,etl tools,stakeholder management,r,campaign effectiveness,data modeling,finance analytics,customer journey mapping,teamwork,power bi,data storytelling,python,tableau,collaboration