Senior Data Engineer at Ascent

San Diego, California, United States -

Full Time

Start Date

Immediate

Expiry Date

03 Jun, 26

Salary

135000.0

Posted On

05 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Sql, Python, Aws, Data Pipelines, Data Modeling, Spark, Glue, Ssis, Rest Apis, Tableau, Looker, Power Bi, Scala, Dbt, Airbyte, Dimensional Modeling

Industry

IT Services and IT Consulting

Description

Description Ascent is a leading provider of innovative financial products and student support services that enable more students to access education and achieve academic and economic success. Everything Ascent offers is designed with the best-in-class teams and technology to increase every student's ability to plan, pay, and succeed in their education and career. Ascent's planning tools and financing resources are co-created by students for those in college, graduate school, and career training programs. Ascent offers financial wellness education, student success services, and one-on-one and digital career coaching that put students' academic and professional goals within reach. Ascent has been widely recognized for its strong culture – named “Best Places to Work” by the San Diego Business Journal for the past 5 years – and as an industry leader – named “Best Student Loan” by NerdWallet for the past 3 years. This job description outlines the objective, primary responsibilties, requirements and qualifications of the Senior Data Engineer. We hope you: Find data thrilling and have the drive to be self-directed, flexible, and responsive to business needs. Enjoy leveraging data to tell a story that helps direct team efforts for maximum impact. Are comfortable working in a fast-paced, analytics-driven environment with a team that is looking to grow. In this role you will: Work with stakeholders including Executive, Product, Data and Marketing teams to assist with data-related technical issues and support their data infrastructure needs. Assemble large, complex data sets that meet functional / non-functional business requirements. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python and AWS ‘big data’ technologies. Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics. Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader. Be proactive to identify systems and processes the improve efficiencies and support greater access to meaningful data that empowers key stakeholders throughout the organization. Find ways to ensure clean data and reduce risk of fraud. Desired Skills & Expertise: Bachelor’s Degree required in Computer Science, Engineering, Statistics, Applied Mathematics, Informatics, Information Systems, or another quantitative field. 5+ years of experience in a data engineering role. Enjoy working in cross-functional teams and providing feedback to senior management. Exceptional analytic and strategic thinking skills related to working with structured and unstructured data sets. Experience and proficiency with… Advanced SQL and procedural practices. Building and optimizing data pipelines, architectures, and data sets. Performing root cause analysis on internal/external data, identifying improvement opportunities. Relational databases (MS SQL Server, Postgres, MySQL) and NoSQL databases. AWS cloud services (EC2, EMR, RDS, Redshift) and AWS Data Pipeline. Big data pipeline tools like Spark, Glue and SSIS Sourcing and modeling data from REST APIs. Data visualization systems like Tableau, Looker or Power BI. Object-oriented scripting languages (Python, Scala). Optimize performance in Amazon Redshift Design Scala data architecture Pipelines. Experience with DBT and Airbyte(Or similar ETL tool). Strong dimensional modeling capabilities. Development operations in the data engineering space (git, ci/cd pipelines). Must be able to think outside of the box, enjoy being challenged to grow your skills, and not be afraid to step outside of your comfort zone. Bonus points if you have: Past consumer finance experience and / or experience in a highly regulated environment. Experience in Dagster and Kubernetes MBA or Master’s degree in Computer Science, Engineering, Statistics, Applied Mathematics, Informatics, Information Systems or another quantitative field. Competitive pay with bonus, and comprehensive benefits package that includes, but not limited to: Compensation includes base salary of $125,000 - $135,000 commensurate with experience, plus bonus and options. Company Stock Options 401(k) + Company Match Medical, dental, and vision coverage Annual HSA contribution of $1,650 Life insurance, disability, and critical illness 14 Paid Holidays! Eleven (11) + Two (2) Community Days + Your Birthday! Snacks and drinks in the office Tuition reimbursement program Generous paid leave policies $2,000 Vacation Incentive Plan after 3 years + $1,000 Sabbatical Day Wellness, Work from Home funds, and more!

Responsibilities

The role involves working with stakeholders to support data infrastructure needs, assembling complex datasets, and building infrastructure for optimal extraction, transformation, and loading of data using SQL, Python, and AWS big data technologies. Additionally, the engineer will build analytics tools for actionable insights and create data tools to assist analytics and data science teams.