RQ09762 Solutions Designer Intermediate

Responsibilities

Undertakes the design of hosting technology solutions based on the client s service specifications standards policies best practices and cost models in order to meet client application business requirement and project/initiative deliverables.

General Skills:

Knowledge of integrated networking technologies mainframe midrange server enterprise storage and SAN and personal computer system technologies

Knowledge of related best practices OPS directory/messaging standards standard facilities infrastructure/architecture management facility service delivery processes infrastructures policies procedures and direction cost models and procurement processes

Ability to gather client business requirements; corporate I&IT information mandates client information technology strategic plans environment and standards

Ability to participate in the development of solutions and provide advice on short/long term solution service development activities.

Knowledge of leading edge technologies design criteria security and recovery procedures preparation of technical specifications for installation testing and performance of integrated multi-services systems; assess performance and capacity of existing system making recommendations for improving performance and develop technical documentation.

Experience planning migrating implementing and sustaining large complex system development projects

Knowledge of technology developments trends and new products to evaluated application to client short and long term technology requirements.

Basic knowledge of project management methodology (e.g. PMBOK) analytical tools and processes.

Conceptual and analytical skills to assess and evaluate client needs and c o n d u c t cost/benefit analyses for new technology requirements in planning and designing solutions.

Experience designing and developing large complex highly available mission critical server applications

Experience with systems evaluation to assess conditions technical performance and capacity of existing systems and determine need and feasibility of expansion renovation or replacement.

Excellent analytical problem-solving and decision-making skills verbal and written communication skills interpersonal skills and negotiation skills teamwork skills A team player with a track record for meeting deadlines

Requirements

Experience and Skill Set Requirements

Development Skills

• 10 years of experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics data modeling & data mining reporting report conversion and data cleansing.
  
• Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service (must have)
  
• Converting pl/SQl package into databricks code and have some basic understanding on oracle cloud db.(must have)
  
• Design and develop BI dashboards and reports based on business requirements
  
• Implement maintain and support BI solutions in Microsoft and other BI platforms (must have)
  
• Complete committed backlog and sprints within the agreed upon timeframe
  
• Curate data from multiple data sources for an efficient presentation in an enterprise environment
  
• Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy usability and value
  
• Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives
  
• Document As Built reports and all data transformations deployed to production
  
• Take ownership of end-to-end development of each dashboard and report being developed
  

Technology Skills

• Experience with cloud platform like Azure and working knowledge for cloud migration (must have)
  
• Experience with Microsoft Azure data analytics tools such as Azure Data Factories Azure Databricks Azure Synapse (must have)
  
• Expertise in advanced prediction and prescriptive analytics including machine learning algorithms designing experiments fraud detection
  
• Internally motivated and adaptable able to work proficiently both independently and in a team environment.
  
• Managing PowerBI workspaces report access report deployment developing best practices in an enterprise environment
  
• Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs
  
• Advance knowledge of writing complex SQL queries.
  
• Strong Power BI experience (Power Query DAX Power Bi Services)
  
• Experience with Microsoft BI and Azure stack
  
• Able to troubleshoot BI reporting and analytic business needs and provide solutions for issue resolution
  

Soft Skills

• Strong communication skills; both written and verbal
  
• Ability to develop and present new ideas and conceptualize new approaches and solutions
  
• Excellent interpersonal relations and demonstrated ability to work with others effectively in teams
  
• Demonstrated ability to work with functional and technical teams
  
• Demonstrated ability to participate in a large team and work closely with other individual team members
  
• Proven analytical skills and systematic problem solving
  
• Strong ability to work under pressure work with aggressive timelines and be adaptive to change
  

OPS/Public Sector Exp

Must Haves:

• Demonstrated experience in Azure Databricks Delta Lake Azure Storage ADF Azure Analysis Service
  
• Converting pl/SQl package into databricks code and have some basic understanding on oracle cloud db
  
• Implement maintain and support BI solutions in Microsoft and other BI platforms
  
• Experience with cloud platform like Azure and working knowledge for cloud migration
  
• Experience with Microsoft Azure data analytics tools such as Azure Data Factories Azure Databricks Azure Synapse