What are the responsibilities and job description for the Senior Data Engineer, Information Technology - Data & Development position at Beacon Pointe Advisors?
Job Description
The Senior Data Engineer will oversee the department's data infrastructure, including developing a data model, integrating large amounts of data from different systems, building & enhancing a data lake-house & subsequent analytics environment, and writing scripts to facilitate data analysis. This role will work closely & collaboratively with members of the executive team and various departments across the organization to define requirements, mine & analyze data, and deploy high-quality data pipelines to support analytics needs & data ingestion from recently acquired firms. The Data team is responsible for turning data into information that leads to insights and actions to improve the business.
Responsibilities
- Build & continuously enhance a data lake-house that ingests data from different sources to create a unified system for unstructured, semi-structured, and structured data.
- Combine & analyze data from the lake-house to create analytical reports & insights for executive management.
- Responsible for developing complex queries in SQL, SPL, stored procedures, or PowerBI from a very large data volume and multiple data sources.
- Able to use and apply the right analytical techniques to identify hidden patterns & trends that can be leveraged to improve the business.
- Lead data analysis to solve complex data issues and support data research requests.
- Perform data analytics, visualization, dashboard customization, and alerts in various cloud platforms such as Azure, Redshift, PowerBI, Tableau.
- Partner with strategic vendors to connect external data sources.
- Build logic that will connect & ingest data sources from newly acquired offices.
- Help improve data quality & efficiency for various platforms.
- Build process automation, algorithms, & prototypes.
- Audit & enhance data quality & reliability.
- Work as a team to create data integrations with other systems.
- Monitor and develop data integration tools to provide support for business process across internal platforms (Tamarac Reporting, eMoney, HubSpot, Box)
- Stay current with trends, techniques, technology, and other factors impacting the job.
Qualifications
About the Beacon Pointe Family of Companies
Beacon Pointe Advisors is a multi-billion-dollar Registered Investment Advisor with headquarters in Southern California and affiliate offices nationwide. Beacon Pointe provides clear and objective investment advice, solely advocating for our diverse group of clients including institutions (i.e., endowments, foundations), high-net-worth individuals and families. Our advisors' extensive expertise and strong commitment to our clients can be seen through numerous awards, including being recognized by Bloomberg, Forbes, Financial Advisor Magazine, CNBC, Barron's and more. For more information, please visit
