- Createcustom reports as required applying Microsoft TechnologiesincludingPowerBI
- Developmodify and debug SQL scripts in Microsoft SQLServer.
- Providerealistic work estimates to support project planning; capturebusiness requirements and update business rules based on therequirements
- Usestructured methodologies design best practices implement code thatis of quality and clearly documented. The application shouldfunction as required without anydefects.
- Conducttesting integration and deployment of the developed changes acrosstheenvironment
- Reviewanalyze and recommend solutions to any defects discovered inproduction
- Fullydocument all developed code and transition in a steady state to afulltimeresource.
Requirements
TechnicalSkills
- 10years of experience with developing code in SQL and Azure SQLTSQL
- Indepthknowledge of onpremises SQLServer
- Demonstratedexperience with power query / power pivot and being able to combinedatasets from differentsources
- Demonstratedexperience with OnPremises datagateway
- Demonstratedexperience with PowerBI and PowerBI bestpractices
- Demonstratedexperience in enabling rolebased security in the reports byrestricting access to information (recordbased access) andreports
- Demonstratedexperience with deployment of Report into Azureinfrastructure.
- Demonstratedability to translate complex business requirements into technicalsolutions
- Analyticalmind with a problemsolving aptitude
- Experiencewith UI Design Principles is anasset
- Familiarwith Azure Streaming Analytics SQL Azure EventHub
- Familiarwith Data Lake Store (Gen 2) DataFactory
- Familiarwith SSASPartitioning
Designand DevelopmentExperience
- 10years of technical data warehousing experience with a focus in thedesign and development of BusinessIntelligence
- Experiencewith Azure Analysis Services / SSAS (tabular / multidimensional) SQLServer Reporting Services (SSRS) and PowerBI
- Experiencewith end to end management of the Software Development Life Cycle(SDLC)
- Demonstratedexperience in design and data modeling of data warehouse (e.g.dimensional modeling) data cubes tabular models to supportreporting both adhoc and cannedreports.
- Demonstratedexperience in design and development of data models for OLTP(Online Transaction Processing) and OLAP (Online AnalyticalProcessing) environments based on industry bestpractices.
- Demonstratedexperience in design and development of visualizations for variousreports / dashboards including near realtime to be shared with bothB2B andB2C
- Demonstratedexperience in building and deploying Mobiledashboards
- Familiarwith design and development of ETL (Extract transform load)processes and validating datasources
CommunicationSkills
- Strongverbal and written communication skills that enable to effectivelycommunicate ideas and concepts. Strong Interpersonal andnegotiationskills.
- WritingBusiness RequirementsDocument
- Abilityto work with minimal supervision in an agile environment be aneffective communicator with other team members and the businessowners.
- Ademonstrated team player with a proven track record for meetingdeadlines
- Demonstratedexperience in creating of conceptual logical and physical datadocumentation for knowledge retention andtransfer.
IndustryExperience
- Experiencein working on multiyearprojects
- Experiencewith building enterprise level reporting solutions that protecthighsensitiveinformation
- Demonstratedknowledge and experience with Public Sector governancemethodologies (e.g. UPM architecture gating) anasset
MUSTHAVES :
- 10years of experience with developing code in SQL and Azure SQLTSQL
- Demonstratedexperience with power query / power pivot and being able to combinedatasets from differentsources
- Demonstratedexperience with PowerBI and PowerBI bestpractices
- 10years of technical data warehousing experience with a focus in thedesign and development of BusinessIntelligence
Il y a plus de 30 jours