Principal Engineer I, BI & Analytics
Core
Designing, developing, and maintaining robust database solutions and ETL/ELT pipelines to deliver actionable insights to leadership and cross-functional teams.
Role type
Principal Data Engineer (BI & Analytics)
Builds
MS SQL data marts, scalable ETL/ELT pipelines, and data models for self-service reporting
Domain
Financial Services / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL Server administration, complex SQL query writing, ETL/ELT process design, AWS cloud services (S3, IAM, Lambda), Apache Airflow orchestration, SSIS package development, data modeling concepts
Preferred skills
Snowflake knowledge, Power BI familiarity
Technologies
MS SQL Server, T-SQL, Airbyte, dbt, AWS Glue, Apache Airflow, Stonebranch UAC, SSIS, Power BI, Snowflake
Responsibilities
Designing and maintaining data mart environments including tables, stored procedures, and views; Building and optimizing data models for analytics and reporting; Writing complex SQL queries; Designing and maintaining scalable ETL/ELT pipelines; Optimizing SQL queries and ETL jobs for performance; Ensuring scalability and reliability of data pipelines; Collaborating with BI developers and analysts; Providing technical support and troubleshooting data pipeline failures; Implementing monitoring and alerting mechanisms; Maintaining documentation for data flows and processes; Resolving blocking, deadlocks, and inefficient queries; Proactively addressing data quality issues
Seniority
Principal, hands-on IC