BI Data Science Engineer (Reporting & Analytics)
Summary
Bridges BI, data engineering, and applied data science for NexGen's asset management software: maintaining PostgreSQL/MSSQL data warehouse pipelines in Azure, building Power BI/Excel and in-product dashboards, and applying statistical/ML modeling to define KPIs and insights for clients.
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.
Key Responsibilities
- 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.
- Proactively define, implement, and track meaningful
business and operational KPIs that drive decision-making for internal
product teams and external clients.
- Meet with
clients to gather reporting requirements, present solutions, and support
ongoing analytical needs.
- 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.
Requirements
Qualifications & Requirements
- 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.,
pandas, NumPy, scikit-learn, stats-models).
- 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.
- Exceptional written and verbal communication skills;
comfortable translating complex data concepts to non-technical
stakeholders, leading client discovery sessions, and writing clean
technical documentation.
Tech Stack
- Databases &
Cloud: PostgreSQL, MSSQL, Azure
- BI &
Reporting: Power BI, Microsoft Excel
- Languages &
Tools: Python, SQL, Git
- Application
Frameworks: React, .NET (familiarity)
Benefits
Why Work at NEXGEN:
- Engage with an
innovative and intelligent team
- Fun &
progressive culture in a dog-friendly office
- Flexible work
environment
- Competitive
salaries and room for growth
- Excellent
benefits
Benefits:
- Paid Time Off (PTO): Starts at 15 days
per year, increasing by 8 hours for each additional year of service
(capped at 200 hours).
- Paid
Sick Leave: 40 hours per year.
- 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.
NEXGEN Core Values:
Courage – Do the
right thing & do not be afraid of taking smart risks
- Be bold and
make intelligent decisions
- Take
initiative even when faced with adversity
Innovation –
Promote innovation & continuous improvement
- Approach work
with intellectual curiosity
- Follow best
practices of the industry
Respect – Treat
others with respect & professionalism
- Be honest,
open, and forthright
- Approach the
organization, clients and team with integrity
Proactive –
Anticipate & take the initiative to achieve results
- Be aware of
the situation and environment
- Anticipate
needs and take initiative to address them
Results –
Deliver exceptional results
- Hold yourself
accountable to deliverables and deadlines
- Strive for
excellence
Community – Build
a community of co-workers and clients
- Family-driven
culture of teamwork
- Connect on a
personal level with team and clients
NEXGEN is an equal opportunity employer. We celebrate diversity and are
committed to creating an inclusive environment for all employees.