BI Data Science Engineer (Reporting & Analytics)

Zohorecruit; Sacramento, Northern (CA, KY); Hybrid; USD 90,000 - 95,000; Full time

Benefits offered by this job

PTO: Starts at 15 days/year

Paid Sick Leave: 40 hours/year

401(k) with company match

Healthcare: health, dental, vision

Holidays: standard

Job summary

NEXGEN in Sacramento, California is seeking a versatile BI Data Science Engineer who bridges the gap between enterprise BI, data pipeline engineering, and applied data science. In this role, you will be deeply involved in both our core software product and 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

Qualifications

• 3–4 years of experience combining BI, Data Engineering, and Applied Data Analytics / Data Science.
• Advanced SQL skills with PostgreSQL and MSSQL in Azure cloud environments.
• Solid Python for data manipulation, EDA, and forecasting modeling.

Responsibilities

• Design, build, and deploy interactive dashboards and reports in Power BI/Excel tailored to client needs.
• Maintain and optimize ETL/ELT pipelines in Azure using PostgreSQL and MSSQL.
• Apply statistical modeling, ML, time-series forecasting to surface trends and insights.
• Define and track meaningful KPIs for internal product teams and clients.
• Meet with clients to gather reporting requirements and present solutions.
• Document data ecosystem, pipelines, and dashboards with clear technical guides.

Skills

SQL (PostgreSQL/MSSQL)

Python

Power BI

Excel

React

.NET

Git

BI/Reporting

Tools

Azure

PostgreSQL

MSSQL

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 aversatile BI Data Science Engineer who bridges the gap between enterpriseBusiness Intelligence, data pipeline engineering, and applied data science. Inthis role, you will be deeply involved in both our core software product andour client-facing reporting operations.

You will maintainand scale our PostgreSQL and MSSQL data warehouse pipelines in Azure, architectdimensional data models, apply predictive and statistical modeling techniques,and build dynamic dashboards directly within our software product and throughPower BI/Excel. Additionally, you will partner directly with clients totranslate business requirements into key performance indicators (KPIs) andcomprehensively document our data ecosystem.

Key Responsibilities

• Design, build,and deploy interactive dashboards and widgets within our product, whilecreating custom Power BI and Excel reports tailored to client needs.
  
• Maintain, monitor, and optimize existing ETL/ELT datawarehouse pipelines powered by PostgreSQL and MSSQL in Azure to ensurereliable, high-performing data flows.
  
• Apply statistical modeling, machine learningtechniques, time-series forecasting, and correlation analyses to surfacetrends, identify data gaps, and deliver actionable predictive insights.
  
• Proactively define, implement, and track meaningfulbusiness and operational KPIs that drive decision-making for internalproduct teams and external clients.
  
• Meet withclients to gather reporting requirements, present solutions, and supportongoing analytical needs.
  
• Support the end-to-end data lifecycle—identifying andresolving data quality or integrity issues while adhering to bestpractices 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 experiencecombining Business Intelligence, Data Engineering, and Applied DataAnalytics / Data Science.
  
• Advanced SQL skills with hands-on PostgreSQL and MSSQLexperience in cloud environments (Azure preferred), including writing,tuning, and optimizing complex queries, views, indexes, and storedprocedures.
  
• Solid Python proficiency for data manipulation, exploratory dataanalysis, pipeline automation, and statistical/forecasting modeling (e.g.,pandas, NumPy, scikit-learn, stats-models).
  
• Expert proficiency in Power BI (DAX, Power Query, datamodeling) and advanced Microsoft Excel (functions, Power Query, dynamicreporting).
  
• Working familiarity with React (for front-enddashboard/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-technicalstakeholders, leading client discovery sessions, and writing cleantechnical documentation.
  
• BI &Reporting: Power BI, Microsoft Excel
  
• Languages &Tools: Python, SQL, Git
  

Why Work at NEXGEN:

• Engage with aninnovative and intelligent team
  
• Fun &progressive culture in a dog-friendly office
  
• Competitivesalaries and room for growth
  
• Paid Time Off (PTO): Starts at 15 daysper year, increasing by 8 hours for each additional year of service(capped at 200 hours).
  
• PaidSick Leave: 40 hours per year.
  
• RetirementPlanning: 401(k) plan eligible after 3 months ofservice 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 theright thing & do not be afraid of taking smart risks

• Be bold andmake intelligent decisions
  
• Takeinitiative even when faced with adversity
  
• Approach workwith intellectual curiosity
  
• Follow bestpractices of the industry
  

Respect – Treatothers with respect & professionalism

• Be honest,open, and forthright
  
• Approach theorganization, clients and team with integrity
  

Proactive –Anticipate & take the initiative to achieve results

• Be aware ofthe situation and environment
  
• Anticipateneeds and take initiative to address them
  

Results –Deliver exceptional results

• Hold yourselfaccountable to deliverables and deadlines
  

Community – Builda community of co-workers and clients

• Family-drivenculture of teamwork
  
• Connect on apersonal level with team and clients
  

NEXGEN is an equal opportunity employer. We celebrate diversity and arecommitted to creating an inclusive environment for all employees.