Data Modelling and Analytics Engineer (Onsite)

This is an onsite position open to any qualified applicant in the United States.

We are Cognizant Artificial Intelligence

Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them.

With the power to apply artificial intelligence and data science to business decisions via enterprise data management solutions, we help leading companies prototype, refine, validate, and scale the most desirable products and delivery models to enterprise scale within weeks.

You must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.

Job Title: Data Modelling and Analytics Engineer (Onsite)

Location: Washington, DC.

Roles and Responsibilities:

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 collaborators 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 standard processes for DAX usage among team members.

Databricks and Azure Databricks Integration:

• Apply Databricks Lakehouse to run 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.

Sophisticated Hands-On Experiences:

• Use sophisticated 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:

• Supervise the performance of the Semantic Model, DAX queries, and data pipelines.
• Implement strategies to optimize performance as data volumes grow.

Required Qualifications:

• 10+ years of experience.
• Demonstrable experience with Power BI, including Semantic Model development and DAX.
• Expertise in SQL Query, Databricks Lakehouse, Azure Databricks, and DBT.
• Good understanding of data warehousing concepts and ETL processes.
• Familiarity with data visualization standard methodologies.
• Excellent analytical and problem-solving skills.
• Good communication and social skills.

Salary and Other Compensation:

Applications will be accepted until 10/27/2024.

The annual salary for this position is between $115,000.00 - $135,000.00 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program and stock awards, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.

Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network Assists Veterans in building and growing a career at Cognizant that allows them to demonstrate the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.