Address
Form of workSCOPE OF POSITION
Design, develop and manage Cloud based (AZURE) in-house data warehouse, reporting and dashboard platforms, integrations, and interfaces between D365, legacy data and 3 rd party vendor software systems. Analyze, design, program test, document and implement data management and reporting solutions using industry best practice, new and/or existing data visualization tools, the application of systems analysis and computer technology skills, working in a senior individual contributor role.
BASIC FUNCTIONS
Develop in-house data warehouse, reporting, and dashboard platforms business solutions from research through implementation, and best industry practice under the direction of the Vice President of IT Applications and Applications Manager, based upon business requirements, develop and document design specifications for data bases and programs based on established standards. Support existing applications, ensuring their satisfactory operations.
RESPONSIBILITIES
65% review, analyze, and modify or create data warehouse technologies, computer applications, including design, coding, testing, debugging and documenting programs.
35% perform problem analysis and in-depth studies or proposals in response to business requirements and issues. Performs other data, data warehouse, and technology related duties as assigned by management.
MUST REQUIREMENTS
Bachelor's degree in computer science or equivalent job experience in the field.
The Power BI architect / developer should be familiar with data science, business intelligence, and data analytics. He/she should have prior knowledge of data integration, data warehousing, modeling, business intelligence, and data visualization / presentation concepts.
AZURE Data Factory (ADF) or SQL Server Integration Services (SSIS)
Convert business requirements into technical specifications and decide timeline to accomplish.
Organize, construct, and maintain a data warehouse platform as the single source of the truth for Data focusing on the prominent functions of the data warehouse as:
Data Extraction / Data Integration
Data Cleaning
Data Mapping / Data Transformation
Data Loading / Refreshing
PREFERRED REQUIREMENTS
Understand business requirements in the BUSINESS INTELLIGENCE (BI) context and design data models to transform raw data into meaningful insights.
Create dashboards and interactive visual reports using Power BI
Identify key performance indicators (KPIs) with clear objectives and consistently monitor.
Analyzing data and present data through reports that aid decision-making
Convert business requirements into technical specifications and decide timeline to accomplish
Create relationships between data and develop tabular and other multidimensional data models
Chart creation and data documentation explaining algorithms, parameters, models, and relations
Design, develop, test, and deploy Power BI scripts and perform detailed analytics
Perform DAX queries and functions in Power BI
Analyze current ETL process, define and design new systems
Data warehouse development and work with , SSIS, and SSRS
Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
Create customize charts and custom calculations as per requirements
Design, develop and deploy business intelligence solutions as per needs
SQL querying for best results, use of filters and graphs for better understanding of data
Work with users and team members at all levels for performance improvement and suggestions Microsoft SQL Server
Complex Query generation
Stored Procedure / View Creation / Executions
SQLAgent
Extended SQL Server toolset – SSRS / SSIS / SSAS
