Sr. Data Warehouse Developer

Local Jobs Truist Financial in Software Development
  • United States, San Diego, CA 92103 View on Map
  • Post Date: June 18, 2020
  • Apply Before : July 18, 2020
  • Share:

Job Description

Specific information related to the position is outlined below. To apply, click on the button above. You will be required to create an account (or sign in with an existing account). Your account will provide you access to your application information. Need Help?


Should you have a disability and need assistance with the application process, please request a reasonable accommodation by emailing
Accessibility or by calling 877-891-2510. This email inbox is monitored for reasonable accommodation requests only. Any other correspondence will not receive a response.


Regular or Temporary:

Regular


Language Fluency:
English (Required)


Work Shift:

1st shift (United States of America)


Please review the following job description:

Researches, designs, implements, and modifies complex database solutions that meet business objectives while optimizing the use, security, and accessibility of data.

LightStream is an online consumer lending division of Truist Bank, and is located in San Diego, CA. Lightstream specializes in providing consumer loans to borrowers via the internet, offering a simplified and completely digital and paperless origination, underwriting and servicing experience to our customers. This is a progressive business where technology and innovation are at the heart of how we serve customers and solve business needs, and where our passion for delivering an exceptional customer experience runs deep. Please visit our website to learn about the loan process, www.lightstream.com.

The Sr. Database Warehouse Developer works in BI development team to participate in Enterprise database and data warehouse design and development using Microsoft SQL Server, Azure, PowerBI, and other analytic tools.


The job responsibilities include, but not limited to:

  • Solicit, analyze, and document functional and technical requirements. Use situationally appropriate strategies and practices to ensure stakeholder engagement.
  • Design, develop, enhance, and implement data warehouse solutions adhering to established frameworks and standards.
  • Create reports, dashboards, and data visualizations in a variety of reporting and BI tools. Maintain a deep understanding of application features and capabilities.
  • Implement solutions that align with requirements, best practices, and the technology ecosystem at LightStream.
  • Consistently deliver high-quality business intelligence solutions and services to clients on schedule
  • Work with DBA to provide production support and system performance tuning.
  • Actively participate in business and technical discussions in a team environment.
  • Follow, maintain and improve all documentation and procedures in the whole SDLC
  • Provide subject matter expertise for multiple projects concurrently through all phases of the development lifecycle.
  • Exercise flexibility in handling multiple tasks in this fast paced environment


Requirements

  • Bachelor’s degree in and 5 years of experience in database design and analysis or an equivalent combination of education and work experience
  • 5+ year experience using Microsoft SQL Server
  • 5+ year advanced T-SQL development and trouble shooting skills
  • 3+ year advanced ETL design and development skills using Microsoft SSIS tools
  • Strong knowledge of data warehouse design using Kimball methodology
  • Strong T-SQL performance tuning and trouble shooting skills
  • Strong report development skills using Microsoft SSRS
  • Experience in multi-dimensional cube design and development using Microsoft SSAS
  • Experienced report and dashboard development skills using PowerBI or other BI tools
  • Experience in C# development skills is preferred
  • Solid communication skills. Ability to documenting complex processes and oral communication with technical and non-technical employees
  • Strong work ethic, ability to work independently or in a team environment.
  • Experience in Azure is preferred
  • Experience in data mining and/or BI data analytics is preferred
  • Experience with Agile methodology


Truist supports a diverse workforce and is an Equal Opportunity Employer who does not discriminate against individuals on the basis of race, gender, color, religion, national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Drug Free Workplace.

Thank you for your interest in Truist! BB&T and SunTrust have come together in a transformational merger of equals to create Truist, the premier financial organization in the country. You may notice references to our legacy company names, BB&T and SunTrust, in places throughout this site. All such references should be understood to refer to Truist moving forward while we continue to transition to the Truist name.

EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify


Thank you for your interest in Truist! BB&T and SunTrust have come together in a transformational merger of equals to create Truist, the premier financial organization in the country. You may notice references to our legacy company names, BB&T and SunTrust, in places throughout this site. All such references should be understood to refer to Truist moving forward while we continue to transition to the Truist name.

 

New or Coming Soon Useful Entrepreneurship Books


Entrepreneurship Books

An Entrepreneur’s Guide To The Sales & Marketing Universe: A Step-By-Step Guide To Organic Marketing

An Entrepreneur's Guide To The Sales & Marketing Universe: A Step-By-Step Guide To Organic Marketing

Secret strategies revealed on how to generate high quality leads efficiently and effectively.

But leads, no matter how good, are pretty much useless without the skills necessary to convert them into paying customers. What is the repeatable and scientific approach to take in sales to make sure you are maximizing your chances at landing closed deals?

VIEW BOOK


Breaking Through The Wall: A Financial Advisor’s Guide to Grow, Scale, and Monetize Your Business for Millions

Breaking Through The Wall: A Financial Advisor's Guide to Grow, Scale, and Monetize Your Business for Millions

Many financial advisors out there are facing a wall. ­They’re generating $1-3 million in revenue; they’re managing all the households they can; they have little time to spend with their own families. ­ They feel like they’re playing chief marketing officer, chief investment officer, CEO, CFO, chief compliance officer, and the chief technology officer all at once. ­There just aren’t enough hours in the day.

VIEW BOOK


Entrepreneurial Marketing and International New Ventures: Antecedents, Elements and Outcomes (Routledge Studies in Entrepreneurship)

