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

Washington, DC
Aug 16, 2022
Aug 18, 2022
Engineer, IT, QA Engineer
Full Time
??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 responsibilitiesWork collaboratively with team members to migrate data from advisor offices into Advisor360 's platform.Create, maintain, and support software and data processesWrite code utilizing SQL to fulfill client data requests in a timely mannerQuickly diagnose and resolve incoming bugsUse modern approaches and tools to automate systems and processesCollaborate with team members on effective development practices, communicating with tact and professionalismProduce well written, efficient, and maintainable code related to data processes and presentationRequirementsWrite efficient and maintainable code including SQL-stored proceduresStrong SQL & T SQL coding skills requiredStrong data analytics skills, including the ability to break down data models efficientlyDevelop software solutions by analyzing information needs; conferring with users; and studying systems flow, data usage, and workstream processesTroubleshoot, debug, and upgrade existing systems and processesDocument and maintain software functionality and data processesCreate, enhance, and maintain data processes, always seeking new ways to improveTroubleshoot and remediate issues in data code, processes, or sourcesFulfill ad hoc data and reporting requests using internal toolsEffectively communicate and collaborate with both technical and non-technical teamsProvide high levels of customer serviceAdditional skills and knowledgeETL/ELT experience, especially using SSIS, Power BI, and SSRSAbility to work in a fast-paced, Agile/Scrum environmentExperience with CRM systems a plus (eg, Salesforce, Redtail, Smart Office, etc.)An appetite and aptitude for taking responsibility for technical decisionsGood verbal and written communication skillsSelf-starter who is eager to learnAbout 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(R), 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.