21 days old

Data Architect

Accuity
Mt Laurel, NJ 08054
Apply Now
Apply on the Company Site
  • Job Code
    145105506

We are seeking a creative and self-motivated Cloud Database Architect to lead the development of the Azure based data repository (SQL Server, SSIS, SSRS, SSAS) and future data lake that support the company's services and analytics functions. In this role you will be interfacing with our application developers, data analysts, and business users. This position requires a self-starter that is used to working in challenging yet exciting high growth environments with little supervision. Experience with HITRUST, SOC 2, healthcare PHI, HIPAA, a huge plus. Do you have the skills, experience, passion, and drive to take on this challenge? If this sounds up your alley, keep reading!

Accuity Delivery Systems was founded in 2016 with the goal of reinventing the Clinical Documentation Process, through MD case review, and MD to MD education. Over the last 5 years, we have experienced rapid growth and now have roughly 350 employees. As a technology enabled mid revenue cycle company we focus on leveraging technology to improve our operational process flow, and develop best in class reporting & data analytics.

You will lead the Accuity initiatives to reinvent the data repositories that support our SaaS applications, ETL processes, reporting engine, and future machine learning efforts. This position will require periodic data cleansing activities so experience using Fuzzy logic / Fuzzy grouping would be beneficial. This position requires an expert level of knowledge in the Azure SQL Stack: specifically, SSIS ETL packages, query optimization, database design, and reporting solutions. A passion for data and analytics is a huge plus since you will also support various business intelligence initiatives. The tools/software provided will include various front and backend technologies (MS SQL Server, SSIS, Tableau, etc.) This role will be reporting directly to our VP of IT.

This is a challenging, interesting, and incredibly rewarding position. It is also one that is demanding, and the utmost dedication to the tasks at hand will be compulsory. A successful candidate must have a passion for data, a keen attention to detail, and the ability to approach any challenge from various angles, and the drive to never stop learning.

Primary Job Responsibilities:

  • Experience with modern data lake approaches and alternative schemas and approaches to transactional and analytics data repositories
  • Experience designing and developing database objects, tables, stored procedures, views, and SSIS packages
  • Hands-on Azure database administration and automation skills
  • Expert SSRS Report building skills
  • Strong critical thinking and problem-solving skills. Including a proactive disposition towards identifying problems and providing solutions
  • Thorough understanding of database performance analysis and optimization
  • Experience with Microsoft SQL Server high availability technologies (i.e. always on high availability groups, replication, etc.)
  • Experience managing SQL Server instances in the Azure environment
  • Degree in Computer Science, Business Intelligence, Engineering, Mathematics preferred
  • You are an out-of-the box critical thinker, voice your perspective, but also have the humility to hear out others and weigh their perspectives carefully
  • A minimum of 5 years of experience working with Microsoft SQL Server and T-SQL
  • Experience with the SSAS stack & building data warehouses is preferred
  • Experience in Healthcare is a plus
  • Experience with Tableau / Power BI a plus
  • Performs miscellaneous job-related duties as assigned


Education:

  • Degree in Computer Science, Business Intelligence, Engineering, Mathematics preferred

Experience:

  • A minimum of 5 years of experience working with Microsoft SQL Server and T-SQL, at least 3 years Azure based experience
  • A minimum of 10 years experience in database architecture and administration across any platform
  • Experience with the SSAS stack & building data warehouses is preferred
  • Experience in Healthcare is a plus
  • Experience with Tableau / Power BI a plus

Knowledge, Skills, and Abilities:

  • Strong critical thinking and problem-solving skills. Including a proactive disposition towards identifying problems and providing solutions
  • Thorough understanding of database performance analysis and optimization
  • Experience designing and developing database objects, tables, stored procedures, views, and SSIS packages
  • Expert SSRS Report building skills
  • Experience with Microsoft SQL Server high availability technologies (i.e. always on high availability groups, replication, etc.)
  • Experience managing SQL Server instances in the Azure environment
  • Ability to use a PC in a Windows environment, including MS Word
  • Independent, focused individual able to work remotely or onsite




PI145105506

Posted: 2021-08-27 Expires: 2021-09-28

Job Opportunities

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Architect

Accuity
Mt Laurel, NJ 08054

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast