Software Engineering – Data Engineer (Python & Cloud Databases)
About The Position
The myFICO engineering team builds the web applications behind FICO Scores’ consumer-facing business, with data powering its products and services. The Lead Data Engineer will own the SQL Server, Amazon Redshift, and other cloud databases behind myFICO.com; build and operate Python ETL/ELT pipelines feeding the data warehouse and analytics platforms; and prepare data for emerging machine learning and AI use cases in AWS. The role includes database design and production support, data modeling and transformation, performance tuning, security, workflow orchestration, and production ownership. The engineer will collaborate with product and marketing teams to modernize data environments and support analytics and AI use cases.
Requirements
- Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field, with demonstrated experience in data and database engineering.
- Hands-on Microsoft SQL Server administration, including configuration, security and permissions, backup and recovery, index and statistics maintenance, monitoring, and high availability/disaster recovery.
- Expertise writing and tuning complex SQL queries and stored procedures.
- PowerShell scripting to automate SQL Server tasks such as backup and restore, environment refreshes, and deployments.
- Strong Python for data engineering, using tools such as pandas, NumPy, SQLAlchemy, or PySpark; comfort with Jupyter notebooks; and proven experience building transformation pipelines and data warehouse models.
- Hands-on Amazon Redshift administration and tuning, including distribution and sort keys, workload management, and permissions.
- Experience running and securing data platforms in AWS, such as S3, Glue, Lambda, or RDS, including encryption and access control for sensitive consumer data.
- Workflow orchestration experience with Airflow, Step Functions, or similar, and CI/CD for database and pipeline code.
- Production ownership experience, including code review, release management, and on-call support.
- Strong communication skills and experience working in Agile/Scrum teams.
Nice To Haves
- Experience with data pipelines for AI applications, including RAG workflows, vector stores, or MCP server integrations.
- Experience with ML tools such as scikit-learn or SageMaker.
- Experience with NoSQL databases.
- Experience with infrastructure as code.
- Experience with BI tools such as Tableau.
- AWS certifications.
Responsibilities
- Design, build, and operate secure, high-performance SQL Server and Redshift databases supporting myFICO.com, from data modeling through production support.
- Build and maintain Python ETL/ELT pipelines that move and transform data across operational systems, the data warehouse, and analytics platforms.
- Explore data in Jupyter notebooks, prepare datasets for ML and AI applications, and convert prototypes into scheduled, monitored production pipelines.
- Tune queries, indexes, and schemas to address latency, blocking, and deadlocks on a high-traffic consumer site.
- Use AI coding assistants, LLMs, and agentic workflows to accelerate development while reviewing and refining their output.
- Work with product and marketing teams to modernize data environments, support analytics and AI use cases, and expand data-driven decision-making.
- Own production work, including code review, release management, and on-call support.
Benefits
- Competitive compensation, benefits, and rewards programs.
- Learning experiences and opportunities for professional development.
- Work/life balance.
- Employee resource groups.
- Social events to promote interaction and camaraderie.
- Inclusive, people-first work environment.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
