Data Engineering

Data Analytics Powered by CGI

Eastern Tennessee (Virtual)

Close

Choose your location

This course is currently offered in select locations. Candidates must live within commutable distance of the Per Scholas location to be eligible.

This 12-week course prepares learners with a diverse skill set across key domains in the field of Data Analytics for roles CGI Federal has in demand in Knoxville. Build proficiency in agile software development methodologies, relational database management, Python programming, big data processing, statistical analysis, and data visualization. Currently offered online. Existing Python knowledge required.

Get Started

  • Remote

No cost, no catch. Tuition-Free training and job connections.

Offered in collaboration with:

Course level

Technical knowledge required ?

Schedule

  • Remote 9AM - 4PM CT
    Monday through Friday
    12 Weeks

Upcoming course dates

  • December 4th, 2023
    Application Due November 20th, 2023
  • Please note, this application process is very competitive and not all applicants will be accepted for our limited slots. Seats are offered on a first come, first served basis.

While these courses may include either intermediate or advanced material, technical knowledge specified in these listings will be required as a prerequisite for applicants to be considered for admission.

While anyone may apply for this course, some technical background may be helpful.

Applicants with all levels of experience in tech are encouraged to apply.

Most CISCO Network Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

Most CISCO IT Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

Gain the knowledge and skills necessary to effectively demonstrate an overall understanding of the AWS Cloud and start a career in cloud computing.

CompTIA Cybersecurity Analyst (CySA+) is an IT workforce certification that applies behavioral analytics to networks and devices to prevent, detect and combat cybersecurity threats through continuous security monitoring.

The Google IT Support Professional Certificate introduces learners to troubleshooting, customer service, networking, operating systems, system administration and security. No prior experience is required.

CompTIA Network+ helps develop a career in IT infrastructure covering troubleshooting, configuring, and managing networks.

Most CompTIA A+ certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

In-person learning takes place at one of our facilities across the US.

Remote learners must live within commutable distance of a Per Scholas campus to best facilitate our professional development and post-training employment support. For individuals who live outside of a commutable distance, you may be eligible for our National training courses.

Hybrid courses allow flexibility for learners to participate in the course remotely or in-person based on several factors. Learn more about the course you're interested in by reaching out to your admissions lead or attending an admissions overview after applying.

?

Have questions?

We can help with course selection, and answer questions about eligibility requirements and special circumstances. Contact an admissions team member

Advance Your Skills to the Next Level

Utilize your existing Python knowledge to gain the specific skills necessary for Data Analytics openings in your community through live instructor-led training.


Cover Fundamental Skillsets

Master the intricacies of relational databases, adeptly crafting SQL queries, ensuring data integrity, and leveraging triggers and views.


Hands-On Understanding of Data Analytics with Python

Proficiency in Python programming will enable graduates to process efficiently and wrangle data, while insights into big data processing using tools like Apache Spark will prepare them for contemporary data challenges.


Hands-On Professional Development from a Tech Industry Leader

The curriculum and career development for this course was developed collaboratively with CGI Federal.

What jobs can I get as a Data Analytics graduate?

As a Data Analytics graduate, you will enhance your fundamentals in data analytics, equipped with the knowledge to fulfill a wide range of technology jobs such as: 

  • Data Analysts
  • Database Administrators
  • Business Intelligence Analysts
  • ETL Developers
  • Data Visualization Specialists

This program in partnership with CGI Federal is designed to meet specific local job demands at the end of the program. CGI Federal recruiters will play an active role in your career development throughout the class, including mock interviews and resume reviews. Per Scholas does not require candidates to sign a contract with any employer partner. Learners are always free to their own future.

$66k the average salary Data Analytics graduates make at their first job

Strengthen your Professional Profile


REMAIN COMPETITIVE AS THE INDUSTRY GROWS

Whether you are fresh out of college, self-taught or seasoned veteran, per scholas’ evolving curriculum will help you get the skills necessary to take the next step in your career.

Per Scholas Graduate, Andre Yates, who is now a software developer
As I was applying and going through interviews, there was a gap between where my college education brought me and where companies expected me to know things about the technology industry. Per Scholas taught me so much that I wasn’t able to learn in school.

Meet Andre Yates


Customized Professional Development and Networking

Regular Career Development like resume reviews, mock interviews, and "Meet the Employer" sessions will familiarize you with our employer partners, meet with other IT professionals and help prepare you for the job search.

