Filter these job results to find a perfect match.

  • Keywords can include skills or a job number. If using multiple keywords, insert ‘or’ or ‘and’ between for best results (e.g. Java or Oracle)
  • Advanced Options...
  • X

BI Architect / Analyst / Developer

  • Location: Bristol, PA
  • Start Date: 2/8/2024
  • Job ID: 24-00088
  • Posting Date: 2/8/2024
  • Job Type: Direct Placement
Continue to apply for this job >
SCOPE 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 SSAS , 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
Posted by Aaron Goldblatt
Technical Resource Manager
(800) 821-4644 x

why-work-with-edi