We are looking for a skilled Data Engineer to join our team on a long-term contract basis. This role is based in West Des Moines, Iowa, and offers the opportunity to work on advanced data solutions that support organizational decision-making and efficiency. The ideal candidate will have expertise in relational databases, data cleansing, and modern data warehousing technologies.<br><br>Responsibilities:<br>• Develop, maintain, and optimize data pipelines to support business operations and analytics.<br>• Perform data extraction, transformation, and cleansing to ensure accuracy and reliability.<br>• Collaborate with teams to design and implement data warehouses and data lakes.<br>• Utilize Microsoft SQL Server to build and manage relational database structures.<br>• Analyze data sources and provide recommendations for improving data quality and accessibility.<br>• Create and maintain documentation for data processes, pipelines, and system architecture.<br>• Implement best practices for data storage and retrieval to maximize efficiency.<br>• Troubleshoot and resolve issues related to data processing and integration.<br>• Stay updated on industry trends and emerging technologies to enhance data engineering solutions.
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.