Senior Data Architect

Software Guidance & Assistance, Inc., (SGA), is searching for a Business Intelligence and Analytics (BIA) Data Architectfor a CONTRACT assignment with one of our premier Financial Services clients in New York, NY.
The Business Intelligence and Analytics (BIA) Data Architect is part of a Corporate Analytics team responsible for supporting data and analytics solutions for MMC Corporate Information Solutions. This individual will collaborate with the analytics team to design and implement the MMC corporate data strategy, ensuring reliable data infrastructure and creating data solutions for variety of business use cases.
Responsibilities :

• Responsible for managing a growing cloud-based data ecosystem and reliability of our Corporate data lake and analytics data mart
• Contribute to the continued evolution of Corporate Analytics Platform (CAP) and Integrated data model.
• Identify gaps and weaknesses in our data stack and continue to guide learning advancements for the team
• Provide technical expertise and leadership to Data Architecture team in all phases of work including analysis, design and architecture to develop and implement cutting-edge solutions.
• Negotiate and influence changes outside of the team that continuously shape and improve the data strategy

Required Skills:

• Bachelor's Degree or equivalent experience in Computer Science, Information Systems, or related disciplines.
• 7 years of experience implementing analytics data solutions by working with and leveraging Microsoft Azure resources such as Azure Data Lake Storage, Azure Data Factory, Synapse , Databricks, Logic Apps, and ML Studio
• 7 years of experience in data warehousing with expert knowledge of dimensional modeling concepts and performance tuning
• The ability to evaluate existing data models and physical databases for variances, discrepancies, and redundancies
• The ability to independently perform data profiling and analysis to understand source data
• An understanding of the role of data security and privacy compliance and related best practices in their implementation
• 4 years of experience using Erwin Data Modeler R9.7 or later
• Experience with data lineage and data cataloging tools such as Informatica EDC and Alation Data Catalog
• Experience with data virtualization platforms such as Dremio or Denodo
• Working knowledge and experience with Python, Scala, or R
• Critical team member in the design and development of highly complex and critical data projects
• Leverage research and previous experience to ensure we're up-to-date and continuously exploring new technologies
• We are passionate about trying new things and follow through with 10% time and Tech hack-a-thons
• Excellent professional development and career growth opportunities

Preferred Skills:

• Excellent communication and presentation skills
• Domain knowledge in one or more corporate functions such as HR, Finance, Real Estate is preferred
• Excellent problem solving skills with innovative thinking and proactive approach
• Ability to recommend and implement best practices and processes

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com .
EEO Employer: Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status.