Data Engineer

Insight Global is seeking a Data Engineer to join one of our clients in the education management industry. This role will be onsite in McLean VA four (4) days per week and will focus heavily on SQL development and reporting through Power BI.

In this role, the data engineer serves both our client’s business partners as well as the Information Technology (IT) organization delivering high quality products with timely business impact. You will be responsible for helping our client’s business partners engage successfully with their products and services, acting as a bridge between the IT organization and the various business teams. The primary responsibilities are to construct optimized SQL queries and perform data transformations to support various reporting needs. You will ensure data accuracy, consistency, and proper alignment with established business rules and definitions, as well as thoroughly document calculations, business logic, data definitions, constraints, and dependencies associated with every report. Troubleshooting reporting issues, validating data anomalies, and communicating findings in a clear manner to stakeholders are key responsibilities.
Responsibilities include but are not limited to:
- Design, develop, and maintain robust data pipelines to automate the extraction, transformation, and loading (ETL) of data from diverse sources.
- Write efficient Python scripts to clean, validate, and preprocess large datasets, ensuring high standards of data quality and reliability.
- Develop, test, and deploy comprehensive reports and dashboards utilizing established tools such as PowerSchool’s Enterprise Reports, Power BI, and SQL-based reporting platforms.
- Construct optimized SQL queries and perform data transformations to support various reporting needs.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

- 3+ years of experience as a Data Engineer
- Experience writing SQL queries with relational databases (Ideally, Oracle and PostgreSQL )
- Experience working with AWS Services (S3, IAM, RDS, SQS, Lambda)
- Experience with Power BI
- Bachelor’s degree in computer science or related field

- PowerSchool Enterprise Reports
- Experience with cloud-based data warehouses – ideally Amazon Redshift
- Experience building data pipelines
- Python scripting experience

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.