Principal Data Analyst

1 Year ago • 5 Years +

Data Analysis

Job Description

Cubic Transportation Systems is seeking a Principal Data Analyst to join their DMAP team. The ideal candidate will be proficient in SQL, Power BI, data modeling, and analytics and ETL processes. Responsibilities include designing and optimizing Power BI reports, writing complex SQL queries, developing DAX measures, implementing Row-Level Security, performing data transformations, and collaborating with engineering and business teams. The role also involves supporting Power BI administration, cloud-based data solutions using Azure services, change requests, and maintaining data governance standards. A minimum of 5 years of experience in SQL, Power BI, Data Modeling, and ETL concepts is required, along with a strong understanding of Azure components.

Good To Have:

Familiarity with Power BI Service Admin
Knowledge of Databricks, Synapse
Exposure to QLIK Replicate
Working knowledge of Power Automate
Basic understanding of Python
Experience with Tableau
Microsoft Certified: Power BI Data Analyst Associate

Must Have:

5+ years of SQL experience
5+ years of Power BI experience
5+ years of Data Modeling experience
5+ years of Analytics and ETL concepts
Proficiency in Power BI Fabric
Understanding of Azure components
Experience with data governance

Add these skills to join the top 1% applicants for this job

communication

data-analytics

oracle

game-texts

azure

data-studio

power-bi

google-data-studio

tableau

python

sql

Business Unit:

Cubic Transportation Systems

Company Details:

When you join Cubic, you become part of a company that creates and delivers technology solutions in transportation to make people’s lives easier by simplifying their daily journeys, and defense capabilities to help promote mission success and safety for those who serve their nation. Led by our talented teams around the world, Cubic is committed to solving global issues through innovation and service to our customers and partners.

We have a top-tier portfolio of businesses, including Cubic Transportation Systems (CTS) and Cubic Defense (CD). Explore more on Cubic.com.

Job Details:

Job Summary:

We are seeking a hands-on and highly skilled Principal Data Analyst to join our dynamic DMAP team. The ideal candidate will have extensive experience in SQL, Power BI, data modeling, and a strong understanding of analytics and ETL processes. This role requires a proactive individual with strong analytical thinking, an appetite for learning emerging technologies, and a commitment to delivery excellence.

Key Responsibilities:

Design, develop, and optimize Power BI reports and dashboards.
Write and tune complex SQL queries and joins for data extraction and analysis.
Develop advanced DAX measures and optimize performance.
Implement Row-Level Security (RLS) and create scalable data models (star/snowflake schemas).
Perform data transformations and integrate data from various sources.
Collaborate with engineering and business teams to translate requirements into reporting solutions.
Support Power BI Service administration and deployment best practices.
Contribute to cloud-based data solutions using Azure services.
Support change requests and provide production-level analytics support.
Maintain data governance standards including GDPR and PII handling.
Work closely on a daily basis with the backend engineering team to ensure seamless data integration and alignment of deliverables.

Required Skills and Qualifications:

Minimum 5+ years of hands-on experience in:
- SQL (Advanced concepts, joins, regular querying)
- Power BI (Report development, DAX, RLS, performance tuning)
- Data Modeling (Tabular, star, snowflake)
- Analytics and ETL concepts
Proficiency in Power BI Fabric, Data Connectors, and transformation techniques.
Strong understanding of Azure components: Active Directory, Azure SQL, Azure Data Factory.
Experience with data governance practices (GDPR, PII).

Preferred Skills (Good to Have):

Familiarity with Power BI license types and Service Admin tasks.
Knowledge of Delta Tables, Databricks, Synapse, Data Lakes, and Warehouses.
Exposure to QLIK Replicate, Oracle Golden Gate (OGG).
Working knowledge of Power Automate, Logic Apps.
Basic understanding of Python.
Experience with other BI tools like Tableau, Google Data Studio.
Microsoft Certified: Power BI Data Analyst Associate
Awareness of data engineering and advanced analytics concepts.

Soft Skills & Expectations:

Strong logical and analytical problem-solving abilities.
High levels of initiative and proactiveness.
Good communication skills – must be able to express ideas clearly and confidently in front of stakeholders.
Willingness to learn new technologies and adapt to changing requirements.
A committed and dependable work ethic; should not exhibit complacency.