Demo

Lead Data Architect

Cirrus Group Consulting
Bristol, PA Full Time
POSTED ON 1/24/2025
AVAILABLE BEFORE 4/22/2025

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 :

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 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
  • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Lead Data Architect?

    Sign up to receive alerts about other jobs on the Lead Data Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $152,365 - $200,973
    Income Estimation: 
    $141,014 - $186,880
    Income Estimation: 
    $180,084 - $244,913
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Cirrus Group Consulting

    Cirrus Group Consulting
    Hired Organization Address San Francisco, CA Full Time
    Cirrus is seeking an SQL / SSIS Developer to work in San Francisco Bay Area or remote. Essential Job Duties and Responsi...

    Not the job you're looking for? Here are some other Lead Data Architect jobs in the Bristol, PA area that may be a better fit.

    PEGA Senior System Architect

    Hudson Data, Trenton, NJ

    AI Assistant is available now!

    Feel free to start your new journey!