Entrepreneurial Marketing and International New Ventures: Antecedents, Elements and Outcomes (Routledge Studies in Entrepreneurship)

The book investigates the entrepreneurial marketing (EM) concept within the broader discipline of international entrepreneurship. The analysis of this concept, and designing a model of EM antecedents, elements, and outcomes that was tested on the basis of empirical studies covering companies from three European countries, explores and develops the field of international marketing and entrepreneurship.

VIEW BOOK


The Innovation Stack: Building an Unbeatable Business One Crazy Idea at a Time

The Innovation Stack: Building an Unbeatable Business One Crazy Idea at a Time

From the cofounder of Square, an inspiring and entertaining account of what it means to be a true entrepreneur and what it takes to build a resilient, world-changing company.

VIEW BOOK


The Age of Influence: The Power of Influencers to Elevate Your Brand

The Age of Influence: The Power of Influencers to Elevate Your Brand

If today’s brands want to succeed, they have to be in the conversation, and influencers make that happen. The Age of Influence is an essential guide for marketing professionals and business owners who want to create and implement a highly effective and sustainable influencer marketing plan.

We are in the midst of an unprecedented digital transformation and tapping into this change is vital to any brand in today’s climate. Social media has democratized authority and influence, and information is created and consumed in ways that are constantly evolving.

VIEW BOOK


12 Months to $1 Million: How to Pick a Winning Product, Build a Real Business, and Become a Seven-Figure Entrepreneur

12 Months to $1 Million: How to Pick a Winning Product, Build a Real Business, and Become a Seven-Figure Entrepreneur

Your road map to a seven-figure business . . . in one year or less

By cutting out the noise and providing a clear and proven plan, this roadmap helps even brand-new entrepreneurs make decisions quickly, get their product up for sale, and launch it to a crowd that is ready and waiting to buy.

VIEW BOOK


The Prosperity Principles: How to Think and Act Like a Millionaire

The Prosperity Principles: How to Think and Act Like a Millionaire

This is a book to help you acquire the mind-set to riches.
It’s about creating a way of living where you aren’t controlled by fear, inertia, or poverty. You, instead, are motivated by creative, positive action, and an open mind that is ready to receive prosperity in every area of your life. Here are the time-tested principles used by the self-made millionaires and billionaires to create lives beyond their wildest imaginations. Here are the time-tested principles that will help you tap into your inner reserves and knowledge you never knew you had. These writings—compact, powerful, practical—are ready to help you find solutions, discover new ideas, and make fresh starts on your road to riches!

VIEW BOOK


CEO’s Insight On Sales And Marketing: Mentorship From A CEO: Power of Successful Habits

CEO's Insight On Sales And Marketing: Mentorship From A CEO: Power of Successful Habits

This book is a compilation of successful habits that the author has learned in his career. I would even saythat this book is a manual of lessons for entry-level, junior manager, and even executives. It offers tips from the expert on medical device sales, as well as fundamental knowledge for any employee. As you read through the sincere yet passionate advice from the author on work strategy to a personal relationship, you will start to gain an overview of the the direction of your path. The vital key to success includes extreme self-discipline and a genuine passion for work.

VIEW BOOK


Mentor Made Millionaire

Mentor Made Millionaire

Mentor-Made Millionaire is an insightful, thought-provoking dissection of what it takes to be a success in today’s money-centric society. It is designed to appeal to individuals on the path to success, managers, and business owners.

These days, we see the well-worn phrase ‘self-made millionaire’ practically everywhere. While Dr. Chad Shannon does not set out in Mentor-Made Millionaire to diminish the hard work put in by those remarkable individuals who achieve this accolade, his aim is to make the reader realize that not one of them could possibly have accomplished that aspirational status all by themselves.

VIEW BOOK


The Art of Startups: How to Beat Larger Companies Using Machiavellis War Strategies

The Art of Startups: How to Beat Larger Companies Using Machiavellis War Strategies

Startups constantly face the challenge of how to make an impact given their initial small size and limited resources. Nine out of ten startups fail and more than fifty percent do not reach past the five-year mark. The few that do manage to survive can quickly find themselves swamped in the oversaturated market, unable to make any decent progress. So how can they establish themselves among their immediate competitors, let alone defeat larger, more established companies? Is the story of David and Goliath still relevant in the modern business world?

VIEW BOOK


Research, Innovation and Entrepreneurship in Saudi Arabia: Vision 2030 (Routledge Studies in Innovation, Organizations and Technology)

Research, Innovation and Entrepreneurship in Saudi Arabia: Vision 2030 (Routledge Studies in Innovation, Organizations and Technology)

This book provides valuable insights into the Kingdom of Saudi Arabia (KSA) through a comprehensive examination of Vision 2030, an ambitious economic plan by the KSA to reinvent and diversify its economy from a heavy dependence on hydrocarbon to knowledge-based resources.

Research, Innovation and Entrepreneurship in Saudi Arabia: Vision 2030 discusses how this initiative will assist the government in achieving its envisioned goals by creating a culture of research, innovation and entrepreneurship. It studies the current state of the field as well as new policies and reforms in Saudi Arabia which encompass education systems, ICT infrastructure and a vibrant innovation landscape that includes academia, the public and private sectors and civil society.

VIEW BOOK


Read More

Other jobs you may like