Data Analytics Engineer

Company: Applied Information Sciences
Location: Chevy Chase
Posted on: May 16, 2022

Job Description:

Intro: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. We have the right opportunity for you to grow your skills and career.We are hiring a Data Analytics Engineer to work in a fast-moving, forward-leaning environment to build a full featured platform which will serve as the backbone for their 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.What You'll Be Doing:Work in a team using cutting edge technologies to solve challenging business problems and build solutionsInteract directly with our client(s) to understand their needs and meet, or exceed their expectations by meeting delivery deadlinesWork in an agile environment as a member of a scrum team that works in parallel with multiple additional scrum teams within the programLearn new technologies and be aware of industry standards, best practices, and trends.Design, implement, and test cloud-based enterprise data warehouse solutionsLocation and Travel Details:This is a remote position with occasional travel once COVID restrictions are lifted.Profile of Success:Strong data analysis and modeling skillsProblem solving, consulting mindsetBe able to 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 dataBe able to construct SQL queries for source data profiling and analysisBe able to construct SQL queries for writing test cases to validate deployed data warehouse solutionsExperience with source data management and data ingestionWorking knowledge of software engineering practices like version control, testing and continuous integrationBe able to review and understand Conceptual, Logical and Physical data modelsExperience with Data Warehousing techniques: ETL/ELT, Type 2 SchemasBe able to construct data element source to target mappings (STMs) as part of requirementsExperience writing test plans, test cases, and testing ELT/ETL codeand data model integrityExperience in designing and implementing efficient and robust ETL/ELT workflows, schedulers, and event-based triggersDesirable Skills:Knowledge of advanced source data profiling techniques and data quality measuresExperience in working with YAMLExperience with working with data models developed using the Data Vault 2.0 methodologyExperience with data build tool (dbt)Experience in working with Azure DevOps and Git for source control managementExperience in working with Azure DevOps build release pipelines for release deploymentsExperience 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 PeopleAIS 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 InnovationAIS 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 technologyStrong technical capabilities with a consultancy mindsetClose involvement with local technical communitiesA willingness to think outside of the box to provide innovative solutions to clientsAbility to solve challenging technical business problemsSelf-directed professionalsOur Core ValuesClient SuccessContinued Learning and Technical ExcellenceStrong Client RelationshipsCitizenship and CommunityEEO 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, Washington DC , Data Analytics Engineer, Engineering , Chevy Chase, DC