At a Glance
- Tasks: Lead the design and optimisation of cloud-native database solutions.
- Company: Join J.P. Morgan, a global leader in financial services.
- Benefits: Competitive salary, diverse workplace, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on diversity and inclusion.
- Why this job: Make a real impact by driving innovative data strategies and solutions.
- Qualifications: Strong SQL skills and experience with major RDBMS required.
The predicted salary is between 63000 - 77000 £ per year.
Job responsibilities Author and optimize queries for performance and correctness.
Monitor and tune database performance, including query tuning, indexing, partitioning, and caching.
Build and maintain monitoring, alerting, and observability for database systems.
Support production incidents and perform root cause analysis; participate in on-call rotations.
Assist application teams with data access patterns, migrations, and release planning.
Engage technical teams and business stakeholders to discuss and propose data architecture approaches to meet current and future needs.
Evaluate recommendations for new technologies and provide actionable feedback.
Execute creative data architecture solutions, including design, development, and technical troubleshooting, with the ability to think beyond routine or conventional approaches to build solutions or break down technical problems.
Develop secure, high-quality production code; review and debug code written by others.
Identify opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems.
Required qualifications, capabilities, and skills Strong SQL skills, including complex joins, window functions, aggregates, subqueries, and explain/analyze plans.
Experience with at least one major RDBMS: Postgre SQL, My SQL/Maria DB, Microsoft SQL Server, or Oracle.
Performance tuning experience, including indexing strategies, query profiling, and execution plan interpretation.
Experience with monitoring and observability tooling such as Prometheus, Grafana, Datadog, Dynatrace or New Relic.
Familiarity with versioned schema migrations using tools such as Flyway, Liquibase, Alembic, or sqitch.
Good understanding of storage, IOPS, and how database workload relates to underlying infrastructure.
Familiarity with cloud-managed databases and their operational tradeoffs, including AWS RDS/Aurora, Google Cloud SQL, and Azure SQL/DMS.
Strong troubleshooting skills and experience handling production incidents.
Proficiency in automation and continuous delivery methods.
Proficient in all aspects of the Software Development Life Cycle.
Advanced knowledge of one or more software, application, and architecture disciplines, with the ability to evaluate current and emerging technologies to recommend the best data architecture solutions for future state architecture.
Morgan is a global leader in financial services, providing strategic advice and products to the world's most prominent corporations, governments, wealthy individuals and institutional investors.
Our first-class business in a first-class way approach to serving clients drives everything we do.
We strive to build trusted, long-term partnerships to help our clients achieve their business objectives.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success.
We are an equal opportunity employer and place a high value on diversity and inclusion at our company.
We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law.
We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.
Visit our FAQs for more information about requesting an accommodation.
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing.
Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.
As a Lead Data Architect at JPMorgan Chase, within CTO, you will drive cloud-native database solutions as a key technical contributor, partnering with engineering teams and business stakeholders to define data strategies and deliver innovative solutions across the full SDLC.
You will tune complex queries, manage indexing strategies, build observability frameworks, and support production incidents across multiple business functions. #J-18808-Ljbffr
Lead Architect- Data & Database Systems employer: Next Frontier Capital
Next Frontier Capital is an exceptional employer, offering a vibrant work culture that fosters collaboration and innovation within the EMEA Energy sector. Employees benefit from comprehensive professional development opportunities, competitive compensation packages, and the chance to lead high-impact M&A and capital markets transactions in a dynamic environment. Join us to be part of a team that values strong leadership and proactive engagement, ensuring meaningful contributions to the energy landscape.
StudySmarter Expert Advice🤫
We think this is how you could land Lead Architect- Data & Database Systems
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Next Frontier Capital!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Lead Architect- Data & Database Systems at Next Frontier Capital.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Next Frontier Capital.
✨Apply Directly through Our Website
When you find a suitable opening like Lead Architect- Data & Database Systems at Next Frontier Capital, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Lead Architect- Data & Database Systems
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Next Frontier Capital, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Next Frontier Capital. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Next Frontier Capital
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Next Frontier Capital!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
