Note: The job is a remote job and is open to candidates in USA. GreenSky® is a leading company in the Information Technology sector, and they are seeking a Principal Data Engineer. The role involves designing and executing software test plans for BI and Data Warehouse projects, optimizing SQL queries, and mentoring junior engineers on testing strategies.
Responsibilities
- Design, develop, and execute software test plans, strategies, and scenarios for BI and Data Warehouse projects
- Write, optimize, and automate complex SQL queries, T-SQL stored procedures, and views for Snowflake and MS-SQL Server to support both validation and development tasks
- Create and maintain automated test suites in Python and SQL for data validation and quality checks, focusing on business rule verification and report integrity
- Validate and test business intelligence reports built with SSRS, Tableau, and Sigma, ensuring data accuracy and alignment with requirements
- Develop and enhance test frameworks for ETL processes, primarily leveraging Talend, to support data movement and transformation pipeline quality
- Document test artifacts, outcomes, and recommendations, and collaborate with report developers and stakeholders to resolve discrepancies
- Participate in agile ceremonies, daily stand-ups, sprint planning, and business requirement calls, providing technical insights and updates
- Mentor junior engineers on testing strategies, SQL best practices, and BI tool utilization
Skills
- Bachelor's degree (U.S. or foreign equivalent) in Computer Science, Electronic Engineering, or related engineering field or related field
- Seven (7) years of experience in the job offered or in a related role
- Using SQL and T-SQL in Snowflake and MS-SQL Server environment
- Advanced knowledge of Python for scripting and automated testing
- Experience validating and testing reports in SSRS and Tableau
- Direct experience with ETL tools including Talend
- Working in agile teams and collaborating with cross-functional stakeholders
- Developing automated validation routines for report data and ensuring accurate representation of business metrics and KPIs
- Automating repetitive and complex testing processes to improve efficiency and reliability
Company Overview