Senior Data Analytics Developer, Power BI and AWS

CARIAN; Newark (NJ); On-site; USD 100,000 - 150,000; Full time

Job summary

CARIAN seeks a Senior Data Analytics Developer to transform raw data into actionable insights for a major utility program in Newark, NJ. You will build Power BI dashboards, optimize data pipelines in AWS, and apply AI/ML techniques to deliver analytics solutions.

The role requires strong Python, SQL, data modelling, and data visualization skills, with a hybrid schedule in Newark (three days in office). Candidates with customer analytics and contact-center experience are preferred.

Qualifications

• Bachelor’s degree in a related field.
• 5+ years data mining, modelling, statistics, or applied analytics.
• 5+ years data visualization with Power BI or similar.
• 5+ years AWS services experience including Redshift or similar.
• 5+ years Python for analytics, SQL modelling, data processing, or AI/ML.
• 5+ years SQL and ETL workflows development.
• Experience with large data sets and turning data into insights.
• Strong data modelling, dashboard, analytics delivery, and reporting practices.
• Ability to facilitate requirements discussions and cross-functional development.
• Excellent communication; explain technical concepts clearly.

Responsibilities

• Collect, summarise, analyse, and deliver insights from multiple sources.
• Develop data models and analytics solutions for Power BI dashboards.
• Design and maintain interactive Power BI dashboards for stakeholders.
• Identify data sources and optimize pipelines for quality and usability.
• Collaborate with stakeholders, IT, and vendors to translate needs.
• Lead requirements sessions with business, IT, and vendors.
• Plan and execute testing with stakeholders and IT.
• Transform data to support customer experience improvements.
• Incorporate AI/ML into analytics use cases where appropriate.
• Analyse data to identify trends, friction points, and opportunities.
• Apply statistical analysis and data mining for decision support.
• Interpret data to derive actionable solutions and recommendations.
• Develop SQL models, ETL workflows, and analytics logic.
• Use Python for analytics and data processing.
• Communicate findings effectively to non-technical stakeholders.
• Support data governance and documentation practices.

Skills

Power BI

AWS

Python

SQL

Data modelling

Data visualization

Analytics delivery

Communication

Education

Bachelor

Tools

Redshift

Job description

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

About Us

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.

Position Overview

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.

Key Responsibilities

• 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.

Qualifications

• 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 SQL and developing or maintaining ETL workflows, including SQL Server Integration Services or similar tools.
• Experience working with large data sets and translating complex data into practical business insights.
• Strong understanding of data modelling, dashboard development, analytics delivery, and reporting best practices.
• Ability to facilitate requirements discussions, testing sessions, stakeholder reviews, and cross‑functional solution development.
• Excellent verbal and written communication skills, with the ability to explain technical concepts clearly and concisely to non‑technical stakeholders.
• Detail‑oriented, results‑driven, data‑driven, and able to work independently in a fast‑paced environment.
• Ability to work a hybrid schedule in Newark, New Jersey, including three days per week in office.

Preferred Experience

• 10+ years of progressive experience in data analytics, business intelligence, data engineering, data science, or related analytics delivery.
• Advanced degree in Data Science, Data Analytics, Engineering, Computer Science, Information Technology, Information Systems, Statistics, or a related field.
• Experience with customer analytics, customer experience, call centre operations, or customer journey analysis.
• Familiarity with data governance, data quality, and responsible AI practices.
• AWS certification, Power BI certification, or related analytics certification.
• Exposure to generative AI, large language models, retrieval‑augmented generation, or other emerging technologies.
• Experience developing analytics solutions for utility, energy, customer operations, or regulated business environments.
• Experience working with business stakeholders, IT teams, vendor teams, and cross‑functional analytics groups.

Why CARIAN

• Purpose‑driven work – Help deliver infrastructure that powers communities
• Industry reputation – Trusted by leading utilities for our reliability and results
• Career growth – Opportunities to lead major programmes and mentor high‑performing teams
• Collaborative culture – Join a team that values delivery excellence and long‑term relationships
• Competitive total rewards – Strong compensation, full benefits, 401(k) match, and meaningful work

Equal Employment Opportunity

CARIAN is proud to be an equal opportunity employer. We hire and develop talent based on qualifications, performance, and business needs. Employment decisions are made without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic. As a woman‑owned firm dedicated to the power sector, we are committed to building a team that reflects professionalism, expertise, and integrity at every level.

Compensation

The salary range for this role is $100,000 – $150,000 annually. This range represents a good‑faith estimate at the time of posting; actual compensation will depend on experience, qualifications, assignment requirements, schedule, and other factors permitted by law. In addition to base compensation, the role includes a comprehensive benefits package and a company 401(k) match.