Responsibilities:
Designand develop data ETL routines to integrate data from disparatesource systems into an integrated business intelligence environmentincluding defining sourcetotarget mappings business rules and otherrequired data transformations
Developdashboards and reports using Microsoft Power BI SSRS or other BItechnologies.
Ensuring the quality of thedata through utilization of process andtechnology
Participation in activelyformulating and maintaining both a data catalog and a datadictionary
Providing data marts and datalakes to support business initiatives
Conductbusiness analysis to define the required data to fulfill onbusiness requirements
Meet with Customers tounderstand business problems and questions exploring options tomodel data driven platforms used for analyzinganswers
Become a trusted partner forCustomers who translates business problems into analysis; thenhelps interpret the analysis into actionablesteps
Actively participate in the designdevelopment and maintenance of complex BI Dashboards ReportsQueries and integrated applications
Manageother resources to complete the development work needed to deliverthe required product to the client
Analyzeand share results with users to ensure content meets businessrequirements; and train users to facilitate adoption andunderstanding of BI reports andtools
Proactively initiate projects andanalysis targeting opportunities for revenue growth risk mitigationand operational efficiency
Provide technicalsupport of the Microsoft PlatformSoftware
Comprehensive data analysis anddesign experience with full knowledge of data warehouse &data mart methodologies as well analysismodeling
Lead solution and design sessionsfor end to end for data integrationefforts
Deliver technical innovations insupport of business growth; progressing ideas from concepts to fullscale implementation with focus on flexibility reuse andoverarchingextensibility.
Qualifications:
* 35years of experience in the Microsoft business intelligence platformincluding SQL Server databases SQL Server Integration ServicesPower BI/SSRS & SSAS and/or Azure CloudServices
* 35 years of building and maintainingdata integration processes
* 23 years supportinglarge scale data integration and ETL processes including dailymonitoring and operational support
* Strongexperience working in data warehousearchitectures
* Experience building formattedpaginated reports using MS SSRS
* Experience withPowerBI dashboard development or experience with one or more BIreporting tools like QlikView/QlikSense Tableau Micro Strategy OpenSource reporting is a plus
* Experience with thePowerBI Cloud Services
* Significant experiencein the design and development of data integration solutions anddata analysis
* Expert in automating dataintegration routines
* Expert in optimization ofdata integration processing and databasedesign
* Expertise in designing and developingdashboards reports analytics and data visualizationsolutions.
* Experience in creating dimensionaldata models across multiple subject areas is aplus
* Strong command of MSExcel
* Experience and familiarity with processesplatforms and stakeholders
* Excellent writtenand oral communication skills
* Excellenttechnical documentation skills
* Ability to workindependently in a fast paced environment with minimum over sight.You would own building a future proof integration architecture tosolve integration needs acrossprojects.
* Balances a variety of competing goalsin a design including project time scope and budget constraints andsystem performance message verbosity and loosecoupling.
powerbi,sql,ssis,ssrs