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.

Worker Type:

Employee

Set alerts for more jobs like Principal Data Analyst
Set alerts for new jobs by Cubic corporation
Set alerts for new Data Analysis jobs in India
Set alerts for new jobs in India
Set alerts for Data Analysis (Remote) jobs

Contact Us
hello@outscal.com
Made in INDIA 💛💙