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.
  

Experience and Skill Set Requirements:

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)
  

Skill Set Requirements:

Skill Set:

• 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
  
• Mandatory Requirements: At least 5 years of experience
  
• All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS.
  
• Security Clearance process, levels, roles etc. are subject to change without prior notice. Candidates may be required to undergo revised/new process (or levels) any time prior or during the term of the contract.
  

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.