Search jobs > Toronto, ON > App bi ssis and ssrs

Power APP, BI & SSIS and SSRS at $65 to $75 per hour

eSMART INNOVATIONS
Toronto, Ontario, Canada
$65-$75 an hour
Full-time

The Power APP and .NET helps to drive critical business decisions by enhancing the USER INPUT FORMS and reporting infrastructure, taking ownership of various data sets and data elements, designing, managing, and deploying data systems, reports, and dynamic dashboards, as well as training users in these systems and the use of reports.

This position is responsible for extracting and grouping data from multiple sources, manipulating, and validating data, and conducting root cause analysis.

The individual will be responsible for ensuring the accuracy and completeness of required reporting using the database and reporting tools.

Job Function :

  • Design, build, and implement various Power APP FORMS to drive data input and reporting packages
  • Working with various multifaceted databases to analyze and report all aspects of the data.
  • Create and maintain Power APP and BI dashboards and underlying datasets
  • Design and implement data validation processes
  • Create and maintain dataset documentation including requirements, design and user manuals
  • Understand and analyze the data / reporting presented to answer any questions as well as make necessary amendments as required
  • Identify and implement ways to automate recurring reports and gradually phase out the use of manual reports and database updates
  • Generate and monitor automated reporting, adding controls and forms
  • Develop and write accurate and efficient queries to extract and integrate data from multiple database sources
  • Work with the internal and external business users to perform analysis and reviews on new reporting formats and / or proposed changes to reporting requirements
  • Work in conjunction with other internal teams on collaborative projects, including data analytics initiatives

Skills :

  • Power APP and .NET and BI Report development in both Cloud Service & On-prem Server
  • Should have knowledge to understand / develop / debug complex DAX queries in Power BI
  • Should have expert knowledge on SQL queries
  • Should have Power APP and .NET Admin knowledge
  • Connecting data sources, importing data, and transforming data for Business intelligence
  • Expert in using advanced-level calculations on the data set
  • Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI
  • Building Analysis Services reporting models
  • Developing visual reports, and dashboards using Power BI desktop & PBI Report Builder
  • Analytical thinking for translating data into informative reports and visuals
  • Responsible for design methodology and project documentaries
  • Should be able to develop tabular and multidimensional models that are compatible with standards
  • Qualifications :
  • SQL Server
  • SQL Server
  • Familiarity with the ASP.NET framework, SQL Server and design / architectural patterns (e.g. Model-View-Controller (MVC)
  • 5 years of development experience using C# .NET
  • Familiarity with architecture styles / APIs (REST, RPC)
  • Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5 / CSS3
  • DAX, M, PowerShell, and T-SQL
  • Power APP, Power BI Dataflows, Tabular Editor, DAX Studio,
  • Power BI Service architecture design and administration
  • Data modelling using the Kimball methodology
  • 2 days ago
Related jobs
eSMART INNOVATIONS
Toronto, Ontario

NET helps to drive critical business decisions by enhancing the USER INPUT FORMS and reporting infrastructure, taking ownership of various data sets and data elements, designing, managing, and deploying data systems, reports, and dynamic dashboards, as well as training users in these syste...

S.i. Systems
Toronto, Ontario
Remote

X Senior Data Engineer to build data solutions and migrate SSIS packages from legacy systems to MuleSoft. Permanent Opportunity, % Remote - Must be able to work PST hours. Hands-on working experience with. ...

Services de Gestion Quantum Ltée
Mississauga, Ontario

If this is you, please apply immediately! We have the following positions available immediately!General Labourers:- Previous work experience working with machineries - Ability to lift up to 40 lb - Comfortable working in a fast-paced environment- Keen eye for detail - Ability to stand/walk throughou...

TalentSphere Staffing Solutions
Toronto, Ontario

Candidates must have the ability to work any shift and be willing to work in a rotational shift pattern. Strong candidates will have initiative, effectively work as part of a team with minimal supervision and must have good communication skills. The Production Mechanic will ensure the efficient and ...

S.i. Systems
Toronto, Ontario
Remote

Intermediate Field Support Technician with Desktop, Network and Mobility experience to support both in-person and remote end-users at an onsite camp, working a 14 days on / 14 days off rotation. Support Dell Windows 10, O, and company applications (in-person and remote) . Assist network techs, manag...

Astra North Infoteck Inc.
Toronto, Ontario

Ability to author technical and operational management documentation including design and support docs, operational runbooks, internal knowledge base articles, etc Secondary Skills • Experience of Windows Modern Management (Intune, Autopilot, Windows Virtual Desktop, etc) • Desktop/Laptop Hardware ...

Astra North Infoteck Inc.
Toronto, Ontario

To develop and enhance existing reporting and dashboards using Power BI and Tableau. Would require Python development too and should be able to interact with the Azure Databricks platform. Microsoft Power BI, Tableau, Python, JIRA, Confluence. Azure Databricks, Git Hub and Alteryx. ...

S.i. Systems
Toronto, Ontario

Gather functional and non-functional requirements; define, design and develop solutions utilizing the Microsoft Dynamics CRM configuration tools and/or Power Platform development tools like Power App and Power Automate. Communicate assignment status in a timely and clear fashion to the appropriate m...

Scotiabank
Mississauga, Ontario

Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capit...

Extreme Reach
Toronto, Ontario

Experience in using multiple OOTB Connectors with Power Apps and Power Automate, and ability to create custom connectors for Power Apps and Power Automate. Collaborate with IT and other teams to integrate PowerApps with existing business systems and applicationsIn-depth knowledge of Office 365 suite...