RestonRecruiter Since 2001
the smart solution for Reston jobs

Analytics Engineer

Company: Applied Information Sciences
Location: Reston
Posted on: October 14, 2021

Job Description:

We are hiring a Analytics Engineer to work in a fast-moving, forward-leaning environment to build a full featured platform which will serve as the backbone for big data and data analytics innovations. We are looking for modern data enthusiasts who want to make a big impact, deliver great technology, and work on an exciting team.


If you are looking to transform your data analysis experience to a modern data stack, and you are passionate about delivering well-defined, transformed, tested, documented data sets in a manner that empowers end users to answer their own questions, then we have the right opportunity for you!

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

Security Clearance and Citizenship Requirements

Profile of Success

  • Facilitate and elicit business and technical requirements definition discussions with business and technical stakeholders
  • 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
  • Understand Conceptual, Logical and Physical data models 
  • Experience with Data Warehousing techniques: ETL/ELT, Type 2 Schemas
  • Experience writing test plans, test cases, and testing ELT/ETL codeand data model integrity
  • Construct data element source to target mappings (STMs) as part of requirements
  • Experience in designing and implementing efficient and robust ETL/ELT workflows, schedulers, and event-based triggers

Desirable Skills

  • Ability to construct SQL queries for source data profiling and analysis
  • Ability 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
  • Continued 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.

Keywords: Applied Information Sciences, Reston , Analytics Engineer, Other , Reston, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Reston RSS job feeds