Business Intelligence Architect

Found in: Appcast Linkedin GBL C2 - 3 weeks ago

Bristol, United States Lenox Corporation Full time

JOB TITLE: BI Architect

TYPE: Full Time

DEPARTMENT: IT

LOCATION: Bristol

REPORTS TO TITLE: VP IT


SCOPE OF POSITION

Design, develop and manage Lenox Cloud based (AZURE) in-house data warehouse, reporting and dashboard platforms, integrations, and interfaces between D365, legacy Lenox 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.


BASIC FUNCTIONS

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 Lenox Corporation's 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.


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.

  • 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 Lenox 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

o Complex Query generation

o Stored Procedure / View Creation / Executions

o SQLAgent

o Extended SQL Server toolset – SSRS / SSIS / SSAS

  • Lead Data Architect

    2 weeks ago

    Bristol, United States Cirrus Group Consulting Full time

    Job DescriptionJob DescriptionDesign, 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...

  • Lead Data Architect

    4 days ago

    Bristol, United States Cirrus Group Consulting Full time

    Job DescriptionJob DescriptionDesign, 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...

  • Enterprise Architect

    2 weeks ago

    Bristol, United States Data-Core System, Inc. Full time

    Job DescriptionJob DescriptionSalary: $150K - $170KData-Core Systems a consulting, services and digital transformation solution provider helping businesses reshape their future with cutting-edge technologies and services, has an immediate opening for a Enterprise Architect in the Consulting Services Division.Responsibilities and Expectations: Document...

  • Qlik Architect/Lead

    2 weeks ago

    Bristol, United States Data-Core System, Inc. Full time

    Job DescriptionJob DescriptionSalary: DOEData-Core Systems a consulting, services and digital transformation solution provider helping businesses reshape their future with cutting-edge technologies and services, has an immediate opening for a Qlik Architect/Lead  in the Consulting Services Division.Desired SkillsetThe ideal Qlik Architect/Lead will have a...

  • OT Security Architect

    1 week ago

    Bristol, United States Trinseo Full time

    OT Security Architect iCIMS Job ID 2024-3160 # of Openings 1 Job Family Information Security Overview Career at TrinseoTrinseo is a different kind of global materials company - at the intersection of people, technology, and customers. We are a world leader in the production of plastics and latex...

  • Enterprise Account Manager

    5 days ago

    Bristol, United States Red Hat Software Full time

    About the job: The Red Hat Enterprise Sales team is looking for an Enterprise Account Executive to join us in Wellington, New Zealand. In this role, you will be responsible for retaining and growing sales within the FSI territory in the New Zealand market, helping our customers and partners make business and IT transformations using Red Hat services and...

  • Staff Accountant

    Found in: Talent US C2 - 2 weeks ago

    Bristol, United States Healthtrax Fitness & Wellness Full time

    POSITION OVERVIEW The Staff Accountant provides accurate and timely financial services to senior management and reports to Financial Planning and Analysis. Scope of accounting work includes 2 Holding companies and 18 subsidiaries. PRIMARY DUTIES AND RESPONSIBILITIES include and are not limited to Record Journal Entries. Reconcile Subsidiary accounts. ...

  • Global Marketing Manager, Engineered Surfaces

    2 weeks ago

    Bristol, United States Trinseo Full time

    Global Marketing Manager, Engineered Surfaces iCIMS Job ID 2024-3117 # of Openings 1 Job Family Business, Sales and Marketing Overview Trinseo is a different kind of global materials company - at the intersection of people, technology, and customers. We are a world leader in the production of...

  • Production Technician

    2 weeks ago

    Bristol, United States iNRCORE LLC Full time

    Job DescriptionJob DescriptionAbout UsiNRCORE, LLC is a world-class manufacturer of custom and catalog magnetic solutions. With employees world-wide, iNRCORE is a growing international partner with Gowanda Components Group and Bicron Manufacturing, to design, manufacture and sell specialty electronic components. For over 70 years iNRCORE has deployed...

  • Quality Control Inspector I

    4 days ago

    Bristol, United States BuildSubmarines.com Full time

    About Us iNRCORE, LLC is a world-class manufacturer of custom and catalog magnetic solutions. With employees worldwide, iNRCORE is a growing international partner with Gowanda Components Group and Bicron Manufacturing, to design, manufacture and sell specialty electronic components. For over 70 years iNRCORE has deployed reliable and intelligent solutions...

  • Production Technician

    7 days ago

    Bristol, United States iNRCORE LLC Full time

    Job DescriptionJob DescriptionAbout UsiNRCORE, LLC is a world-class manufacturer of custom and catalog magnetic solutions. With employees world-wide, iNRCORE is a growing international partner with Gowanda Components Group and Bicron Manufacturing, to design, manufacture and sell specialty electronic components. For over 70 years iNRCORE has deployed...

  • Production Technician

    2 weeks ago

    Bristol, United States GOWANDA ELECTRONICS. Full time

    Job DescriptionJob DescriptionAbout UsiNRCORE, LLC is a world-class manufacturer of custom and catalog magnetic solutions. With employees world-wide, iNRCORE is a growing international partner with Gowanda Components Group and Bicron Manufacturing, to design, manufacture and sell specialty electronic components. For over 70 years iNRCORE has deployed...

  • Quality Control Inspector I

    1 week ago

    Bristol, United States GOWANDA ELECTRONICS. Full time

    Job DescriptionJob DescriptionAbout UsiNRCORE, LLC is a world-class manufacturer of custom and catalog magnetic solutions. With employees worldwide, iNRCORE is a growing international partner with Gowanda Components Group and Bicron Manufacturing, to design, manufacture and sell specialty electronic components. For over 70 years iNRCORE has deployed reliable...