NOTE: This position is currently listed as "Onsite".

Must-haves:

• Demonstrated experience with data analytics platforms including Microsoft Azure Synapse, Microsoft Data Factory, Databricks
• Demonstrated experience with data warehouses including Microsoft SQL Server, Snowflake, Databricks Deltalake, Microsoft Azure Data Lake
• Demonstrated experience with data analytics projects including business intelligence (using Power BI)

Deliverables:

• Design and implement business intelligence data solutions (pipelines, ETLs/ELTs, data warehouse, data lake, data lakehouse)
• Undertake special assignments/sub-projects as assigned.
• Assess, evaluate, and document stakeholder interests.  
• Conduct business requirement sessions and document options and outcomes.
• Prepare and document data analysis findings and data dictionaries.
• Participate in problem analysis and identify opportunities where business intelligence and advanced analytics can be used to support project and/or program objectives.
• Serve as a data analytics subject matter expert on inter-disciplinary project teams and/or as an ad-hoc advisor to deliver data analytics expertise and advice.
• Conduct periodic reviews of developed analytical solutions to identify opportunities for enhancements or evolution.
• Research, prepare and document issues related to data collection and reporting requirements.
• Plan, prepare and deliver demo and training sessions on new Business Intelligence dashboards and reports to all levels of user community.
• Ensure alignment and adherence to IT processes and standards.
• Participate in development and UAT testing and document results.
• Participate in Knowledge transfer.

Skills and Knowledge:

• Proven experience as a Data Engineer/ETL Developer in building Business Intelligence products
• Proven experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop pipelines & Business Intelligence products
• Demonstrated experience with Azure Data Factory, Databricks, Power BI, SQL Query and/or other data query tools
• Demonstrated knowledge and experience of Microsoft Azure ecosystem
• Proven, demonstratable experience in data visualization; working with BI implementation methodologies
• Knowledge of data analysis, data management
• Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
• Excellent verbal and written communication skills, interpersonal and facilitation skills  
• Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology
• Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment

Technical Skills

• Experience as a Data Engineer/ETL Developer in building Business Intelligence products
• Data Interpretation and Insight Generation: Strong ability to interpret data, identify trends and patterns, and generate meaningful insights that support business decision-making.
• Experience with Data Mining Techniques: Proficiency in data mining techniques and methodologies, including clustering, classification, regression, and association rules, to extract valuable information from large datasets.
• Experience in Data Warehousing: Understanding of data warehousing concepts and experience in working with data warehouse technologies.
• •Knowledge of Data Integration Techniques: Skills in integrating data from various sources and formats for comprehensive analysis.
• Proficiency in Data Analytics Tools: Expertise in using data analytics tools such as Python (Pandas, NumPy, SciPy), R, or SAS for complex data manipulation and analysis.

Documentation, Collaboration & Communication Skills

• Clarity in Complex Business Challenges: Ability to bring clarity to complex business issues and articulate business process requirements versus technology solutions effectively.
• Excellent Verbal and Written Communication: Demonstrated excellence in both verbal and written communication, including the ability to convey complex data concepts in understandable terms.
• Interpersonal and Facilitation Skills: Strong interpersonal skills, with an ability to facilitate discussions and consensus among diverse groups.
• Effective Documentation Skills: Proficiency in creating clear and detailed documentation, including reports, guides, and process maps.
• Collaboration with Internal/External Stakeholders: Demonstrated ability to effectively partner with both internal and external stakeholders, fostering productive relationships.
• Teamwork and Cross-Functional Collaboration: Experience in working collaboratively in cross-functional teams, contributing to a cohesive team environment.
• Presentation Skills: Strong presentation skills, capable of delivering insights and findings to both technical and non-technical audiences.
• Conflict Resolution and Negotiation Skills: Ability to resolve conflicts and negotiate effectively, maintaining a focus on business objectives.
• Time Management and Organizational Skills: Demonstrated effective time management skills, with the ability to prioritize tasks and meet deadlines in a dynamic environment.
• Adaptability and Flexibility: Ability to adapt to changing business needs and technology landscapes, maintaining effectiveness in varying environments.
• Stakeholder Management: Experience in managing stakeholder expectations and maintaining open lines of communication throughout project lifecycles.
• Critical Thinking and Problem-Solving: Strong critical thinking skills, with an ability to analyze problems, identify root causes, and develop innovative solutions.