Data Architect
Accuity
full-time
Posted on:
Location Type: Remote
Location: Remote • New Jersey • 🇺🇸 United States
Visit company websiteJob Level
SeniorLead
Tech Stack
AzureETLMS SQL ServerSQLSSISTableau
About the role
- Lead the development of the Azure based data repository (SQL Server, SSIS, SSRS, SSAS) and future data lake
- Interface with application developers, data analysts, and business users
- Reinvent the data repositories that support our SaaS applications, ETL processes, reporting engine, and future machine learning efforts
- Periodic data cleansing activities requiring experience in using Fuzzy logic / Fuzzy grouping
- Support various business intelligence initiatives while maintaining a passion for data and analytics
Requirements
- 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
- Strong critical thinking and problem-solving skills
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL ServerT-SQLAzureSSISSSRSSSASETLdatabase architecturedatabase administrationdata warehousing
Soft skills
critical thinkingproblem-solvingindependencefocus