Manager of Data Architecture (BC)
Job Location: Mahwah, NJ
Date Posted: 2021-09-30
6 months - Fortune Firm
Mahwah, NJ (3 days on site)
MUST BE A CITIZEN OR GREEN CARD HOLDER
At a minimum, a Bachelors degree in Computer Science, Information Technology or a related field is required. An MBA or Masters Degree is an advantage.
WORK EXPERIENCE NEEDED:
5 to 10 years of experience in a senior-level IT management role. Strong communication and customer engagement skills. Project management skills, including concurrently contributing to or managing multiple projects. Professional and ethical behavior. Experience leading significant data architecture transformations at a technical level within a large organization. Deep experience in data architecture, data modeling and implementing data lakes. True, "Hands- On" history of architecting, designing, and building enterprise-class relational and dimensional data models for large data lakes/data reservoirs.
SPECIAL SKILLS/ABILITIES NEEDED:
Skilled in Data Modelling (Dimensional, Normalized, Key-value pair), Information Architecture, Analytics, Schema Evolution, Data Organization Layouts. Familiarity with a variety of project management methodologies including Agile and Waterfall. Proficient in designing data infrastructure for data lakes. Advanced knowledge of SQL and related programming languages (PL/SQL, T-SQL, Python). Experience in Full BI life cycle of Data Warehousing and Data Integration projects from design to development to operational support. Skilled in strategies in how to best protect and secure data in databases, warehouses, and lakes. Experience with cloud infrastructure, storage optimization and query optimizations. Familiar with technologies including Snowflake, BladeBridge, ETL/ELT tools, Fivetran, Mulesoft, SCADA, Oracle/SQL Server, AWS, ESRI GIS, INFOR EAM, KloudGin. Develop source, target, and output mapping technical documents as required for data lineage and transformation and integration. Familiarity with data structures (i.e. 3NF, 2NF, OLAP, OLTP, Star & Snowflake). Ability to design slowly changing dimension. Familiar with creating solution strategies for dealing with Unknown, Not Applicable, Non-conforming attribute values. Design knowledge of surrogate key management real time data processing.
Please contact Brian Clark at email@example.com
Recruiter LinkedIn Page