Job Description

SKILLS AND EXPERIENCE REQUIRED:


5 +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. Experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service Design and develop BI dashboards and reports based on business requirements Implement, maintain, and support BI solutions in Microsoft and other BI platforms
Nice to have:


Experience working with a CRM system would be an asset. Experience with Transfer Payment Model would be an asset.
Description:

Responsibilities:

Required to translate technical systems specifications into working, tested applications.
This includes.


developing detailed programming specifications writing and/or generating code compiling data-driven programs, maintaining, and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.
General Skills:


Experience in programming and analysis; specialized software package support at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle Experience in structured methodologies for the development, design, implementation and maintenance of applications Experience in design, code, test, debug and document applications Experience in the use of object and/or third generation language development tools Experience in one or more programming languages Experience in application design, latest design patters, deployment and troubleshooting Experience with relational and hierarchical database technologies Experience in the use of information retrieval packages using query languages Experience with one or more communications protocols Experience in structured methodologies for the design, development, implementation and maintenance of applications Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines

Desirable Skills:

Knowledge and experience with programming Internet-ready applications Knowledge and experience in rapid application development (RAD) methodologies Knowledge and understanding of Information Management principles, concepts, policies and practices Experience with middleware and gateways Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging Ability to provide post-implementation support and resolve any post-implementation technical issues Experience conducting design walkthrough sessions with project team Knowledge and understanding of Accessibility with Disability Act and related regulations and standards Ability to provide user and system documentation as required Experience in conducting impact assessments on Oracle E-Business application customizations and extensions. Strong conversion experience in Account Receivable Collection modules Strong programming skills in Oracle database, PL/SQL, SQL, XML, Unix shell scripts and Oracle Data Integrator Proved business knowledge of General Ledger, Accounts Receivable, Collections, Accounts Payable and Inventory Modules of Oracle E-Business Great knowledge of Oracle E-Business table structure related to GL, AR, Collections, AP, INV and FND Strong knowledge of SQL tuning and using partition tables Demonstrated experience and understanding of data warehouse, ETL methodologies and OBIEE Demonstrated work experience on Java and Oracle Application Development Framework (ADF) will be a great asset Strong verbal and written communication skills and leadership abilities to be able to oversee the quality assurance of the project from technical perspective
Skills:

Experience and Skill Set Requirements:

Development Skills (40/100)

5 +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. Experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service Design and develop BI dashboards and reports based on business requirements Implement, maintain, and support BI solutions in Microsoft and other BI platforms 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 (35/100)

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 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- (20/100)

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

Public Sector Experience (5/100)

Experience working with a CRM system would be an asset. Experience with Transfer Payment Model would be an asset. * Prior public sector experience would be an asset