Senior Data Engineer, Information Technology – Data & Development

at  Beacon Pointe Advisors

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.

QUALIFICATIONS

• Technical expertise with data models, data mining, and segmentation techniques.
• Extensive experience with processing large sets of unstructured, semi-structured, and structed data.
• Extensive experience building, maintaining, and enhancing data lakes and data warehouses.
• Extensive experience working in AWS (Amazon Web Services), Azure, Tableau, & Snowflake.
• Extensive experience in ETL design, implementation, and maintenance.
• Extensive experience in programing knowledge for Python & C/C++ and strong in wiring complex DB query SQL.
• Experience with data modeling and working with Big Data.
• Experience with data analysis and visualization, particularly PowerBI & Tableau.
• Strong analytical experience & skills that can extract actionable insights from raw data to help improve the business.
• Designing and implementing real time pipelines.
• Ability to effectively manage data, data storage, and data security.
• Great numerical and analytical skills.
• Excellent problem-solving skills and the ability to troubleshoot and resolve platform-related issues.
• Strong communication skills with the ability to collaborate effectively with cross-functional teams and stakeholders.
• Proactive and self-motivated with a passion for continuous learning and staying updated with Salesforce best practices and new features.
• Bachelor’s degree or above in computer science, Information Technology, or a related field is preferred.
  Interested Candidates: Please click on the link below to apply. Please ensure your resume is uploaded prior to completing the process.

• 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.