Senior Business Intelligence (BI) Engineer (Remote)

Be a Part of our Team!

Join a working family that is dedicated to the mission of the work we do!

Teaching Strategies is an innovative edtech organization focused on connecting teachers, children, and families. As front runners in the early childhood education market, we build dynamic, top-quality digital products that integrate all of the essential elements of a high-quality solution: curriculum, assessment, professional development, and family engagement. We are building a team of results-oriented individuals who will thrive in a collaborative, work-hard/play-hard culture. We pride ourselves on the impact we have on the early childhood field through supporting teachers who are doing the most important work there is, teaching children to become creative, confident thinkers.

Position Overview

At Teaching Strategies, we believe that significant value comes from the use of data. We are seeking a Sr. BI Engineer to join our Data team to work on data products for our customer base. As part of a team, you will be initially focusing on modernizing our reports. You will be responsible for creating or migrating SQL queries to work on a new data model and implementing a pipeline to incrementally refresh data in Databricks to generate a report-ready dataset. To be successful in this role, you will need to quickly gain knowledge of our data model, utilize your deep knowledge of SQL to convert queries to the new data model, and use your engineering prowess to implement that pipeline with support by our data engineering team.

As you grow in your role, you will develop solutions that meet the data needs of the business and the engineering organization as we grow domestically and internationally. You will partner with your colleagues to detail data models and standardize data transformations that scale to meet our expanding reporting needs to allow for rapid creation of customer facing reports. With your passion for data, you will be able to demonstrate your exceptional problem-solving skills and articulate intricate technical details with clarity while leaning heavily on your ability to collaborate and be a team player. Come join our team; we can't wait to work with you!

Specific Roles & Responsibilities:

• Using SQL to extract data from our Lakehouse databases and create reports and dashboards for our SaaS customer facing products
• Perform data validation, verification, and analysis tasks to ensure data integrity and derive actionable insights
• Collaborate with data experts and quality assurance partners to understand data issues and provide timely resolutions and insights
• Develop and maintain SQL queries and scripts for reporting and data analysis
• Monitor data quality and implement improvements to ensure efficient data operation and accurate reporting
• Provide technical support for data-related issues, including troubleshooting and performance tuning
• Ensure compliance with data security and privacy regulations

Qualifications:

• Strong ability to decipher, write and optimize SQL queries; proficiency in Python is a plus
• Experience resolving common SQL issues to maintain data integrity
• Demonstratable ability to learn data models quickly
• Experience deploying ETL/ELT data pipelines; DataBricks experience is preferred
• Solid grasp on data modeling, data warehousing, and ETL techniques
• Experience with very large datasets, and building aggregations and computations in SQL at scale
• Experience with Git/Bitbucket for source control
• Knowledge of AWS and GCP cloud services
• Experience with Postgres and other RDBMs
• Experience with performance testing
• Independent work style with strong problem-solving skills
• Self-starter with sharp attention to detail
• Outstanding verbal and written communication abilities
• Five (5) or more years of hands-on experience creating complex SQL in data analysis or a similar role
• A bachelor's degree or equivalent experience in computer science, engineering, or a related field; master's degree preferred

Why Teaching Strategies

At Teaching Strategies, our solutions and services are only as strong as the teams that create them. By bringing passion, dedication, and creativity to your job every day, there's no telling what you can do and where you can go! We provide a competitive compensation and benefits package, flexible work schedules, opportunities to engage with co-workers, access to career advancement and professional development opportunities, and the chance to make a difference in the communities we serve.

Let's open the door to your career at Teaching Strategies!

Some additional benefits & perks while working with Teaching Strategies

Teaching Strategies offers our employees a robust suite of benefits and other perks which include:

• Competitive compensation package
• Employee Equity Appreciation Program
• Health and wellness insurance benefits
• 401k with employer match
• Flexible work environment
• Unlimited paid time off (which includes paid holidays and Winter Break)
• Paid parental leave
• Tuition assistance, professional development, and opportunities for career growth
• Best in class technology equipment for every employee
• Penthouse suite in downtown DC seconds away from Washington Nationals Stadium and Audi Field

Teaching Strategies, LLC is committed to creating a diverse workplace and is proud to be an equal opportunity employer of Minorities, all Genders, Protected Veterans, and Individuals with Disabilities.

Equal Employment Opportunity (EEO)

Family and Medical Leave Act (FMLA)

Employee Polygraph Protection Act (EPPA)