Lead Software Engineer - Big Data
About The Position
Working independently, the Lead Software Engineer owns development of software products and works on improving the overall quality of the product throughout the software development life cycle and mentors other Software Engineers. Reports directly to a Director or Senior Director. Essential Job Functions: Seasoned contributor that works on complex projects requiring extensive knowledge of specialty area and industry practices Manages processes, projects or products to improve efficiency within org or product area Influences outcomes in cross-functional settings Demonstrates solid understanding of systems and processes within job area and recommends improvements Designs and develops industry-leading solutions that meet defined quality standards, reliability specifications, and help achieve key strategic objectives Ensures comparison of tasks and quality of work, supporting peers to ensure the team delivers consistently Excellent understanding in computer science fundamentals - Algorithm design, Problem solving, Complexity analysis and data structures. Engineering/Operations Excellence: Helps identify gaps between system components and designs and delivers solutions Implements methods for managing and maintaining the organization’s software development environments to ensure software engineers are equipped with the tools and resources necessary to create and validate builds Takes broad perspective to problems and exercises independent judgement in techniques and evaluation criteria to obtain results Develops actionable insights from analyzing software development trends, software engineering best practices, and innovative test environment management tools and communicates integration recommendations to management Identifies ways to overcome challenging situations that jeopardize the achievement of business goals Collaboration: Coaches and trains less experienced colleagues in techniques, processes, and responsibilities Integrates the culture of intelligence, integrity, and initiative into team goals and decisions Partners within and across teams to remove barriers and identify shared goals and priorities Openly shares progress and priorities with key stakeholders, communicating complex or technical information at the right level. Demonstration of FINRA’s values. Collaboration, both in-person and virtually, in furtherance of FINRA’s mission of investor protection and market integrity.
Requirements
- Extensive hands-on experience with Hadoop, Spark, Hive, and Trino for processing petabyte-scale datasets.
- Proven ability to diagnose and resolve data skew, resource limitations, scalability challenges, and job failures in production environments.
- Deep understanding of Spark architecture including executors, tasks, stages, and DAG execution.
- Demonstrated proficiency in performance tuning techniques such as partitioning strategies, caching, broadcast joins, and optimization of large-scale data processing jobs.
- Advanced proficiency in complex SQL including window functions, multi-table joins, aggregations, and query optimization.
- Experience handling edge cases involving NULLs, duplicates, and ordering in production environments.
- Strong experience with AWS services including S3, EMR, Glue, Lambda, Athena, EKS, and serverless architectures.
- Practical knowledge of file format optimization, consistency management, and cloud-based data processing workflows.
- Proficiency in writing clean, modular, and performant code using Python or Scala.
- Strong understanding of functional programming concepts (immutability, higher-order functions), collections, concurrency, and memory management for scalable data processing.
- Hands-on experience with AI development tools (GitHub Copilot, Q Developer, ChatGPT, Claude, etc.) and AI workflow design.
- Proven ability in prompt engineering and leveraging AI coding assistants for enhanced productivity.
- Extensive experience with Scrum, Kanban, and continuous improvement practices.
- Demonstrated experience leading teams through AI adoption, technology transformation, and workflow optimization initiatives.
- Strong system design experience with ability to architect scalable, distributed data processing solutions and enterprise-level applications.
- Strong experience in object-oriented programming principles, design patterns, and software engineering best practices.
- Strong experience with modern data storage solutions, database technologies, and data modeling approaches for both relational and NoSQL systems.
- Demonstrated expertise in identifying bottlenecks and optimizing application and data processing performance across the full stack.
- Strong experience with DevOps practices, continuous integration, continuous deployment pipelines, and infrastructure as code.
- Strong understanding of security best practices, secure coding principles, and application security across all layers.
- Ability to interpret AI-generated insights and data-driven metrics, translating them into actionable technical improvements and measurable business value.
- Bachelor’s degree in Computer Science, Information Systems or related discipline with at least 7 years of related experience, or equivalent training and/or work experience.
- Strong system design experience
- Strong experience in object-oriented development
- Strong experience with cloud technologies
- Strong experience in data storage technologies
- Strong experience in performance tuning and optimization
- Strong experience in DevOps and CI/CD technologies
- Strong experience test automation and unit testing
- Strong experience software security
Responsibilities
- Owns development of software products
- Improves the overall quality of the product throughout the software development life cycle
- Mentors other Software Engineers
- Works on complex projects requiring extensive knowledge of specialty area and industry practices
- Manages processes, projects or products to improve efficiency within org or product area
- Influences outcomes in cross-functional settings
- Designs and develops industry-leading solutions that meet defined quality standards, reliability specifications, and help achieve key strategic objectives
- Ensures comparison of tasks and quality of work, supporting peers to ensure the team delivers consistently
- Helps identify gaps between system components and designs and delivers solutions
- Implements methods for managing and maintaining the organization’s software development environments to ensure software engineers are equipped with the tools and resources necessary to create and validate builds
- Takes broad perspective to problems and exercises independent judgement in techniques and evaluation criteria to obtain results
- Develops actionable insights from analyzing software development trends, software engineering best practices, and innovative test environment management tools and communicates integration recommendations to management
- Identifies ways to overcome challenging situations that jeopardize the achievement of business goals
- Coaches and trains less experienced colleagues in techniques, processes, and responsibilities
- Integrates the culture of intelligence, integrity, and initiative into team goals and decisions
- Partners within and across teams to remove barriers and identify shared goals and priorities
- Openly shares progress and priorities with key stakeholders, communicating complex or technical information at the right level.
- Demonstrates FINRA’s values.
- Collaborates, both in-person and virtually, in furtherance of FINRA’s mission of investor protection and market integrity.
Benefits
- health, dental and vision insurance
- basic life, accidental death and dismemberment, supplemental life, spouse/domestic partner and dependent life, and spouse/domestic partner and dependent accidental death and dismemberment, short- and long-term disability, long-term care, business travel accident, disability and legal.
- immediate participation and vesting in a 401(k) plan with company match
- eligibility for participation in an additional FINRA-funded retirement contribution
- tuition reimbursement
- commuter benefits
- adoption assistance
- backup family care
- surrogacy benefits
- employee assistance
- wellness programs
- 15 days of paid time off
- 5 personal days
- 9 sick days
- two volunteer service days
- military leave
- jury duty leave
- bereavement leave
- voting and election official leave for federal, state or local primary and general elections
- care of a family member leave (available after 90 days of employment)
- childbirth and parental leave (available after 90 days of employment)
- nine paid holidays
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
