Senior Enterprise SQL Developer (Banking & Financial Services)
MDAEdge · Dallas, TX · 3 wk ago
RemoteRemoteOTHRFull-time
Location: 100% remote (anywhere in the USA) or onsite in NYC/Dallas. No relocation offered; recent local projects are highly preferred.
Requirements
- Enterprise pedigree: recent experience within very large, globally recognizable enterprise environments (highly recognizable corporate brands required).
- Domain preference: banking, capital markets, or financial services experience is highly preferred and will receive first priority.
- Communication & language: English as a first language (native speaker) with exceptional, crystal-clear communication skills for heavy stakeholder interaction.
- Tenure & stability: demonstrated career stability with good tenure and a proven history of executing long-term projects.
- 10+ years (15+ years highly preferred) of hands-on experience writing and optimizing complex T-SQL (SQL Server preferred).
- Proven, recent experience working within very large, widely recognizable enterprise organizations.
- Track record of long-term consulting projects or excellent full-time tenure; ability to work independently in a long-term capacity, managing competing priorities across multiple stakeholders.
- Strong communication skills with the ability to clearly explain technical concepts to both technical and non-technical stakeholders.
- Demonstrated experience working alongside SSIS developers on ETL/data integration processes and Power BI developers, with a deep understanding of how data models feed reporting layers.
Responsibilities
- SQL development: design, develop, and optimize complex SQL queries, stored procedures, functions, and views to support business and reporting needs.
- Data integration: partner closely with SSIS developers to support and troubleshoot ETL packages, data flows, and integration processes.
- Reporting architecture: collaborate with Power BI developers to ensure data models and underlying SQL structures support efficient, accurate reporting and dashboarding.
- Quality assurance: perform data profiling, validation, and quality checks across source and target systems.
- Performance optimization: tune queries and indexes for performance across large, complex datasets.
- Business alignment: translate business requirements into technical specifications in partnership with stakeholders across business and technology teams.
- Maintenance: document data flows, schema changes, and technical processes for ongoing maintainability.
- Troubleshooting: troubleshoot and resolve data discrepancies, performance issues, and pipeline failures.
Preferred Qualifications
- Financial services experience (banking, capital markets, asset management, hedge fund, private credit, or related) is a strong plus and will be given priority consideration.
- Familiarity with data warehousing concepts and best practices.
- Experience supporting front-, middle-, or back-office reporting functions within financial services.