4 days old

Federal - ETL Analyst

Washington, DC 20044
Organization: Accenture Federal Services

Location: Washington, DC


Accenture Federal Services, a wholly owned subsidiary of Accenture LLP, is a U.S. company with offices in Arlington, Virginia. Accenture's federal business has served every cabinet-level department and 30 of the largest federal organizations. Accenture Federal Services transforms bold ideas into breakthrough outcomes for clients at defense, intelligence, public safety, civilian and military health organizations.


We believe that great outcomes are everything. Its what drives us to turn bold ideas into breakthrough solutions. By combining digital technologies with what works across the worlds leading businesses, we use agile approaches to help clients solve their toughest problems fastthe first time. So, you can deliver what matters most.


Count on us to help you embrace new ways of working, building for change and put customers at the core. A wholly owned subsidiary of Accenture, we bring over 30 years of experience serving the federal government, including every cabinet-level department. Our 7,200 dedicated colleagues and change makers work with our clients at the heart of the nations priorities in defense, intel, public safety, health and civilian to help you make a difference for the people you employ, serve and protect.


Job Description:

The candidate should enjoy working in a fast-paced environment with large scale data and the latest data management and storage tools. Individuals in this role are expected to have a passion for solving complex problems and researching solutions to technical challenges. The candidate will work with event based data to build dynamic analyses, workflows, and visualizations. The candidate will need to collaborate and support data scientists and analysts with translating requirements into ETL functions. The ETL Analyst will be expected to build ETL workflows, generate reports from a data warehouse, and perform other related tasks as needed.





Job Responsibilities:



+ Work with data scientists to generate requirements for ETL workflows.


+ Create ETL processes for streaming and static data.


+ Python, R, and SQL development.


+ Identify data opportunity and work with source owners to understand data structures.


+ Build sustainable architectures and methods to transform data into analytic insights.


+ ETL pipeline and debugging analytical data issues.


+ The candidate will also enhance data architecture, design, strategy, and review, prioritize, research architectural efficiencies and enhancements.





Basic Skills & Qualifications:



+ 1 year of related experience and bachelor's degree in computer science, information engineering, information systems, or other related discipline/ OR 4 years of relevant experience in lieu of degree


+ 1 year of hands-on experience designing and implementing data integration, Big Data, and/or business intelligence solutions


+ 1 year of hands-on experience in ETL design, and development in large scale data environment


+ 1 year of hands-on experience with SQL relational databases: PostgreSQL, Oracle, MySQL etc...


+ 1 year of hands-on experience with python as a scripting language


+ Strong SQL and data modelling skills


Preferred Skills & Qualifications:



+ 1 year of hands-on experience with AWS Technologies: Redshift, S3


+ 2-3 years of related experience and masters degree in computer science, information engineering, information systems, or other related discipline.


+ 2-3 years hands-on experience designing and implementing data integration, Big Data, and/or business intelligence solutions


+ 1-2 years hands-on experience in ETL design, and development in large scale data environment


+ 2-3 years hands-on experience with SQL relational databases: PostgreSQL, Oracle, MySQL etc...


+ 2-3 years hands-on experience with R and python as a scripting languages


+ 2-3 years hands-on experience with AWS Technologies: Redshift, S3 is a plus


+ Expert SQL and data modelling skills


+ Experience with data visualization



An active security clearance or the ability to obtain one may be required for this role.


Candidates who are currently employed by a client of Accenture or an affiliated Accenture business may not be eligible for consideration.


Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States and with Accenture (i.e., H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status).


Accenture is a Federal Contractor and an EEO and Affirmative Action Employer of Females/Minorities/Veterans/Individuals with Disabilities.


Equal Employment Opportunity

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.


Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process.


Accenture is committed to providing veteran employment opportunities to our service men and women.
Posted: 2019-11-08 Expires: 2019-12-08

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Federal - ETL Analyst

Accenture
Washington, DC 20044

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast