Senior Data Engineer
Overview
A leading financial services organization is seeking a Senior Data Engineer to join a high-performing technology team responsible for delivering enterprise data solutions that support financial reporting, operational analytics, regulatory requirements, and business decision-making.
This role will be responsible for building and maintaining the full data lifecycle, from source system integration and ETL development through modern cloud data platforms, data warehousing, and business intelligence enablement. The ideal candidate combines deep SQL and data integration expertise with hands-on experience modernizing data environments and delivering scalable, governed analytics solutions.
This is a hands-on engineering position focused on both maintaining critical production data processes and driving the evolution to a modern cloud-based data platform.
Key Responsibilities
Data Engineering & Database Development
- Design, develop, and optimize database solutions including schemas, stored procedures, functions, views, and high-performance queries.
- Manage database performance, indexing strategies, data modeling, and query optimization initiatives.
- Support mission-critical reporting and operational workloads through reliable and scalable database solutions.
- Perform troubleshooting and root cause analysis for production data issues.
Data Integration & ETL Development
- Build, maintain, and enhance enterprise data integration processes across internal and third-party data sources.
- Develop scalable ETL and ELT workflows to support operational and analytical use cases.
- Optimize existing data pipelines for performance, accuracy, and maintainability.
- Partner with business and technology teams to onboard new data sources and requirements.
Cloud Data Platform & Warehouse Engineering
- Design and develop modern data warehouse and lakehouse solutions using cloud-native technologies.
- Implement layered data architectures that transform raw data into curated, business-ready datasets.
- Apply dimensional modeling and best practices to create scalable, reusable analytics assets.
- Support cloud migration and modernization initiatives across enterprise data platforms.
Business Intelligence & Semantic Modeling
- Develop and maintain semantic models that support enterprise reporting and analytics.
- Design security frameworks and data access controls to ensure appropriate data visibility and governance.
- Partner with reporting and analytics teams to improve consistency, performance, and usability of business intelligence solutions.
- Support self-service analytics initiatives and enterprise reporting standards.
Data Quality, Governance & Production Support
- Implement validation, reconciliation, and data quality processes throughout the data lifecycle.
- Establish monitoring, alerting, and operational controls for critical data pipelines.
- Maintain data lineage, governance standards, and documentation.
- Ensure availability and reliability of data supporting finance, operations, regulatory reporting, and other business-critical functions.
Engineering Best Practices
- Implement version control, automated deployments, and CI/CD methodologies for data assets.
- Create and maintain operational runbooks, technical documentation, and support procedures.
- Support change management and release management processes.
- Promote best practices across data engineering, governance, security, and operational support.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline.
- 7+ years of experience in data engineering, database development, ETL development, or data integration roles.
- Advanced experience with Microsoft SQL Server and T-SQL development.
- Strong background in database design, performance tuning, indexing, and query optimization.
- Experience building and supporting enterprise ETL and ELT solutions.
- Hands-on experience implementing cloud-based data warehouses or lakehouse platforms.
- Strong understanding of dimensional modeling, star schema design, and modern analytics architectures.
- Experience supporting highly available production environments with strict operational and compliance requirements.
- Strong troubleshooting, analytical, and problem-solving abilities.
Technical Skills
- Microsoft SQL Server, T-SQL, stored procedures, database optimization, and performance tuning.
- Enterprise ETL and ELT development tools and frameworks.
- Modern cloud data platforms, lakehouse architectures, and data warehousing solutions.
- Data modeling, dimensional design, and analytics engineering best practices.
- Power BI development, semantic modeling, DAX, and data security concepts.
- Experience implementing row-level security and data governance controls.
- Working knowledge of Python for data processing, automation, and engineering tasks.
- Git, version control, deployment pipelines, and CI/CD methodologies.
Preferred Qualifications
- Experience within financial services, banking, capital markets, asset management, or other regulated industries.
- Experience supporting finance, accounting, treasury, operational reporting, or regulatory reporting functions.
- Experience with enterprise ERP integrations and data consolidation initiatives.
- Exposure to cloud migration, data modernization, or digital transformation programs.
- Experience supporting business intelligence and self-service analytics environments.
- Relevant cloud, analytics, or data engineering certifications.
What You'll Bring
- Strong data engineering fundamentals combined with modern cloud platform expertise.
- A proactive, solution-oriented mindset focused on reliability and continuous improvement.
- Excellent communication and stakeholder management skills.
- Experience balancing strategic modernization efforts with day-to-day production support responsibilities.
- Strong attention to detail and commitment to data quality.
- The ability to work independently while collaborating effectively across business and technology teams.
This is an excellent opportunity for a senior-level data professional looking to play a key role in modernizing enterprise data architecture, building scalable analytics platforms, and delivering high-impact solutions that support critical business operations and decision-making.