Data Architect

at  Applied Information Sciences

Intro:
As a Data Architect, you will use cutting-edge cloud and data technologies to help global brands and federal agencies solve challenging problems through innovative technology solutions. Work on exciting projects, future-proof your skills, and grow into your dream job alongside some of the industry’s most talented, knowledgeable, and dedicated technologists.

What You’ll Be Doing:

• Work in a team with other smart AIS employees and use cutting-edge technologies to solve challenging enterprise problems.
• Design data platform solutions using Azure data services such as Data Factory, Azure Event Hub, Azure Synapse Analytics, and Azure Databricks.
• Design scalable data processing and analytics solutions, including Big data storage for various data types and large-scale data processing using Databricks.
• Apply your skills in Azure Cognitive Services, Azure P,aaS, and Machine Learning services.
• Use experience working with Azure Data & Storage, Azure Analytics & Azure IoT tools, and the traditional Microsoft BI Stack.
• Provide mentorship to more junior consultants.

Location and Travel Details:
This is a remote position with occasional travel (if needed).
Security Clearance and Citizenship Requirements:
Ability to obtain and maintain a Public Trust Clearance.

Profile of Success:

• Bachelor’s degree in computer science.
• Ten or more years of data engineering experience with strong T-SQL development, including definition of ER models and star schemas for transactional and data warehouse environments, ETL processing for both full and incremental loads, stored procedure coding, data migrations, and performance optimization.
• Expertise working with ETL tools such as SSIS, Azure Data Factory, or dbt.
• Experience with data analytical tools such as SSAS or Snowflake.
• Experience with building report models and data warehouses, to enable report development.
• Experience performing data wrangling operations to support downstream analysis workloads.
• Experience handling ETL failures stemming from incompatible datasets, rows, or service interruption by designing for fault tolerance – detecting, skipping, and logging of incompatible data.
• C# coding with ASP.Net/ASP.Net Core.
• Ability to stay current with the latest technological trends.
• Ability to independently research and propose design solutions that will enhance functionality and increase efficiency of business processes.
• Significant experience with code repositories, such as GIT/DevOps, and change control processes, preferably with automation.
• Ability to respond to executive requests with rapid turnaround and high levels of accuracy.
• Ability to reverse engineer existing code and debug production support issues
• Experience with the full SDLC with a focus on agile methodology.
• Ability to scope out a project plan and perform risk assessments.
• Sound documentation skills.
• Develop software systems that are in compliance with industry standards.
• Ability to communicate concepts to both technical and non-technical audiences.
• Participate in design and code reviews.
• Provide guidance/training to more junior staff.

Desirable Skills:

• Experience with Big Data Architectures, Batch Processing, and Lambda Architectures.
• Experience with Azure/AWS cloud technologies with data transformation via DataBricks or dbt.
• Exposure to Snowflake and/or Databricks.
• Worked with Change Tracking features of SQL Server or Azure SQL.
• Experience with report technologies for models and canned reports, such as Power BI or SSRS.

About AIS:

AIS, DEDICATED TO OUR PEOPLE

AIS employees can spend their entire career at AIS doing challenging, rewarding work and reach their desired level of achievement and responsibility. We offer the opportunity to move up, without the obligation to move out of a position where one excels. We are committed to our employee’s success; however, they define it.
It’s our dedication to our employees that inspired our leadership to invest in our future and become partially employee-owned through an Employee Stock Ownership Program (ESOP).
Our employees are our greatest strength, and we do all that we can to serve them. We invest in technology as early adopters, allowing us to create transformative and innovative solutions for our customers while exposing our team to cutting edge technology.
We hire outstanding individuals who are committed to curiosity, passionate about emerging technology, and who are excited to find innovative solutions for the biggest tech challenges facing international brands and government agencies today.
We Invest in Individuals Committed to Innovation
AIS is seeking professionals of a certain character and level of excellence. People that we can learn from and that we can help grow to achieve their personal career goals.

• Work in a team with other smart AIS employees and use cutting-edge technologies to solve challenging enterprise problems.
• Design data platform solutions using Azure data services such as Data Factory, Azure Event Hub, Azure Synapse Analytics, and Azure Databricks.
• Design scalable data processing and analytics solutions, including Big data storage for various data types and large-scale data processing using Databricks.
• Apply your skills in Azure Cognitive Services, Azure P,aaS, and Machine Learning services.
• Use experience working with Azure Data & Storage, Azure Analytics & Azure IoT tools, and the traditional Microsoft BI Stack.
• Provide mentorship to more junior consultants