portrait of Jordan
I used to doubt myself and my abilities. I kept my focus on my training and the image of the person I wanted to become, and I overcame it. Today, I am a full-stack developer and I encourage anyone trying to break into tech to consider Per Scholas

Meet Jordan Wofford


Direct Job Placement Support

Graduates will receive job placement support from the employer partner and identify career opportunities leveraging their new and existing skills. If CGI Federal doesn't work out, Per Scholas staff will continue to provide connections with other employer partners.

I worked 12 hours straight nearly every day, weekends included, and missed out on the lives of my friends and family. Per Scholas helped me to discover both a career path and how to have a work-life balance so that I could spend time with my loved ones.

Meet Matt Yamarino

What You'll Learn From Data Analytics Courses


Master critical Data Analytics skillsets

Dive into the different types of Data Analysis, explore the Data Analysis process, master Data Analysis tools and techniques.


Explore Data Warehousing and ETL

Develop an understanding of Data Warehousing and Data Mart.


Process Large Scale Data for Analytics and Machine Learning

Identify big data strategies that can support new insights and predictable outcomes for businesses and industries alike.

Curriculum

Hands-on training along with career development and guest speakers

Learner Onboarding

Asynchronous  

  • Introduction to the Program
  • Succeeding with the Program
  • Digital Citizenship

Synchronous 

  • Program and Technology Onboarding
  • Canvas Training
  • Microsoft Office 365
Project Management Methodologies
  • Introduction to Agile SDLC
  • Definition and overview of Agile SDLC
  • Principles of Agile SDLC
  • Agile Manifesto and its values
  • Overview of Lifecycle Phases (Planning, Iterative development, Requirements Management, Design and Development, Testing, Continuous Improvement)
  • Case studies will be used throughout all other modules to reinforce the concepts above
Relational Databases and SQL
  • Overview of RDBMS and MySQL
  • Introduction to SQL, The SQL Language
  • Normalization of Data
  • SQL Data Integrity, SQL Joins, Clauses, and Operators
  • Aggregate Functions, Subqueries
  • Working with Subprograms
  • Control Flow Functions and Expressions
Advanced RDBMS and SQL
  • Creating indexes for increased query performance
  • Database constraints: key, referential integrity, and “check” constraints
  • Work with Database triggers
  • Creating Database Views
  • Authorization in relational databases
Python Programming and Database Integration
  • Python Programming Basics Review
  • Overview of Built-In Functions
  • Working Python Modules
  • Python and Data structures 
  • Processing JSON Data using Python for data pipeline
  • Processing Relational Databases using Python for Data Pipeline
  • Writing Python programs to interact with the database and perform basic database operations.
  • Data wrangling using Python for Data Pipeline
Introduction to Data Warehousing and ETL
  • Data Warehousing and Data Mart
  • Introduction to Big Data and ETL
  • Data Warehouse Overview
  • Data Mart Styles
Overview to Spark and Spark SQL
  • Fundamentals of Apache Spark, Role of Driver in Spark Architecture
  • Set up a full environment for developing Spark applications, Spark Shell and PySpark
  • Fundamentals of RDD, Loading data into RDD, Transformations, and Actions
  • Fundamentals of DataFrame and Spark SQL
  • Spark SQL performance optimization, Libraries of Spark SQL
  • Manipulating the Data with Spark SQL, Loading data into DataFrame, and Basic operation with PySpark
Introduction to Data Analysis
  • Introduction to Statistics and Measure of Variability
  • Introduction to data analysis and visualization
  • Conceptualizing Data Analysis as a Process
  • Types of Data Analysis
  • Data Analysis Process
  • Data Analysis Tools and Techniques
Power BI
  • Introduction  to Power BI Desktop
  • Connecting and Shaping Data
  • Relationships and Data Models
  • Data Analysis using Power BI
  • Data Analysis Expressions (DAX)
  • Data Visualization using Power BI
Capstone
  • Investigate a Challenging Problem in an authentic context
  • Develop Ideas or solutions through sustained Inquiry with problem-solving approaches
  • Evaluate instructor and peer review and use feedback to revise and improve work
  • Present the Product showcasing the key learnings and accomplishments
Professional Development and Graduation
  • Elevator Pitch
  • Resume Development 
  • LinkedIn Profile 
  • Habits of Success
  • Emotional Intelligence 
  • Communications 
  • IT and Interpersonal Skills

Curriculum

Hands-on training along with career development and guest speakers

