Database Architect

Company: Creative Financial Staffing LLC
Location: Lansing
Posted on: January 12, 2022

Job Description:

Position: Database ArchitectABOUT THE COMPANY:Our client is privately held organization in the financial industry located in the East Lansing, MI area. They are seeking a full-time, permanent Database Architect to be an integral part on their Data & Business Intelligence team! Here are a few reasons why you should apply:

• Outstanding culture with family oriented feel, and technology department is valued.
• Competitive compensation and benefits package with $0 cost healthcare options.
• Located in a brand new building, along with fun areas and sweet treats.
• Opportunity to work between Lansing and Grand Rapids locations. RESPONSIBILITIES:
  • Working with various business departments, to help develop the organizations Microsoft SQL Server Data Warehouse,
  • Responsible for the conception, design, development and deployment of data architecture and data models.
  • Development of physical and logical data models. PREFERRED EXPERIENCE:
    • 3+ years experience in Data Architecture design and development.
    • Experience designing a SQL Data Warehouse including structure of how data is stored and pulled back.
    • Proficient with SQL Server Database and tools SSMS, SSIS, SSAS, and SSRS.
    • Experienced with data warehousing, schema design, data pipeline development, orchestration, monitoring, and ETL processing.
    • Understanding of dimensional modeling, tabular modeling and other warehousing modeling techniques.
    • Ability to write Select statements.
    • Understanding of Microsoft set of tools. BONUS EXPERIENCE:
      • DevOps Background with automation of processes.
      • Understands the benefits and consequences of storing data one way over another.
      • Experience with Git, JIRA, or Power BI.
      • Experience or ability to mentor others. LOCATION:
        • Lansing, MI area BENEFITS:
          • Competitive Medical/Dental/Vision Insurance with $0 cost options, Retirement Plan w/ match , 3.5 Weeks PTO, etc. #cfsdec2021

Keywords: Creative Financial Staffing LLC, Lansing , Database Architect, IT / Software / Systems , Lansing, Michigan