Data Engineer

Talent is everywhere, opportunity is not. Sora Union changes that. Sora Union a globally distributed professional services company that specializes in Design, Software Engineering, and QA services. Our experienced talent comes from communities where there is displacement or risk of displacement due to conflict or climate change. We provide services to global companies and start-ups across various industries, including healthcare, financial services, technology, and education.

We are looking for a motivated and detail-oriented Data Engineer to join our team. The idealcandidate will have a strong foundation in data analysis, data modeling, and familiaritywith LookML/SQL and BigQuery. This role requires the ability to self-motivate andcomplete projects in a fast-paced start-up environment. This role will involve supportingdata operations, performing data analysis, and assisting in the development of data-driven insights. This role will also involve collaborating with colleagues in theTechnology and Product teams to design, implement, and optimize our datainfrastructure to ensure efficient and reliable data operations.

You'll 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 ascalable 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, andmonitoring.
• Assist in monitoring and optimizing database performance

LookML/SQL Development

• Learn and develop LookML models for Looker-based data analytics andreporting.
• Write SQL queries to extract, manipulate, and analyze data from varioussources.

BigQuery Expertise

• Utilize BigQuery for data storage, querying, and processing.
• Optimize BigQuery usage for cost-efficiency and performance.

Data Integration

• Design and implement ETL processes to integrate data from multiplesources.
• Ensure data quality, consistency, and accuracy across systems.

Collaboration And Support

• Collaborate with product, technology, finance, marketing and distributionservices to ensure business needs are being addressed.oProvide technical support and troubleshooting for database-related issues.

Documentation And Best Practices

• Create and maintain documentation for data architecture, processes, andprocedures.
• Establish and enforce best practices for data management andgovernance.

Project Examples

• HubSpot joins for asset manager monthly reporting and internal consumption
• Client's networks application Audit log enrichment to highlight user activity and navigation
• Redesign and develop a new availability grid that can identify asset managerscore products, asset class, strategy type, etc. so that they can easily bematched with appropriate companies and/or contacts
• Asset manager report automation/changes; Specifically, addressing a morescalable 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 marketingpartners
• Enrich/build membership table joins and reporting

Ideally, You'll Have

• Bachelor's degree in Computer Science, Information Technology, or a relatedquantitative field.
• 2-5+ years of experience in database management, data engineering, or dataanalysis.
• 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 datawarehousing concepts.
• Familiarity with version control (Git) and collaboration tools (GitHub).
• Proficiency in at least one data visualization tool (Looker, Tableau, Power BI, orsimilar) for creating interactive dashboards and reports.
• Experience designing and delivering clear, impactful data-driven presentationsand reports to stakeholders.
• Excellent problem-solving, 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, andstatistical analysis.
• Plus: Familiarity with machine learning concepts and libraries.
• Plus: Experience designing and delivering clear, impactful data-drivenpresentations and reports to stakeholders.

All your information will be kept confidential according to EEO guidelines.