Data Engineer
Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
We are looking for a motivated and detailoriented Data Engineer to join our team. The ideal candidate will have a strong foundation in data analysis data modeling and familiarity with LookML/SQL and BigQuery. This role requires the ability to selfmotivate and complete projects in a fastpaced startup environment. This role will involve supporting data operations performing data analysis and assisting in the development of datadriven insights. This role will also involve collaborating with colleagues in the Technology and Product teams to design implement and optimize our data infrastructure to ensure efficient and reliable data operations.
Youll be responsible for:
Data Analysis and Reporting:
- Assist in analyzing and interpreting data to provide actionable insights.
- Develop and maintain reports and dashboards using Looker and SQL.
Data Architecture Design:
- Coordinate and collaborate around the designing and implementation of a scalable and efficient database solution to support business requirements.
- Develop and maintain data models schemas and data dictionaries.
Database Management:
- Manage and optimize databases to ensure high performance availability and reliability.
- Support database maintenance tasks such as backups indexing and monitoring.
- Assist in monitoring and optimizing database performance
LookML/SQL Development:
- Learn and develop LookML models for Lookerbased data analytics and reporting.
- Write SQL queries to extract manipulate and analyze data from various sources.
BigQuery Expertise:
- Utilize BigQuery for data storage querying and processing.
- Optimize BigQuery usage for costefficiency and performance.
Data Integration:
- Design and implement ETL processes to integrate data from multiple sources.
- Ensure data quality consistency and accuracy across systems.
Collaboration and Support:
- Collaborate with product technology finance marketing and distribution services to ensure business needs are being addressed.o Provide technical support and troubleshooting for databaserelated issues.
Documentation and Best Practices:
- Create and maintain documentation for data architecture processes and procedures.
- Establish and enforce best practices for data management and governance.
Project Examples
- HubSpot joins for asset manager monthly reporting and internal consumption
- Clients networks application Audit log enrichment to highlight user activity and navigation
- Redesign and develop a new availability grid that can identify asset managers core products asset class strategy type etc. so that they can easily be matched with appropriate companies and/or contacts
- Asset manager report automation/changes; Specifically addressing a more scalable asset management report output (monthly)
- Adding contact roles to opportunities via a joined table
- Join / align Salesforce to application membership
- Streamline lead qualification scoring and routing in partnership with marketing partners
- Enrich/build membership table joins and reporting
Qualifications :
Ideally youll have:
- Bachelors degree in Computer Science Information Technology or a related quantitative field.
- 25 years of experience in database management data engineering or data analysis.
- Proficiency in SQL dbt (data build tool) and Python for data manipulation transformation and analysis.
- Experience with LookML for developing and maintaining Looker models.
- Experience with Fivetran for data replication and pipeline management.
- Strong understanding of data modeling principles ETL processes and data warehousing concepts.
- Familiarity with version control (Git) and collaboration tools (GitHub).
- Proficiency in at least one data visualization tool (Looker Tableau Power BI or similar) for creating interactive dashboards and reports.
- Experience designing and delivering clear impactful datadriven presentations and reports to stakeholders.
- Excellent problemsolving analytical and communication skills.
- Eagerness to learn and stay updated with the latest trends in data technologies.
- Experience with cloud platforms (GCP AWS Azure) NoSQL databases and statistical analysis.
- Plus: Familiarity with machine learning concepts and libraries.
- Plus: Experience designing and delivering clear impactful datadriven presentations and reports to stakeholders.
Additional Information :
All your information will be kept confidential according to EEO guidelines.
Remote Work :
Yes
Employment Type :
Contract
Employment Type
Remote
Company Industry
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
