Role: Data modelling and Analytics engineer.
Location : Washington, District of Columbia
1. Background
Operations Monitoring and Rapid data solutions team, which is part of ITSFE is seeking a Data Modelling and Analytics Expert with specialized skills in Power BI Semantic Model development and DAX (Data Analysis Expressions) query implementation. The ideal candidate will also possess expertise in SQL Query, Databricks Lakehouse, Azure Databricks, and DBT to enhance our data analytics capabilities.
2. Objective
The primary objective of this role is to design, implement and maintain a robust Semantic Model in Power BI, enabling users to create meaningful insights and analytics. The expert will also be responsible for developing complex DAX queries to support reporting needs while leveraging Databricks for data processing and transformation.
3. Scope of Work
The Power BI Expert will be responsible for the following tasks:
• Semantic Model Development:
o Design, develop and maintain a scalable and efficient Semantic Model tailored to business requirements.
o Ensure the Semantic Model supports optimal performance and user experience.
o Collaborate with stakeholders to gather requirements and validate model design.
• DAX Query Implementation:
o Write and optimize DAX queries to create calculated columns, measures, and tables as needed.
o Ensure DAX calculations are efficient and support the reporting framework.
o Provide guidance on best practices for DAX usage among team members.
• Databricks and Azure Databricks Integration:
o Utilize Databricks Lakehouse to manage large volumes of data effectively.
o Implement data processing workflows using Azure Databricks, ensuring smooth integration with Power BI.
o Develop and maintain ETL pipelines using Databricks to prepare data for analysis.
• DBT (Data Build Tool) Implementation:
o Implement DBT for data transformation and modeling within the data pipeline.
o Create modular and reusable DBT models that align with business requirements.
o Collaborate with data engineers to ensure data quality and integrity.
• Advanced Hands-On Experiences:
o Utilize advanced Power BI features, including row-level security, incremental data refresh, and Power Query for data transformation.
o Implement custom visuals and integrate APIs to extend Power BI functionality.
o Develop advanced analytical solutions using AI capabilities within Power BI, such as predictive analytics and machine learning models.
o Leverage advanced data modeling techniques, including star schema design, to improve query performance and simplify data analysis.
• Reporting and Dashboard Creation:
o Assist in developing interactive dashboards and reports based on the Semantic Model.
o Implement user-friendly features that enhance data accessibility and visualization.
• Performance Monitoring and Optimization:
o Monitor the performance of the Semantic Model, DAX queries, and data pipelines.
o Implement strategies to optimize performance as data volumes grow.
4. Qualifications
• Proven experience with Power BI, including Semantic Model development and DAX.
• Expertise in SQL Query, Databricks Lakehouse, Azure Databricks, and DBT.
• Strong understanding of data warehousing concepts and ETL processes.
• Familiarity with data visualization best practices.
• Excellent analytical and problem-solving skills.
• Strong communication and interpersonal skills.
Lamers Bus Lines is looking for safety-minded bus aides to assist our bus drivers on school bus routes, Monday through Friday during the school year. The position averages 20 hours per week.Bus aides are responsible for providing assistance and support to the school...
...Join us as a partnership-track Hand Surgeon at Reno Orthopedic Center! We are physician-owned and committed to providing excellent orthopedic care. Weve recently completed construction of the regions only Institute for Musculoskeletal Health located in downtown Reno...
...create deeply immersive games that draw players into richly imagined worlds; games that empower players to choose their own play-style,... ...the United States. All team members may be asked to occasionally travel for key meetings, as part of their job responsibilities. Our...
...Job Title Connected Supply Chain - Logistics - Manager Job Category Operations Consulting Level Manager Specialty/Competency Operations Industry/Sector CM X-Sector Job Type Regular Time Type Full time Travel Requirements Up to 60% Start Year 2024 Job ID...
...their preferences. If you have a knack for finding the perfect accommodations and a passion for delivering exceptional service, we want you on our team. Key Responsibilities: Research and book hotel accommodations for clients based on their preferences, budget,...