Data Analyst

Job Title: Data Engineering and Power BI Specialist (Hybrid Role)

Candidate Value Proposition

• The successful candidate will have the opportunity to gain visibility at the highest leadership levels, providing key reporting to Executive Leadership.
• This role offers excellent networking opportunities and exposure across all levels of the organization, along with the chance to work with cutting-edge, latest technology.

We are seeking a versatile professional to join a high-performing team in a leading Global Wealth and Asset Management Data Office. This hybrid role offers the opportunity to work with the latest technologies and provides growth and exciting challenges across a wide array of business areas. We require a candidate with expertise in Power BI, Python, SQL, and Spark.

The responsibilities of this role are divided equally between data engineering and Power BI development:

Key Responsibilities

• 50% Data Engineering: Utilize skills in Python, SQL, and Spark to support various data engineering projects, ensuring the development of robust data pipelines and efficient data processing.
• 50% Power BI Development: Use Power BI expertise to create insightful, interactive, and visually appealing dashboards, providing valuable business intelligence solutions.

Candidate Requirements / Must-Have Skills

1. Proficiency in Power BI: Advanced knowledge of Power BI for creating dashboards, reports, and visualizations.
2. 2+ Years of Experience in Data Modeling: Expertise in creating and optimizing data models to enhance performance and usability.
3. DAX (Data Analysis Expressions): Strong knowledge of DAX for building complex calculations and aggregations.
4. Power Query / M: 5+ years of experience with Power Query for data transformation and cleaning.
5. SQL Expertise: Ability to write complex SQL queries for data retrieval and manipulation from various databases, with a minimum of 5 years of experience.
6. ETL Processes: Strong understanding of ETL (Extract, Transform, Load) processes and tools for integrating data from various sources.
7. Programming Language Proficiency: Proficiency in programming languages like Python, including an understanding of data types, variables, loops, conditionals, and error handling. Familiarity with Python’s standard library and commonly used modules.
8. Data Warehousing Knowledge: Familiarity with data warehousing concepts and practices.
9. Project Management Experience: Experience leading BI projects, including planning, execution, delivery, and managing/maintaining the project backlog with stakeholders.

Nice-to-Have Skills

1. Microsoft Certified: Data Analyst Associate or relevant Power BI certifications to demonstrate proficiency and expertise.
2. Power Automate Experience

Required Soft Skills

• Problem-Solving: Strong ability to troubleshoot and resolve technical issues related to data and reporting.
• Communication: Excellent verbal and written communication skills to effectively convey complex information to both technical and non-technical stakeholders.
• Collaboration: Ability to work collaboratively with cross-functional teams, including IT, business analysts, and stakeholders.
• Attention to Detail: High attention to detail to ensure accuracy and quality in reports and dashboards.
• Adaptability: Ability to adapt to new tools, technologies, and methodologies as required by the organization.
• Data Analysis: Strong analytical skills to interpret data and provide actionable insights.

Education

• Bachelor’s Degree Required: Preference for degrees in a technical field such as computer science, computer engineering, or a related field.