We are looking for a skilled Data Analytics Engineer with deep expertise in Power BI to join our team in Ankeny, Iowa. In this role, you will design, optimize, and manage semantic data models while ensuring the seamless performance of business intelligence tools. Your contributions will help drive data-driven decision-making across the organization.<br><br>Responsibilities:<br>• Design and implement semantic data models, including dimensional modeling and star schemas, to support business intelligence needs.<br>• Develop and optimize Power BI reports and dashboards, ensuring high performance and efficient query execution.<br>• Utilize Power Query (M) to transform and manipulate data for reporting purposes.<br>• Configure and enforce row-level security within Power BI to safeguard sensitive data.<br>• Conduct performance tuning for Power BI, including query plan optimization and refresh strategies.<br>• Collaborate with stakeholders to understand analytical requirements and translate them into actionable insights.<br>• Leverage tools such as Tabular Editor and deployment pipelines (Azure DevOps, GitHub) to streamline BI asset management.<br>• Work with cloud-based data platforms, including Databricks, Snowflake, or BigQuery, to support lakehouse architectures.<br>• Maintain adherence to enterprise BI governance practices and ensure scalable solutions for large datasets.<br>• Implement CI/CD patterns to manage semantic models and facilitate environment promotions.