Sr. Data Engineer

ABOUT NEXT COLLEGE STUDENT ATHLETE (NCSA)

NCSA is the world's largest and most successful collegiate athletic recruiting network. A wholly-owned subsidiary of Reigning Champs LLC ( www.reigningchamps.com ), NCSA's 700 teammates leverage exclusive data, proprietary matching algorithms, and personal relationships built over nearly two decades as the industry leader to connect tens of thousands of college-bound student-athletes to more than 35,000 college coaches nationwide across 34 sports every year. You can learn more about NCSA at  www.ncsasports.org .

Data Engineer Job Details

NCSA (Next College Student Athlete) is growing our Software Development team and we are looking for someone to lead a portion of the team, define and refine the process used across the team, and provide clear reporting on the progress made.

You’ll be working with a collaborative team of QA engineers, data scientists, analysts, developers, and product managers, so you’ll need to be able to articulate your decisions and take feedback into the next iteration. Want to work with a great team to make students’ lives better? Great!

We need a top-notch Data Engineer to help vault forward our growing data team.  You will be integral in improving the structure of our data, expanding our data sources, maintaining the integrity of our data systems and taking our data warehousing to the next level.  We have a lot of interesting data and we want you to help us get the most out of it.

Responsibilities

• Develop and maintain a data pipeline to collect, transform, store, maintain and audit structured and unstructured data sources
• Define and implement standards for data hygiene to ensure accuracy, immediacy and integrity
• Build the infrastructure for an optimal ETL on a wide variety of data sources using the AWS big data toolkits
• Coordinate data accumulation from internal and external sources, including paid sources and scraping projects
• Own the ETL workflow including reliable error and exception handling, with a robust rollback framework.
• Help analyze, maintain and improve database servers and systems (MS-SQL, Postgres, MySQL), both on-prem and in the cloud
• Provide expertise in data security, query optimization and data structure definition
• Create tools for analysts and data consumers that will improve the availability and depth of data across the organization

Qualifications

• Bachelor’s degree in Computer Science or a related Engineering field (or relevant experience)
• 3+ years of experience in a Data Engineering or DBA role
• MS-SQL and Postgres experience, MySQL a plus
• Experience with AWS Cloud Services: Redshift, EC2, EMR, RDS, etc.
• Solid understanding of relational, NoSQL and columnar databases
• Excellent oral and written communication skills
• Experience with a scripting or programming language (R, Ruby, Python, Java, etc)

Preferred Qualifications

• Experience with Hadoop, Kafka or Spark
• Un-afraid to manage up or sideways
• Familiarity with standard source control methods
• A team-player, always looking to make things better and easier for a co-worker

Benefits

• Comprehensive Medical, Dental, & Life Insurance
• Pre-Tax Flex Spending Account
• 401(k) Match Up to 3%
• Parental Leave
• Wellness Reimbursement Program
• Online Health Assessments
• EAP

National Collegiate Scouting Association LLC is committed to providing equal employment opportunities to all employees and applicants without regard to race, religion, color, sex, national origin, citizenship status, uniform service member status, age, disability, sexual and gender orientation, genetic information or any other protected status in accordance with all applicable federal, state, and local laws.