Principal Data Analyst
Job Summary
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.
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
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
11 skills required
Job Details
Business Unit:
Cubic Transportation SystemsCompany 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:
EmployeeSimilar Jobs
Addepar
Edinburgh, Scotland, United Kingdom (On-Site)
• 2 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Figma
San Francisco, California, United States (Remote)
• 1 Month ago
PwC
Vancouver, British Columbia, Canada (On-Site)
• 1 Month ago
Get notifed when new similar jobs are uploaded
Jobs in Hyderabad, Telangana, India
Capgemini
Bengaluru, Karnataka, India (On-Site)
• 1 Month ago
Get notifed when new similar jobs are uploaded
Data Analysis Jobs
Apple
Sunnyvale, California, United States (On-Site)
• 2 Months ago
Apple
San Francisco, California, United States (On-Site)
• 1 Month ago
Get notifed when new similar jobs are uploaded
About The Company
Cubic creates and delivers technology solutions in transportation that make people’s lives easier by simplifying their daily journeys, and defense capabilities that 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 challenges 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).CTS is an industry-leading integrator of payment and information solutions and related services for intelligent travel applications.CTS delivers integrated systems for transportation and traffic management, delivering tools for travelers to choose the smartest and easiest way to travel and pay for their journeys, and enabling transportation authorities and agencies to manage demand across the entire transportation network. Cubic Defense provides networked Command, Control, Communications, Computers, Cyber, Intelligence, Surveillance and Reconnaissance (C5ISR) solutions, and live, virtual, constructive and game-based training solutions for both U.S. and Allied Forces. These mission-inspired capabilities enable assured multi-domain access; converged digital intelligence; and superior readiness for defense, intelligence, security and commercial missions.
Get notified when new jobs are added by Cubic corporation
