Senior Data Analyst

Job Description

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