BI Data Science Engineer (Reporting & Analytics)

NEXGEN Asset Management; California; Presencial; USD 110 000 - 150 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Dog-friendly office

Flexible work environment

401(k) with match

Health, dental, vision insurance

Paid holidays

Resumo da oferta

NEXGEN Asset Management seeks a versatile BI Data Science Engineer to bridge enterprise BI, data pipelines, and applied analytics for both our product and client reporting. You will maintain PostgreSQL and MSSQL data warehouses in Azure, design dimensional models, apply predictive modeling and time-series forecasting, and build dashboards in Power BI and Excel.

Proficiency in SQL, Python, Power BI, Excel, React and .NET, plus Git, with 3–4 years of experience, is expected in a dog-friendly,

Qualificações

• 3–4 years of experience combining BI, Data Engineering, and Applied Data Analytics / Data Science.

Responsabilidades

• Maintain PostgreSQL and MSSQL data warehouses in Azure; optimize ETL/ELT pipelines.
• Design dimensional data models and implement predictive and time-series forecasting.
• Build dashboards and widgets in the product and via Power BI/Excel for clients.
• Translate business requirements into KPIs and document the data ecosystem.

Conhecimentos

SQL

Python

Power BI

Excel

React

.NET

Git

Communication

Ferramentas

PostgreSQL

MSSQL

Azure

Power BI

Excel

Python

React

.NET

Descrição da oferta de emprego

Job Description

We are seeking a versatile BI Data Science Engineer who bridges the gap between enterprise Business Intelligence, data pipeline engineering, and applied data science. In this role, you will be deeply involved in both our core software product and our client-facing reporting operations.

You will maintain and scale our PostgreSQL and MSSQL data warehouse pipelines in Azure, architect dimensional data models, apply predictive and statistical modeling techniques, and build dynamic dashboards directly within our software product and through Power BI/Excel. Additionally, you will partner directly with clients to translate business requirements into key performance indicators (KPIs) and comprehensively document our data ecosystem.

Design, build, and deploy interactive dashboards and widgets within our product, while creating custom Power BI and Excel reports tailored to client needs.

Maintain, monitor, and optimize existing ETL/ELT data warehouse pipelines powered by PostgreSQL and MSSQL in Azure to ensure reliable, high-performing data flows.

Apply statistical modeling, machine learning techniques, time-series forecasting, and correlation analyses to surface trends, identify data gaps, and deliver actionable predictive insights.

Support the end-to-end data lifecycle—identifying and resolving data quality or integrity issues while adhering to best practices in schema design and dimensional modeling.

Author complete technical and end-user documentation, including pipeline workflows, version-controlled repository standards, user guides, and a comprehensive dictionary detailing dashboards, charts, and metrics.

3–4 years of experience combining Business Intelligence, Data Engineering, and Applied Data Analytics / Data Science.

• ~ Advanced SQL skills with hands-on PostgreSQL and MSSQL experience in cloud environments (Azure preferred), including writing, tuning, and optimizing complex queries, views, indexes, and stored procedures.
• ~ Solid Python proficiency for data manipulation, exploratory data analysis, pipeline automation, and statistical/forecasting modeling (e.g., Expert proficiency in Power BI (DAX, Power Query, data modeling) and advanced Microsoft Excel (functions, Power Query, dynamic reporting).
• ~ Working familiarity with React (for front-end dashboard/widget integration) and .NET (for back-end service integration).
• ~ Strong Git experience for managing database migrations, Python pipelines, and application codebase integration.
• ~ comfortable translating complex data concepts to non-technical stakeholders, leading client discovery sessions, and writing clean technical documentation.

Databases & Cloud: PostgreSQL, MSSQL, Azure

BI & Reporting: Power BI, Microsoft Excel

Languages & Tools: Python, SQL, Git

Application Frameworks: React, .NET (familiarity)

Culture & Benefits

Fun & progressive culture in a dog-friendly office

Flexible work environment

• Retirement Planning: 401(k) plan eligible after 3 months of service with up to a 4% company match .
• Healthcare: Competitive health, dental, and vision insurance options.
• Holidays: Standard paid company holidays.

Courage – Do the right thing & do not be afraid of taking smart risks

Community – Build a community of co-workers and clients

Connect on a personal level with team and clients

Equal Opportunity

We celebrate diversity and are committed to creating an inclusive environment for all employees.