Senior Data Architect (2053)

Company: SMX Corporation
Location: Hartford
Posted on: March 17, 2023

Job Description:

Senior Data Architect (2053)at SMX(View all jobs) (https://www.smxtech.com/careers/)
United States
SMX is seeking a Senior Data Architect to provide assistance, guidance to development teams in regard to data modeling, SQL and stored procedure development, includes code review of complex SQL and stored procedures and performance tuning as needed by development teams; develops data models as required by project team. This role is 100% remote.
Essential Duties and Responsibilities:

• 
  
• 
  Progressive experience designing, coding, and leading ETL/ELT and data pipeline development
  
  
• 
  Full lifecycle, consultative client-facing experience, from requirements gathering to user acceptance testing and post-delivery hypercare. (Internal or external clients acceptable)
  
  
• 
  Data modelling experience, and familiarity with common data analytics patterns including data warehouse, data lake and data marts (Kimball)
  
  
• 
  Experience working in an Agile/XP software development practice, with database and data pipeline assets incorporated into source control and devops
  
  
• 
  Successful experience in capacity planning for data platform infrastructure
  
  
• 
  Experience migrating a data warehouse across platforms is preferred
  
  
• 
  Experience crafting and delivering role-based user access models
  
  
• 
  Experience leading technical delivery teams
  
  
• 
  Experience working with highly regulated data sets and supporting regulatory compliance audits.
  
  
  Required Experience:
  
  • 
    
  • 
    Advanced knowledge of data modeling in relational, dimensional, multidimensional, and non-structured environments
    
    
  • 
    Advanced knowledge of data integration patterns and procedures
    
    
  • 
    Expert knowledge of an industry standard financial data model, like FSLDM, is an asset
    
    
  • 
    Advanced knowledge of data mastering principles
    
    
  • 
    Deep understanding of data governance principles
    
    
  • 
    Responsible for contributing to multiple projects with high degree of complexity and broad scope
    
    
  • 
    Exceptional Organizational Skills
    
    
  • 
    Excellent in client facing environments
    
    
    #LI-Remote
    Our tradition of delivering innovative, technical solutions dates back to 1995, however, you may know us better by one of our legacy company names: Trident Technologies, Smartronix, Datastrong or C2S Consulting Group. With the support of OceanSound Partners, our private equity investment sponsor, we began operating as one business starting in 2019 and became SMX in 2021. We operate in close proximity to our clients around the globe and have core locations in Alabama, California, DC Metro, Florida, Hawaii, Maryland, and Massachusetts.
    Today, as SMX, we are one team and together empower government and commercial enterprises to become more effective, innovative, and resilient, no matter what challenges they face.
    SMX is committed to hiring and retaining a diverse workforce. All qualified candidates will receive consideration for employment without regard to disability status, protected veteran status, race, color, age, religion, national origin, citizenship, marital status, sex, sexual orientation, gender identity or expression, pregnancy or genetic information. SMX is an Equal Opportunity/Affirmative Action employer including disability and veterans.
    Vaccination within 60-days of hire, or an approved accommodation, is a requirement of the position per Executive Order 14042 (unless precluded by State law). If a candidate is not vaccinated, they may request an accommodation once offered the position, and the accommodation must be granted prior to the employee starting in the position. Candidate will have 60 days to get vaccinated.
    Selected applicant will be subject to a background investigation.

Keywords: SMX Corporation, Hartford , Senior Data Architect (2053), Other , Hartford, Connecticut