View

Sample Schedule

  • Morning lecture and hands-on learning activities
  • Break for lunch
  • Afternoon lecture and hands-on learning activities
  • Open lab

Learn to Think like a Tech Professional

Prepare to handle real workplace demands by challenging your understanding of course material and setting you up for professional success.


A Community of Support

Learners and Alums have access to a Learner Support Team with Financial Coaches and Support Managers working with them to gain financial control, achieve financial goals, and design success plans.


Career Advancement for Alumni

Complimentary upskilling opportunities extended to alumni up to two years post graduation to help them match in demand employer hiring profiles and continue their career growth.

Per Scholas Java Developer Graduate Mira Winkel

Meet Our Graduates

It's huge knowing that I don't just have a beginner skill set. I have a very focused skill set that is highly in demand. Per Scholas gave me the base of my knowledge to go out and be successful.

Meet Mira Winkel

How to Be Considered

Learner Profile

You may qualify to become a Per Scholas Data Analytics Learner if you:

  • Have existing knowledge of basic Python Programming
  • Live within the Eastern Tennessee Development District (Defined as establishing residency in one of the following sixteen counties: Anderson, Blount, Campbell, Claiborne, Cocke, Grainger, Hamblen, Jefferson, Knox, Loudon, Monroe, Morgan, Roane, Scott, Sevier, Union)
  • Are aged 18 or older
  • Have a High School diploma, equivalent, or higher
  • Are authorized to work in the U.S.
    • Due to the nature of government contracts, learners must be eligible for employment based on Federal Contract employment eligibility
  • Can read, write, and speak in English
  • Can attend classes full-time for the entire duration of the course
  • Are able to start a full-time job after course completion
  • Ready to make an important commitment to building your future
  • Meet the pre-training income policy guidelines
Technical Assessment Prep
Admissions Process

1. Submit an Eligibility Form

2. Admissions Overview: Once you submit an Eligibility Form, you’ll be directed to our Admissions Overview registration page. During this virtual webinar, you’ll learn more about our admissions process and next steps.

3. Assessments: This training requires a technical assessment based on your knowledge of Python. 

4. Interview: Individuals who meet the assessment score requirements will be invited to attend a behavioral interview.

5. Offer Letter and Onboarding: The Admissions team will review assessment scores and interview results and offer seats to eligible candidates. The learner onboarding process mirrors Employment Onboarding.

 

Please note, this application process is very competitive and not all applicants will be accepted for our limited slots.

Frequently Asked Questions

What kinds of jobs can I get after completing this training?

This course opens doors to careers in Data Analytics. Some possible jobs may include: Data Analysts, Database Administrators, Business Intelligence Analysts, ETL Developers, and Data Visualization Specialists.

How can the course be free? Are there hidden fees?

Most people who learn about us think: “Too good to be true.” We know it seems that way, but it’s true. Our services are provided at no cost to you, using funds we raise from foundations, corporations, government and generous individuals.

The costs you can prepare for include transportation or childcare—expenses that take care of you so you can focus on your studies.

What if I don’t have a Laptop? What are the computer requirements?

Computer requirements are determined by each specific curriculum track. During the onboarding process, we will review each learner’s needs on a case-by-case basis. If you have any concerns about your situation, please elevate to the admissions team during the admissions process.

Is there a learner pre-training income policy?

Yes, Per Scholas learners must meet the pre-training income policy requirements. View our Learner Pre-Training Income Policy here.

I receive unemployment insurance benefits or other benefits that require me to spend time working or looking for work. Can I still enroll?

Yes. Generally, Per Scholas courses are approved for people receiving unemployment insurance, as well as other benefits that would ordinarily require them to spend time working or looking for work. Your benefits should not be affected. If you have questions or concerns about your situation, please contact us.

I meet other requirements, but I am not a U.S. citizen and haven’t received my work authorization yet. Can I still apply?

Due to the nature of government contracts, learners must be eligible for employment based on Federal Contract employment eligibility.

I have childcare responsibilities. Can you accommodate me?

We have onsite staff available to help students navigate childcare options. Ask to speak with the Childcare Navigator when you attend an info session.

I have a disability. Can you accommodate me?

We comply fully with the Americans with Disabilities Act and other relevant laws and regulations. Please contact an Admissions team member to discuss your specific situation and needs.

Does Per Scholas have a Non-Discrimination policy?

We’re proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin. See our full EEO statement here.