Senior Data Analytics Developer, Power BI and AWS

Senior Data Analytics Developer, Power BI and AWS
Location: Newark, New Jersey
Job Type: Full-time
Schedule: Hybrid; three days per week in office

CARIAN is a purpose-driven, woman-owned consulting and advisory firm dedicated exclusively to the power sector. We partner with leading electric and gas utilities to provide strategic advisory and disciplined execution across program management, business intelligence, and field execution oversight. Guided by integrity, trust, excellence, and accountability, our team helps deliver complex capital programs and build the resilient energy infrastructure that communities depend on.

CARIAN is seeking a Senior Data Analytics Developer, Power BI and AWS to join our team and deliver customer analytics, dashboarding, data engineering, and AI/ML‑enabled insights for a major utility program in Newark, New Jersey.

This role will help transform raw operational, customer, and business data into actionable insights, dashboards, data products, and analytics solutions that support strategic decision‑making and improve customer experience. The position will work closely with CARIAN leadership, client stakeholders, Customer Analytics, IT, and vendor teams to build Power BI dashboards, optimize data sources and pipelines, support analytics solution design, and incorporate data science, AI, and machine learning approaches where appropriate.

The ideal candidate has strong hands‑on experience with Power BI, AWS cloud services, SQL, Python, data modeling, data visualization, data engineering, and analytics delivery. Experience with customer analytics, call centre operations, customer behaviour analysis, or customer journey improvement is strongly preferred.

• Collect, summarise, analyse, and deliver insights using data from multiple sources.
• Develop data models and analytics solutions to support Power BI dashboards and reporting needs.
• Design, develop, maintain, and enhance interactive Power BI dashboards that provide actionable insights to stakeholders.
• Identify valuable data sources and support optimisation of data pipelines to improve data quality, integrity, security, and usability.
• Partner with business stakeholders, Customer Analytics, IT, and vendor teams to gather requirements and translate business needs into analytics solutions.
• Facilitate business requirements sessions between business stakeholders, IT, and vendors.
• Facilitate and execute testing activities between business stakeholders, IT, and vendors.
• Transform data to define analytics solutions that support customer experience improvement initiatives.
• Incorporate AI and machine learning solutions into analytics use cases where appropriate.
• Analyse operational and non‑operational data to identify trends, patterns, customer friction points, customer behaviour, and improvement opportunities.
• Apply statistical analysis, data mining techniques, and scenario modelling to validate assumptions and support decision‑making.
• Interpret data to identify solutions, communicate insights, and support business decisions.
• Develop and maintain SQL models, ETL workflows, and analytics logic to support reporting and dashboard development.
• Use Python to support analytics, data processing, modelling, and AI/ML development.
• Effectively communicate technical findings, insights, and recommendations to non‑technical stakeholders, subject matter experts, and cross‑functional teams.
• Support responsible data use, data quality, documentation, and governance practices.

• Bachelor’s degree in Data Science, Engineering, Computer Science, Information Technology, Information Systems, Statistics, or a related field.
• 5+ years of experience with data mining techniques, data modelling, statistical analysis, algorithms, or applied analytics.
• 5+ years of experience with data visualisation using Power BI or similar tools.
• 5+ years of experience leveraging AWS services, including Redshift or similar cloud data platforms, to support scalable data pipelines and analytics solutions.
• 5+ years of experience using Python for analytics, SQL modelling, data processing, or AI/ML model development.
• 5+ years of experience using…