Data Analyst

As a Data Analyst, 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 most talented, knowledgeable, and dedicated technologists in the industry.

What You'll Be Doing

• Work in a team using cutting edge technologies to solve challenging business problems and build solutions
• Interact directly with our client(s) to understand their needs and meet, or exceed their expectations by meeting delivery deadlines
• Work in an agile environment as a member of a scrum team that works in parallel with multiple additional scrum teams within the program
• Learn new technologies and be aware of industry standards, best practices, and trends.
• Design, implement, and test cloud-based enterprise data warehouse solutions

Location and Travel Details

This is a remote position with occasional travel (if needed).

Security Clearance and Citizenship Requirements

Must be able to obtain and maintain a Public Trust Clearance.

Profile of Success

• Strong data analyst skills
• Be able to facilitate and elicit business and technical requirements definition discussions with business and technical stakeholder
• Expert in SQL, including hands-on experience with developing SQL to transform data
• Experience with source data management and data ingestion
• Working knowledge of software engineering practices like version control, testing and continuous integration
• Be able to review and understand Conceptual, Logical and Physical data models
• Experience with Data Warehousing techniques: ETL/ELT, Type 2 Schemas
• Be able to construct data element source to target mappings (STMs) as part of requirements
• Experience writing test plans, test cases, and testing ELT/ETL codeand data model integrity
• Experience in designing and implementing efficient and robust ETL/ELT workflows, schedulers, and event-based triggers

Desirable Skills

• Be able to construct SQL queries for source data profiling and analysis
• Be able to construct SQL queries for writing test cases to validate deployed data warehouse solutions
• Knowledge of advanced source data profiling techniques and data quality measures
• Experience in working with YAML
• Experience with working with data models developed using the Data Vault 2.0 methodology
• Experience with data build tool (dbt)
• Experience in working with Azure DevOps and Git for source control management
• Experience in working with Azure DevOps build release pipelines for release deployments
• Experience in working with Azure data movement and transformation capabilities (Azure Data Factory, Data Lake Analytics, Data Bricks, Stream Analytics)
• Experience in working with the Azure storage technologies (Azure Data Lake, Azure SQL Data Warehouse, Azure SQL Database)

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.

We are looking for:

• Smart people with a passion for technology
• Strong technical capabilities with a consultancy mindset
• Close involvement with local technical communities
• A willingness to think outside of the box to provide innovative solutions to clients
• Ability to solve challenging technical business problems
• Self-directed professionals

Our Core Values

• Client Success
• C ontinued Learning and Technical Excellence
• Strong Client Relationships
• Citizenship and Community

EEO Statement

Applied Information Sciences is an Equal Opportunity Employer and does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, disability, protected veteran status or any other basis covered by law. Employment decisions are based solely on qualifications merit, and business need.