Software Engineering Data Engineer

What you'll do

• Design, build, and operate secure SQL Server and Amazon Redshift databases for myFICO.com.
• Build and maintain Python ETL/ELT pipelines to move and transform data across operational systems and warehouses.
• Tune SQL queries, indexes, and schemas to resolve latency and deadlocks on high-traffic sites.
• Prepare datasets for ML and AI applications using Jupyter notebooks and production pipelines.
• Automate SQL Server tasks such as backups, restores, and deployments using PowerShell scripting.
• Manage AWS data platforms including S3, Glue, Lambda, and RDS with strict encryption and access controls.
• Orchestrate workflows and manage CI/CD for database and pipeline code.
• Provide production ownership through code reviews, release management, and on-call support.

What we're looking for

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
• Demonstrated experience in data and database engineering.
• Hands-on Microsoft SQL Server administration including configuration, security, backup, recovery, and HA/DR.
• Expertise writing and tuning complex SQL queries, stored procedures, and PowerShell scripting.
• Strong Python for data engineering using pandas, NumPy, SQLAlchemy, or PySpark.
• Hands-on Amazon Redshift administration and tuning including distribution keys and workload management.
• Experience running and securing data platforms in AWS including S3, Glue, Lambda, and RDS.
• Experience with workflow orchestration, CI/CD, and AI data pipelines is a plus (preferred).