Data modelling and Analytics engineer
1 month ago
Role: Data modelling and Analytics engineer.
Location : Washington District of Columbia
FTE Rate: $130k $150k
The pay range for this role is $130k $150k per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical vision dental life disability insurance and paid time off (including holidays parental leave and sick leave as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level educational qualifications experience and location of the candidate.
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 HandsOn Experiences:
o Utilize advanced Power BI features including rowlevel 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 userfriendly 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 problemsolving skills.
Strong communication and interpersonal skills.
-
Data Engineer
6 months ago
Columbia, United States Techizee Inc. Full timeJob Description Position Title: Data Engineer Key Required Skills: Technical experience in information architecture, data architecture, data modeling, data governance, ETL design, data quality and BI-analytics. Position Description · Collaborate with Solution & Enterprise Architects, Business analysts, DBAs and others to understand business requirements. ·...
-
Data Engineer
2 months ago
Columbia, United States Techizee Inc Full timeJob DescriptionJob DescriptionPosition Title: Data EngineerKey Required Skills: Technical experience in information architecture, data architecture, data modeling, data governance, ETL design, data quality and BI-analytics.Position Description · Collaborate with Solution & Enterprise Architects, Business analysts, DBAs and others to understand business...
-
Data Engineer
4 weeks ago
Columbia, United States The Swift Group Full timeJob DescriptionJob DescriptionThe Swift Group is seeking a highly motivated and experienced Data Engineer to join our fast-paced data team. You will play a critical role in ensuring the successful acquisition and management of mission-critical and mission support data sets. You will work closely with our team of experts to design and implement data solutions...
-
Data Engineer
2 weeks ago
Columbia, United States Metronome LLC Full timeJob Title: Data Engineer Location: Columbia, MD Status: Hybrid Employment Type: Full-Time Clearance Level: Secret Education: 5+ years of experience as a developer, analyst, or engineer with Bachelors in related field; 3 years relevant experience with Masters in related field; in related field; or High School Diploma or equivalent and 9 years relevant...
-
Data Scientist
1 week ago
Columbia, United States Tailored Access LLC Full timeDescription Experience must be in designing/implementing machine learning, data science, advanced analytical algorithms, programming (skill in at least one high- level language (e.g. Python)), statistical analysis (e.g. variability, sampling error, inference, hypothesis testing, EDA, application of linear models), data management (e.g. data cleaning and...
-
Data Scientist
1 week ago
Columbia, United States Tailored Access LLC Full timeDescription Experience must be in designing/implementing machine learning, data science, advanced analytical algorithms, programming (skill in at least one high- level language (e.g. Python)), statistical analysis (e.g. variability, sampling error, inference, hypothesis testing, EDA, application of linear models), data management (e.g. data cleaning and...
-
Data Scientist
1 month ago
Columbia, United States Tailored Access LLC Full timeDescription Experience must be in designing/implementing machine learning, data science, advanced analytical algorithms, programming (skill in at least one high- level language (e.g. Python)), statistical analysis (e.g. variability, sampling error, inference, hypothesis testing, EDA, application of linear models), data management (e.g. data cleaning and...
-
Data Engineer
6 months ago
Columbia, United States Merit 321 Full timePosition: Data Engineer Location: Columbia, MD (Hybrid) Clearance: Current active PLACEMENT MANAGER, SCI eligible Summary We are looking for a talented Data Engineer to support the acquisition of mission critical and mission support data sets. The preferred candidate will have a background in supporting cyber and/or network related missions within the...
-
Data Analyst, Data Analytics
1 week ago
Columbia, United States Enterprise Community Partners Full timeEnterprise is a national nonprofit that exists to make a good home possible for the millions of families without one. We support community development organizations on the ground, aggregate and invest capital for impact, advance housing policy at every level of government, and build and manage communities ourselves. Since 1982, we have invested $72 billion...
-
Data Scientist 3
6 days ago
Columbia, United States inovex Full timeQualifications Foundations: (Mathematical, Computational, Statistical) Bachelor's Degree with 10 years of relevant experience Associates degree with 12 years of relevant experience Bachelor's Degree must be in Mathematics, Applied Mathematics Statistics, Applied Statistics, Machine Learning, Data Science, Operations Research, or Computer Science or a degree...
-
Big Data
1 week ago
Columbia, United States Quadrant Full timeBig Data Engineer Columbia, MD Pay: $140,000 per yearMUST: Active Secret government security clearance 5+ years experience as a developer, analyst, or engineer Experience with programming languages such as Python and Java required Proficiency with acquisition and understanding of network data and the associated metadata required Fluency with data extraction,...
-
Big Data
5 days ago
Columbia, United States Quadrant Full timeBig Data Engineer Columbia, MD Pay: $140,000 per yearMUST: Active Secret government security clearance 5+ years experience as a developer, analyst, or engineer Experience with programming languages such as Python and Java required Proficiency with acquisition and understanding of network data and the associated metadata required Fluency with data extraction,...
-
Senior Data Solutions Architect
1 week ago
Columbia, Maryland, United States Techizee Inc Full timeAt Techizee Inc, we're seeking a highly skilled Data Engineer to join our team. The estimated salary for this position is $120,000 - $180,000 per annum.About the RoleWe're looking for an experienced professional who can collaborate with Solution Architects, Business Analysts, DBAs, and other stakeholders to understand business requirements and provide...
-
Engineer - Data Engineer
3 weeks ago
Columbia, MD, United States Quadrant Inc Full timeJob ID: 24-04168 Learn more about the general tasks related to this opportunity below, as well as required skills. Data Engineer Columbia, MD MUST: Active Secret government security clearance 5+ years experience as a developer, analyst, or engineer Experience with programming languages such as Python and Java required Proficiency with acquisition and...
-
Sr. Cloud Software Engineer
5 days ago
Columbia, United States PLEX Solutions, LLC Full timePLEX Solutions, LLC is seeking a Sr. Cloud Software Engineer to support a contract in the Annapolis Junction, MD area. This role will require an active security clearance to start. Required Skills: BS in Computer Science or a related technical field. Eight (8) years of experience in software development/engineering, including requirements analysis,...
-
Analytics Engineer
3 days ago
Columbia, United States MEDSTAR HEALTH Full timeGeneral Summary of PositionSupports on-site teams with data collection, reporting, interpretation, and analysis. Supports related clinical and operations performance improvement in focused areas across MedStar Health by functioning as an analyst, facilitator, consultant, and/or project manager as required. Supports the attainment of improvements in clinical...
-
Analytics Engineer
3 days ago
Columbia, United States MEDSTAR HEALTH Full timeSupports on-site teams with data collection, reporting, interpretation, and analysis. Supports related clinical and operations performance improvement in focused areas across MedStar Health by functioning as an analyst, facilitator, consultant, and/or project manager as required. Supports the attainment of improvements in clinical and operational practice to...
-
Columbia, South Carolina, United States Integer Technologies Full timeAbout the RoleInteger Technologies is seeking a highly skilled Electrical Power Systems Modeling and Simulation Specialist to join our team in Columbia, South Carolina. As a key member of our power & energy systems portfolio, you will work on developing and applying digital twins for Electrical Power and Energy Systems components and systems, including...
-
Intern: Data Science
3 weeks ago
Columbia, United States EquipmentShare Full timeIntern: Data Science Hiring Manager(s): Danielle Quinn and Hayden Mills EquipmentShare is searching for a student intern to join the Data Science team at our Home Office in Columbia, Mo for the 2025 spring or summer programs. Responsibilities: Apply modern advanced analytics methods (predictive modeling, Machine Learning, and optimization), as well as a...
-
Marketing Data ScientistAnalyst W2 Contract
2 weeks ago
Columbia, United States Blend360 Full timeJob Description We are looking for a Lead Marketing Analyst to join our team as a contractor. At Blend our Data Scientists work with business leaders to solve our clients’ business challenges. We work with clients in marketing, revenue management, customer service, inventory management and many other aspects of modern business. Our Data Scientists have the...