Senior Data Analyst

Job Description

Business Unit: Cubic Transportation Systems 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