Principal Data Architect

The role

We’re looking for a hardworking, success-oriented team player who knows the ins and outs of data and can work in a fast-paced environment. If you’re constantly researching new and exciting uses of technology, we want to talk to you.

• Spec/Qualifications:

Requires a Bachelor’s Degree, or foreign equivalent degree, in Electrical and Electronic Engineering or Computer Engineering and 10 + years of progressive post-baccalaureate experience in the job offered or 10+years of progressive post-baccalaureate experience in a related occupation .

· utilizing Real-Time, Batch, and NoSQL/SQL.

· utilizing big data solutions, SQL Server, DW/Snowflake and Hadoop.

· utilizing Python machine learning, R statistical modeling, data mining, data warehousing techniques, schema design skills and working with AWS cloud services with specific focus on data tier;

· Deep understanding of data enrichment, transformation, security, movement, data architecture, golden record, and data integrity;

· Skills: SQL, Snowflake, Data Modeling, AWS, AWS Glue, JSON, XML, Streamsets , Python, SSIS, Looker, Tableau, API development, Java, .NET

Must: SQL, Snowflake, Data Modeling, AWS, AWS Glue, , Streamsets , Python, SSIS, Looker, Tableau, API development, Java, AWS DMS (is a AWS use for CDC)

Desirables: Hadoop, Streamsets, .NET

• Duties / Responsibilities:

· Drive innovations by keeping current on emerging cloud technologies

· Act as a Subject Matter Expert for migrating on-prem applications to cloud-based PaaS focusing on data warehouse and big data solutions.

· Architect end to end data solutions including data collection and storage, data modelling, and data consumption.

· Provide guidance in migration and transfer of multi-terabyte databases or data warehouses from one data-tier technology to another, based on enterprise strategy.

· Data Modeling: Expertise in data modeling techniques and tools, such as ER modeling, dimensional modeling, and UML (Unified Modeling Language). Design conceptual and logical data models and flowcharts including source-to-target mappings, transforms, and data lineage.

· Partner with Application Architects to design data-intensive applications with APIs and streaming data pipelines.

· Design solutions to prepare and transform data into a usable state for multi-platform consumption.

· Create data architecture, engineering and migration patterns for MSSQL, MYSQL, Oracle, IBM DB2 assisting data tier migrations with multiple technologies including No SQL/SQL, Relational, Analytical, Big Data, Data Stores, Data Warehousing, supporting Solera Technology Standards and Strategies (TSS) and Cloud Technology Mapping for software versions, licensing, cost savings and implementation in AWS