Data Modelling

3 days ago

Washington, United States Omni Inclusive Full time

Data modelling and Analytics Engineer.
Mandatory skills: Azure Databricks & Power BI is must

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:
  • Design, develop and maintain a scalable and efficient Semantic Model tailored to business requirements.
  • Ensure the Semantic Model supports optimal performance and user experience.
  • Collaborate with stakeholders to gather requirements and validate model design.
  • DAX Query Implementation:
  • Write and optimize DAX queries to create calculated columns, measures, and tables as needed.
  • Ensure DAX calculations are efficient and support the reporting framework.
  • Provide guidance on best practices for DAX usage among team members.
  • Databricks and Azure Databricks Integration:
  • Utilize Databricks Lakehouse to manage large volumes of data effectively.
  • Implement data processing workflows using Azure Databricks, ensuring smooth integration with Power BI.
  • Develop and maintain ETL pipelines using Databricks to prepare data for analysis.
  • DBT (Data Build Tool) Implementation:
  • Implement DBT for data transformation and modeling within the data pipeline.
  • Create modular and reusable DBT models that align with business requirements.
  • Collaborate with data engineers to ensure data quality and integrity.
  • Advanced Hands-On Experiences:
  • Utilize advanced Power BI features, including row-level security, incremental data refresh, and Power Query for data transformation.
  • Implement custom visuals and integrate APIs to extend Power BI functionality.
  • Develop advanced analytical solutions using AI capabilities within Power BI, such as predictive analytics and machine learning models.
  • Leverage advanced data modeling techniques, including star schema design, to improve query performance and simplify data analysis.
  • Reporting and Dashboard Creation:
  • Assist in developing interactive dashboards and reports based on the Semantic Model.
  • Implement user-friendly features that enhance data accessibility and visualization.
  • Performance Monitoring and Optimization:
  • Monitor the performance of the Semantic Model, DAX queries, and data pipelines.
  • 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..

  • Data Modeler

    1 month ago

    Washington, United States Direct IT Staffing, Inc. Full time

    Founded by a team of young, dynamic and task-oriented IT professionals, RICEFW brings a pragmatic approach with proven, real-world solutions to the challenging field of technology and IT personnel placement. We strive to partner clients and staffing talent with similar goals, aims and achievements so that the equilibrium is maintained at the workplace. We...

  • Enterprise Data Modeler

    4 weeks ago

    Washington, United States Booz Allen Hamilton Full time

    To achieve an organization's mission, leaders need strong team members who can process data models, develop best practices and tools for data design, and have expertise in the areas of biomedical data. Whether developing new databases or data models, our clients need a consultant who can help manage data architecture. That is why we need an experienced...

  • Enterprise Data Modeler

    4 weeks ago

    Washington, United States Booz Allen Hamilton Full time

    Job Number: R0205337Enterprise Data ModelerThe Opportunity: To achieve an organization's mission, leaders need strong team members who can process data models, develop best practices and tools for data design, and have expertise in the areas of biomedical data. Whether developing new databases or data models, our clients need a consultant who can help manage...

  • Enterprise Data Modeler

    3 weeks ago

    Washington, United States Buscojobs Full time

    Your growth matters to us - explore our career development opportunities.A PLACE WHERE YOU BELONGBring your whole self to work in our culture of respect and inclusivity.SUPPORT YOUR WELLBEINGLearn how we’ll support you as you pursue a balanced, fulfilling life.YOUR CANDIDATE JOURNEYDiscover what to expect during your journey as a candidate with us.To...

  • Enterprise Data Modeler

    1 month ago

    Washington, United States Booz Allen Hamilton Full time

    Your growth matters to us - explore our career development opportunities.A PLACE WHERE YOU BELONGBring your whole self to work in our culture of respect and inclusivity.SUPPORT YOUR WELLBEINGLearn how we’ll support you as you pursue a balanced, fulfilling life.YOUR CANDIDATE JOURNEYDiscover what to expect during your journey as a candidate with us.To...

  • Data Scientist

    2 weeks ago

    Washington, United States Data Society Full time

    We Are:At Data Society, we provide bespoke, leading-edge data and AI solutions for Fortune 1,000 companies and federal, state, and local governmental organizations. We partner with our clients to educate, equip, and empower their workforces with the skills they need to achieve their goals and expand their impact. We are empowering the workforces of the...

  • Statistician for Advanced Data Modeling

    1 week ago

    Washington, United States The International Society for Bayesian Analysis Full time

    We are seeking a talented Research Mathematical Statistician at The International Society for Bayesian Analysis to develop innovative statistical methodologies for the analysis and development of high-quality data products. Our team focuses on creating accurate models that help policymakers make informed decisions, businesses navigate complex markets, and...

  • Data Modeling Specialist for IT Solutions Architecting

    2 weeks ago

    Washington, United States Direct IT Staffing, Inc. Full time

    At Direct IT Staffing, Inc., we're on the hunt for a seasoned Data Modeling Specialist to join our team. This is an exciting opportunity to leverage your expertise in data modeling and solutions architecting to drive business success.Job OverviewWe're looking for a highly skilled professional with a strong background in data modeling, preferably with...

  • Data Science Specialist for Advanced Analytics

    7 days ago

    Washington, Washington, D.C., United States Data Society Full time

    OverviewData Society, a leading provider of bespoke data and AI solutions, seeks a highly skilled Data Scientist to join our team. We empower organizations with cutting-edge analytics, artificial intelligence, and IT solutions.Job SummaryThe successful candidate will be responsible for developing complex end-to-end business analytics, artificial...

  • Tableau Data Modeler

    5 days ago

    Washington, United States The Oakleaf Group Full time

    Seeking a Tableau developer to join our consulting team. The Tableau Developer will assess customer requests and collaborate with the team to determine solutions to solve business needs, use Tableau or other BI tools to explore and understand data, and provide reporting and solutions. The Tableau Developer will work with the business and tech users to...

  • Tableau Data Modeler

    1 month ago

    Washington, United States The Oakleaf Group Full time

    Seeking a Tableau developer to join our consulting team. The Tableau Developer will assess customer requests and collaborate with the team to determine solutions to solve business needs, use Tableau or other BI tools to explore and understand data, and provide reporting and solutions. The Tableau Developer will work with the business and tech users to...

  • Data Scientist

    3 days ago

    Washington, United States Visa Inc. Full time

    Visa has the world’s largest consumer payment transaction dataset. We see data on over 250 billion transactions every year from all over the world. We use that data to help our clients in the payment ecosystem grow their businesses and to help consumers access a fast, safe, and rewarding payment experience. Visa Predictive Modeling (VPM) team develops and...

  • Senior Data Engineering Lead

    5 days ago

    Washington, Washington, D.C., United States Data Society Full time

    About the RoleWe are seeking a seasoned Senior Data Engineering Lead to join our team at Data Society Group. As part of this effort, we are building products to develop and empower the next generation of data and AI-powered workforces.Key ResponsibilitiesDesign, build, test, and release key AI-powered services and products focused around learning systems and...

  • Data Engineer

    1 week ago

    Washington, Washington, D.C., United States Seneca Holdings Full time

    With a strong presence in the Washington, DC metro region, Seneca Holdings is seeking an experienced Data Engineer to support a large GenAI program for our IRS customer.Job OverviewSeneca Technologies, part of the Seneca Nation Group (SNG) portfolio of companies, offers a collaborative work environment and culture that embraces its mission of providing...

  • Data Model Risk Analyst and Advisor

    5 days ago

    Washington, Washington, D.C., United States Fannie Mae Full time

    About the RoleFannie Mae is seeking a highly skilled Data Model Risk Analyst and Advisor to join our team. This role will offer you the flexibility to make each day your own, while working alongside people who care.ResponsibilitiesRecommend improved methods and techniques to provide innovative, thorough, and practical solutions that support business...

  • Advanced Data Scientist for Proprietary Ads Models

    2 weeks ago

    Washington, United States Recruiting From Scratch Full time

    About the RoleWe are seeking a highly skilled Advanced Data Scientist to join our team in building proprietary machine learning models for Ads recommendation.As an Advanced Data Scientist, you will work closely with our engineering and product teams to design, develop, and deploy scalable and efficient machine learning models that drive business outcomes.The...

  • Data Scientist for AI Model Development and Deployment

    1 week ago

    Washington, United States Seneca Holdings LLC Full time

    Company Overview">Seneca Holdings LLC is part of the Seneca Nation Group (SNG) portfolio of companies, meeting mission-critical needs of federal civilian, defense, and intelligence community customers. SNG receives shared services support from its parent company Seneca Holdings.">Salary">The estimated salary range for this position in the Washington, DC...

  • Multifamily Financial Engineering Model Advisor

    1 week ago

    Washington, United States The Fannie Mae Full time

    Unlock the potential of financial engineering in a dynamic and inclusive environment at The Fannie Mae. As a Multifamily Financial Engineering Model Advisor (Flexible Hybrid), you will play a pivotal role in analyzing complex data, developing models, and advising teams on business decisions.About This RoleThis exciting opportunity is designed for individuals...

  • Model Governance Expert

    1 week ago

    Washington, Washington, D.C., United States Fannie Mae Full time

    Compelling Opportunities at Fannie MaeWe are seeking a seasoned Model Governance Expert to join our team. This role offers the flexibility to make each day your own, while working alongside people who care.The Quality Assurance - Quantitative Modeling Lead Associate position will enable you to deliver high-quality results in a dynamic environment. As a key...

  • Data Analyst

    1 week ago

    Washington, Washington, D.C., United States ASCENDING Full time

    ASCENDING Seeks Data ScientistAbout the Role:ASCENDING is seeking an experienced Data Scientist to join our team. As a Data Scientist, you will be responsible for managing the entire Model Development Life Cycle (MDLC) process, from problem definition to model deployment and monitoring.Key Responsibilities:Problem Definition: Collaborate with business...