Lead Data Architect - Bristol, United States - Cirrus Group Consulting

Cirrus Group Consulting Bristol, United States

2 weeks ago

Description

Job Description

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

Snowflake Data Architect

3 weeks ago

LTIMindtree Bristol, United States

About Us: · LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to m ...
Business Intelligence Data Architect

1 week ago

BioTrans LLC Brockton, United States

**Job description** · **ESSENTIAL JOB FUNCTIONS (PRIMARY RESPONSIBILITIES)** · - Contribute to the definition of the firm's architectural vision and direction around data. · - Create the blueprint for cloud based BI architecture to support data analytics solutions that deliver's ...
Lead Data Architect

2 weeks ago

Cirrus Group Consulting Bristol, United States

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 repor ...
Data Architect

2 days ago

Different Technologies Pty Ltd. Warwick, United States

Forseven, a revolutionary company looking to transform the EV industry through cutting-edge technology and innovative engineering practices, is seeking an exceptional Data Architect to join our highly skilled and dynamic team. This pivotal role will operate in a hybrid capacity o ...
Data Architect

3 weeks ago

Tekfortune Inc Providence, United States

Tekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for world's leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the ...
GCp Data Architect

1 week ago

ApTask Providence, United States

About Client: · The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the I ...
Data Architect

3 weeks ago

Saxon Global Providence, United States

An ideal candidate would also have the following skills: · PREFERRED TO HAVE: · • Previous healthcare experience and domain knowledge · • Exposure/understanding DevOps best practice and CICD (i.e. Jenkins) · • Exposure/understanding of containerization (i.e. Kubernetes, Docke ...
Data Architect

3 weeks ago

eTeam Bridgewater, United States

Roles & Responsibilities: 8 to 10 years of experience · Design and implement effective database solutions and models to store and retrieve company data. · Examine and identify database structural necessities by evaluating client operations, applications, and programming. · Assess ...
Principal Data Architect Consultant

3 weeks ago

Sourced Group, an Amdocs Company Providence, United States

Welcome to the Amdocs Cloud Business Unit · We are the result of a strategic fusion of three prominent Cloud Consulting companies: Sourced, Kenzan, and DevOps Group. Today, we proudly operate under the unified brand of Sourced. · As a global team of cloud specialists, we are la ...
Data Architect Lead

2 weeks ago

Rockland Trust Company Plymouth, United States

JOB DESCRIPTION · The Lead Data Architect will define how data is stored, consumed, integrated, and managed by different entities. This role will manage all assessments, inspections, designs, implementations and retirements for the Bank's data architecture in a manner that meets ...
Big Data Architect – FX Trading

3 weeks ago

First Derivative Massachusetts, United States

Who are we? · First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed ...
GCp Data Architect

3 days ago

ApTask Providence, United States

About Client: · The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT ...
Principal Data Architect Consultant

2 weeks ago

Sourced Group, an Amdocs Company Providence, United States

Welcome to the Amdocs Cloud Business Unit · We are the result of a strategic fusion of three prominent Cloud Consulting companies: Sourced, Kenzan, and DevOps Group. Today, we proudly operate under the unified brand of Sourced. · As a global team of cloud specialists, we are la ...
Senior Data Architect- Geospatial

2 weeks ago

BP Energy Pune, United States Full time

Entity: Innovation & Engineering · Job Family Group: IT&S Group · Role synopsis · Architecture is a collaborative team, and it plays a meaningful role in the integration of our businesses. Architects connect all the digital teams and the consumers and procurers of IT, in order to ...
System Developer

5 days ago

CACI Bristol, United States

System DeveloperJob Category: EngineeringTime Type: Full timeMinimum Clearance Required to Start: NoneEmployee Type: RegularPercentage of Travel Required: NoneType of Travel: None* * *What You'll Get to Do · CACI is seeking a Senior level System Developer supporting a complex dat ...
TRIRIGA Developer

5 days ago

CACI Bristol, United States

TRIRIGA DeveloperJob Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: NoneEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Local* * *CACI is currently looking for a TRIRIGA Subject Matter Expert with agile metho ...
Machine Learning Engineer

1 week ago

airbus Bristol, United States Full time

Job Description: · SECURITY CLEARANCE: You will be subject to a BPSS check (including a criminal record check) · TRAVEL REQUIRED: Occasional travel within UK and international · LOCATION: Filton (Typically 3 days a week in the office, 2 days remote) · TYPE: Full time / STEM retur ...
Full Stack Developer

6 days ago

CACI Bristol, United States

Full Stack DeveloperJob Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: NoneEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Local* * *General Description: · CACI is currently looking for a Full Stack Developer ...
Principal Salesforce Solution Architect

2 weeks ago

Revvity Providence, United States

**Overview**: · **Role & Responsibilities**: · - Advise on business requirement documents, user stories, functional specifications, and system design specifications. · - Elicit requirements using interviews, document analysis, requirements workshops, business process descriptions ...
Land Surveyor

2 weeks ago

Coneco Engineers & Scientists Bridgewater, United States

Job Overview: · **Responsibilities**: · - Conduct land surveys to establish property boundaries, elevations, and other geospatial measurements · - Utilize tools such as GPS, total stations, and levels for data collection · - Collaborate with engineers, architects, and constructio ...