Data Engineer I (No Remote Option-Hybrid Work Environment)

Company: Advisor360 -
Location: Orlando
Posted on: August 6, 2022

Job Description:

------The Data Engineer role will be part of Advisor360 -'s Engineering organization as a member of our Data Pipeline team. You will be responsible for mapping, cleansing, and transforming data from outside data sources and integrating them into Advisor360 -'s application. You are passionate about leveraging modern technology and building scalable and efficient data pipelines, processes, and capabilities.
Key responsibilities

• Work collaboratively with team members to migrate data from advisor offices into Advisor360 -'s platform.
• Create, maintain, and support software and data processes
• Write code utilizing SQL to fulfill client data requests in a timely manner
• Quickly diagnose and resolve incoming bugs
• Use modern approaches and tools to automate systems and processes
• Collaborate with team members on effective development practices, communicating with tact and professionalism
• Produce well written, efficient, and maintainable code related to data processes and presentation
  Requirements
  • Write efficient and maintainable code including SQL-stored procedures
  • Strong SQL & T SQL coding skills required
  • Strong data analytics skills, including the ability to break down data models efficiently
  • Develop software solutions by analyzing information needs; conferring with users; and studying systems flow, data usage, and workstream processes
  • Troubleshoot, debug, and upgrade existing systems and processes
  • Document and maintain software functionality and data processes
  • Create, enhance, and maintain data processes, always seeking new ways to improve
  • Troubleshoot and remediate issues in data code, processes, or sources
  • Fulfill ad hoc data and reporting requests using internal tools
  • Effectively communicate and collaborate with both technical and non-technical teams
  • Provide high levels of customer service
    Additional skills and knowledge
    • ETL/ELT experience, especially using SSIS, Power BI, and SSRS
    • Ability to work in a fast-paced, Agile/Scrum environment
    • Experience with CRM systems a plus (e.g., Salesforce, Redtail, Smart Office, etc.)
    • An appetite and aptitude for taking responsibility for technical decisions
    • Good verbal and written communication skills
    • Self-starter who is eager to learn
      About Advisor360 -We're not your typical WealthTech company. Advisor360 - was born out of tens of thousands of pieces of feedback received during the past 20 years from the industry's highest-producing financial advisors. Our software is second to none in creating operational efficiencies, unifying all the systems advisors need to run their businesses. Advisor360 - launched in April 2019 as a new stand-alone technology company from our sister company, Commonwealth Financial Network -, the largest privately held Registered Investment Adviser-independent broker-dealer in the United States. With more than 2,000 independent advisors, Commonwealth is Advisor360 -'s first customer; MassMutual is its second, bringing an additional 9,000 advisors onto the platform.Come grow with us! Advisor360 - is an exciting new venture, combining the nimble and innovative qualities of a start-up with the stability of a mature company. We have a track record of the highest satisfaction ratings by financial advisors in industry-leading publications, as well as a reputation for high workplace quality; for 12 years, as part of the Commonwealth team, we were voted one of the 100 best technology companies to work at by Computerworld. Benefits include a robust bonus plan, PTO, VTO (Volunteer Time Off), free access to vacation homes around the world, 50% 401(k) match, stock appreciation rights, referral bonuses, 80% of HMO premium for individuals and families, life-insurance coverage, short-term and long-term disability coverage, education assistance, flexible spending accounts, and employee assistance programs, just to name a few.Join us on this journey. We believe that diversity drives innovation and so we are building a company where everyone is truly welcome. Everyone is encouraged to bring their unique, authentic selves to work every day. The way we see it, we're here to learn from each other. Are you ready to grow with us?Advisor360 - is an equal opportunity employer that is committed to a diverse workforce.

Keywords: Advisor360 -, Orlando , Data Engineer I (No Remote Option-Hybrid Work Environment), Engineering , Orlando, Florida