Data Architect
Unisys
Long Beach, United States of America
2 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Long Beach, United States of America
Tech stack
Query Performance
PHP
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Azure
Big Data
Google BigQuery
C Sharp (Programming Language)
Cloud Computing
Databases
Data Architecture
Data Governance
ETL
Data Mart
Data Security
Data Structures
Data Systems
Data Vault Modeling
Data Visualization
Data Warehousing
Relational Databases
Database Queries
Document-Oriented Databases
Hadoop
Python
Machine Learning
Mainframes
Microsoft SQL Server
MongoDB
NoSQL
Operational Data Store
Oracle Applications
Power BI
Standard Sql
Service-Oriented Architecture
SQL Databases
Data Streaming
Tableau
Web Services
Jupyter Notebook
Data Processing
Data Server Interface
Google Cloud Platform
Cloud Platform System
Azure
Spark
Database Performance
Sap Business Objects
Data Lake
Storage Technologies
Data Lineage
Collibra
Cassandra
Amazon Web Services (AWS)
Data Analytics
Data Management
Physical Data Models
Alteryx
Databricks
Programming Languages
Job description
- Work with business leads and systems implementation partners to define database/data warehousing requirements and data interfaces
- Conduct data model reviews with project team members/business subject matter experts
- Working with our other architects and engineering leads to build data security, management and engineering excellence into all our solutions.
- Consulting with internal teams and client stakeholders on proposed solutions and how they'll be developed/deployed and used.
- Leveraging automation in every part of a solution to accelerate and optimize all out solutions.
- Work with internal resource and system implementation partners to design Datawarehouse and DataMart structures
- Identify data requirements and related KPIs, metrics, etc.; perform and document data source gap analysis
- Participate and drive proof-of-concept or prototyping of data systems and data solutions
- You will participate in architectural reviews, ensuring the best patterns are in place, while early identify upstream and downstream side effects
- This will be heavily working with stakeholders and data modelling work with less of a focus on the enterprise or infrastructure architecture
- You will create documents that ensure consistency in development across the organization
- They will be working with the key stakeholders to understand the data flows within the organization and the stakeholders needs
- Manage data management workstream
- Assessing the logical and physical data models required to deliver this
- Enabling the build of a greenfield data warehouse which sits on top of their existing data lake and allows the teams to deliver effective analytics
- You will facilitate conceptual discussions to meet business objectives
- You will define usage patterns and anti-patterns for data systems, processing, modelling, and storage technologies
- You will bring a holistic brand and enterprise view into new data system design.
- Works within and across practices and organizations to design leading-edge technology or application solutions that result in profitable revenue growth for Unisys.
- Conceptualizes, architects, designs, implements and supports integrated solutions for client engagements.
- Demonstrates extensive knowledge of industry, technology and strategy trends and uses this knowledge to generate profitable revenue growth for Unisys.
- Builds relationships with product development organizations and is recognized by these organizations as a key product champion who adds value through exposure to client situations.
- Advises, analyses, researches, designs, installs and implements complex integrated solutions for an entire enterprise. Interfaces extensively with the client's senior management team (e.g., the IT Directors) on business, systems architectural, and technical issues. Provides mentoring and team leadership to other architects.
- Develops the integrated technology requirements project plan.
- Integrates complex solutions into new or existing client environments.
- Uses advanced diagnostic analytical and design capabilities.
- Ensures that the best solution is provided to the customer (e.g., completes solution integrity engineering and development attributes.)
Requirements
Do you have experience in Data-driven problem-solving?, * University degree or equivalent experience and a minimum of 10 years of experience in a broad range of data sources including SQL and NOSQL
- Data Architect experience (5+ years)
- Experience in one or more related cloud platform technology areas that interests you, for example: SQL Server, Data Lake Storage, Data Movement/Transformation e.g. Azure Data Factory/AWS Glue, Data Analytics e.g. Databricks/Synapse/BigQuery, Data Cataloguing, Data Quality, Data Lineage, Data Governance, Data Mesh/Lakehouse, Master Data Management etc.
- Some knowledge of common industry tooling covering areas such as ingestion, streaming, storage, visualisation etc.
- Experience with hands-on implementation on cloud platforms including at least one of: Microsoft Azure, Amazon Web Services, Google Cloud
- Experience in architecting and designing the migration of data from one data source to another in which the data sources are not of same type such as Mainframe to Modern Databases such as Oracle
- Design experience on Data Vault, Data Lake and Mart technologies in Cloud
- Experience using advanced SQL functions and query performance tuning
- Experience of design within a data science environment (AWS S3/ Jupyter notebooks)
- Familiar with a variety of modelling approaches, tools and model repositories
- Experience of Data Catalogue tools (e.g. Collibra, Informatica)
- Strong knowledge of master data management
- Knowledge of Business Objects, Tableau etc
- Knowledge and/or experience with service-oriented architecture entities and frameworks
- Knowledge of database performance/tuning/measurement, as well as user access and data manipulation
- Data warehousing, including business line and enterprise data warehouses, operational data stores, and business intelligence data structures
- Experience in Conceptual, Logical, and Physical Data Model design
- Strong knowledge of entity relationships
- Hands on skills in SQL, Python, AWS & Azure infrastructures, Alteryx & Tableau
- Strong knowledge of SQL, C#, SOA and web services
- Documented experience (at least 2 years) with ETL in the context of data warehouses
- Knowledge of Big Data environments (Hadoop & PhP)
- Seeing the Big Picture
- Has strong expertise and experience in data analytics, data visualization, machine learning and predictive modelling
- Defines policies, procedures and models for data collection, storage, structure, access, manipulation, access and visualization
- Defines technologies and tools used at various stages of data driven solution creation, maintenance and operation
- Understands and connects business and technology aspects of data and its usages
- Expertise and experience to translate data related business requirements into technology solutions
- Deep expertise of various form of databases - RDBMSs, MongoDB, Cassandra, Hadoop, Spark etc. and database query languages - SQL, NoSQL
- Strong expertise in business intelligence (BI) software - Tableau, Power BI, Chartio, and related programming languages - Python.