Senior Software Analyst
Ford Motor Company
AWSBigQueryCloudETLGoogle Cloud PlatformHadoopInformaticaPythonSQL
Junior Data Engineer
Aramark
full-time
Posted on:
Origin: • 🇺🇸 United States • Pennsylvania
Visit company websiteSalary
💰 $70,000 - $80,000 per year
Job Level
Junior
Tech Stack
BigQueryETLPythonSQL
About the role
- Create and deploy Power BI reports, including paginated reports in Report Builder for multiple projects
- Write and troubleshoot DAX queries and create calculated columns/ measures
- Design, implement and maintain semantic models in Power BI
- Develop and optimize SQL queries in Report Builder and BiqQuery to extract and transform data
- Design and support ETL workflows for data ingestion, transformation and loading
- Handle report transport across environments (UAT/PROD)
- Able to work with parameterized reports; complex semantic models and ensure accurate data relationships; implement and manage Row Level Security (RLS)
- Understand and use BigQuery data models for QA and report generation
- Must be capable of prioritizing and accommodating urgent requests
- Able to handle fast turnaround times and manage multiple projects or priorities simultaneously
- Perform self QA of their work before reporting or delivery
Requirements
- Bachelor’s degree in Computer Science or related field preferred
- At least 2-3 years of experience in Power BI or other data visualisation tools
- Strong knowledge of Power BI architecture: data models, DAX and Report Builder
- Strong Understanding of semantic modeling in Power BI, including relationships, measures and hierarchies
- Experience with SQL and BigQuery for Querying and data modeling
- Familiarity with Python for data manipulation and automation is a plus
