Software Developer 7802-0914
Posted on :
08-08-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
HM Note: This hybrid role is three (3) days in office
Description:
- Create custom reports as required applying Microsoft Technologies including PowerBI
- Develop modify and debug SQL scripts in Microsoft SQL Server.
- Provide realistic work estimates to support project planning; capture business requirements and update business rules based on the requirements
- Use structured methodologies design best practices implement code that is of quality and clearly documented. The application should function as required without any defects.
- Conduct testing integration and deployment of the developed changes across the environment
- Review analyze and recommend solutions to any defects discovered in production
- Fully document all developed code and transition in a steady state to a fulltime resource.
Skills
Experience and Skill Set Requirements
Technical Skills: 35%
- 10 years of experience with developing code in SQL and Azure SQL TSQL
- Indepth knowledge of on premise SQL Server
- Demonstrated experience with power query/power pivot and being able to combine datasets from different sources
- Demonstrated experience with OnPremise data gateway
- Demonstrated experience and nbsp;with PowerBI and nbsp;and PowerBI and nbsp;best practices
- Demonstrated experience in enabling rolebased security in the reports by restricting access to information (recordbased access) and reports
- Demonstrated experience with deployment of Report into Azure infrastructure.
- Demonstrated ability to translate complex business requirements into technical solutions and nbsp;
- Analytical mind with a problemsolving aptitude and nbsp;
- Experience with and nbsp;UI Design Principles is an asset
- Familiar with Azure Streaming Analytics SQL Azure Event Hub
- Familiar with Data Lake Store (Gen 2) Data Factory
- Familiar with SSAS Partitioning
Design and Development Experience: 35%
- 10 years of technical data warehousing experience with a focus in the design and development of Business Intelligence
- Experience with Azure Analysis Services / SSAS (tabular/multidimensional) SQL Server Reporting Services (SSRS) and Power BI
- Experience with end to end management of the Software Development Life Cycle (SDLC)
- Demonstrated experience in design and data modeling of data warehouse (e.g. dimensional modeling) data cubes tabular models to support reporting both adhoc and canned reports.
- Demonstrated experience in design and development of data models for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) environments based on industry best practices.
- Demonstrated experience in design and development of visualizations for various reports/dashboards including near realtime to be shared with both B2B and B2C
- Demonstrated experience in building and deploying Mobile dashboards
- Familiar with and nbsp;design and development of ETL (Extract transform load) processes and validating data sources
Communication Skills: 20%
- Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
- Writing Business Requirements Document
- Ability to work with minimal supervision in an agile environment be an effective communicator with other team members and the business owners.
- A demonstrated team player with a proven track record for meeting deadlines
- Demonstrated experience in creating of conceptual logical and physical data documentation for knowledge retention and transfer.
Industry Experience: 10%
- Experience in working on multiyear projects
- Experience with building enterprise level reporting solutions that protect highsensitive information
- Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM architecture gating) and nbsp;an asset
Must Haves:
- 10 years of experience with developing code in SQL and Azure SQL TSQL
- Demonstrated experience with power query/power pivot and being able to combine datasets from different sources
- Demonstrated experience and nbsp;with PowerBI and nbsp;and PowerBI and nbsp;best practices
- 10 years of technical data warehousing experience with a focus in the design and development of Business Intelligence
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
