BI Data Science Engineer (Reporting & Analytics)

NEXGEN Asset Management; Sacramento (CA); On-site; USD 90,000 - 95,000; Full time

Benefits offered by this job

Paid Time Off

401(k) Plan

Healthcare Benefits

Holidays

Dog-friendly office

Job summary

NEXGEN Asset Management seeks a versatile BI Data Science Engineer to bridge enterprise BI, data engineering, and applied data science. You will scale data warehouses in Azure, build dashboards in our product and Power BI, and translate client needs into actionable KPIs.

You will collaborate with clients, maintain ETL/ELT pipelines in PostgreSQL and MSSQL, apply forecasting models, and document data ecosystems. Strong SQL, Python, and Power BI skills are essential.

Qualifications

• 3–4 years of BI, data engineering, and analytics experience.
• Advanced SQL in PostgreSQL and MSSQL in Azure.
• Python for data manipulation and modeling.
• Power BI and Excel mastery.
• React and .NET familiarity.
• Git for code and migrations.
• Strong communication and client interaction.

Responsibilities

• Design, build, and deploy dashboards and reports in Power BI and Excel.
• Maintain PostgreSQL and MSSQL data pipelines in Azure.
• Apply statistical modeling and time-series forecasting.
• Define and track business and operational KPIs.
• Meet with clients to gather reporting requirements.
• Document data ecosystem and pipelines.
• Ensure data quality and governance.

Skills

BI & Reporting

Data Engineering

Applied Data Analytics

SQL

Python

Power BI

Excel

React

.NET

Git

Communication

Tools

PostgreSQL

MSSQL

Azure

Job description

BI Data Science Engineer (Reporting & Analytics)

Sacramento, United States

• Salary Salary range of $90,000 - $95,000/year based on experience.
• Work Experience 3-5 years
• State/Province California
• Country United States

About Us

NEXGEN is the most technologically advanced enterprise asset management program on the market, integrating future-first CMMS software. NEXGEN’s EAM software provides a diverse suite of robust features to intelligently manage your end-to-end asset inventory throughout their lifecycle. With NEXGEN, you're evolving from a legacy time-scheduled maintenance model to a proactive future-forward system built by industry thought leaders.

Why NEXGEN?

What's the best thing about working at NEXGEN? That's easy, it's the people (but the free snacks in the kitchen aren't too shabby either). At NEXGEN, our employees are our greatest asset. We value every member of our team, equipping them with the tools to grow professionally and thrive in a fun and dynamic work environment. We work hard and play hard, knowing a strong work-life balance is key to success.

What are we looking for?

Our ideal candidates are motivated, enthusiastic, and highly organized, with a strong technical aptitude and a love for summer BBQs, team building events, and office dogs. We are looking for those who aren't afraid to be bold, take the initiative, and do the right thing—helping our clients overcome their greatest challenges to achieve their goals.

_______________________________________________

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.

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.
  
• BI & Reporting: Power BI, Microsoft Excel
  
• Languages & Tools: Python, SQL, Git
  

Why Work at NEXGEN:

• Engage with an innovative and intelligent team
  
• Fun & progressive culture in a dog-friendly office
  
• Competitive salaries and room for growth
  
• 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
  
• 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
  

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.