Lead Data Architect - 1886890

Design, develop and manage Cloud based (AZURE) in-house data warehouse, reporting and dashboard platforms, integrations, and interfaces between D365, legacy data and 3rd 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, application of systems analysis and computer technology skills, working in a senior individual contributor role.

End-to-end development of in-house ETL, data warehouse, reporting, and dashboard platforms, with a focus on research, implementation, and adherence to industry best practices. Under the guidance of the Vice President of IT Applications and Applications Manager, lead the creation and documentation of design specifications for databases and programs, aligning with established standards. Ensure the seamless operation of existing applications, providing ongoing support, troubleshooting, and implementing enhancements as needed. Overall, contribute to the innovation and sustained efficiency of our data solutions.

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.

Requirements:

Bachelors degree in computer science or equivalent job experience in the field.

The Power BI architect / developer should be familiar withdata science, business intelligence, and data analytics.He/she should have prior knowledge ofdata integration, data warehousing, modeling, business intelligence,and data visualization / presentation concepts.

• Comprehensive understanding of Microsoft Azure Data Platform, covering Azure Synapse, Azure Data Factory, Azure SQL Database, and legacy Microsoft SQL Server technologies such as Database Engine, SSIS, SSRS, and SSAS
• 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 and associated ETL processes 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:

• Familiarity with data governance, master data management, metadata management, and related processes
• 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
• Develop semantic layer using Power BI and other tools as needed by creating tables relationships, measures, KPIs, and row level security.
• 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
• 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