Data and Analytics Engineer

RahrBSG is looking for a Data and Analytics Engineer to join our team in Shakopee, MN. The Data and Analytics Engineer is responsible for managing and maintaining SQL Server data platforms, optimizing and troubleshooting advanced SQL queries and stored procedures, and providing business-oriented analytics solutions using Power BI. This role enables transformation and modernization to scalable cloud-based data platforms such as Microsoft Fabric and Azure Synapse Link.

The Data and Analytics Engineer, a key member of a small, high-performing data team, serves as a data expert and collaborates with both business stakeholders and IT colleagues to provide reliable, innovative, and user-friendly data solutions that support and empower decision-makers.

This is a hybrid role with a minimum of three days a week onsite at our Shakopee Minnesota Campus.

• Competitive Starting Base Salary Between $100k - $140k per year
• Annual Bonus
• Medical benefits with coverage paid for at 90%
• Dental and Vision Programs
• Generous Annual 401(k) Company Contribution of 15%
• Employee Assistance Program
• Paid Life Insurance
• Short Term Disability
• Long Term Disability
• Tuition Reimbursement
• Generous PTO
• Sick Time
• 12 Paid Company Holidays
• Career Growth and Progression Paths

• Support analytics, reporting, and data initiatives that collect and process data according to company needs and goals.
• Manage and support data platforms and solutions to enable the business, ensuring efficiency, scalability, and alignment with data architecture best practices.
• Plan and support data migrations, upgrades, and platform enhancements.

• Fulfill data-related requests, perform necessary data housekeeping, data cleansing, and data model changes.
• Work with the team to maintain data models, schemas, and storage structures that optimize performance and usability.
• Contribute to the design of data governance, data quality, and metadata standards.

• Collaborate with internal and external stakeholders to translate business and technical needs into data solutions.
• Support the development of analytics solutions through efficient data preparation and transformation.
• Provide guidance, assistance, and training to Power BI developers and users.

• Analyze data to spot anomalies, trends, and correlate similar data sets.
• Investigate and resolve data and analytics support issues, identify root causes, and proactively recommend activities to reduce risk of future issues.
• Implement data validation, monitoring, and alerting to ensure high data quality.
• Monitor platform performance and implement tools and processes to improve availability and reliability.
• Create and maintain technical documentation for data platforms and solutions.
• Manage work items, code, and release pipelines using Azure Dev Ops.
• Contribute to a culture of teamwork, collaboration, and continuous improvement.
• Partner with enterprise architecture, infrastructure, business analysts, and cybersecurity to ensure reliable, secure, and scalable data solutions.
• Perform additional duties as needed to support evolving business needs.

• Contribute to a culture of teamwork, collaboration, and continuous improvement.
• Partner with enterprise architecture, infrastructure, business analysts, and cybersecurity to ensure reliable, secure, and scalable data solutions.
• Perform additional duties as needed to support evolving business needs.

• Bachelor’s degree in IT, Computer Science, Engineering, or related field.
• 5+ years of experience in data and analytics.
• Strong technical proficiency in:
  • Microsoft SQL Server, SQL queries, and stored procedures.
  • ETL/ELT tools, such as Microsoft SSIS/SSRS or a comparable tool.
  • Power BI.
• Solid enterprise data warehouse experience, including data modeling and data schemas.
• Familiarity with cloud data platforms (Microsoft Fabric, Synapse Link, Azure Data Lake, or other cloud data platforms).
• Data integration experience with Microsoft Dynamics 365 Finance & Operations ERP is preferred.
• Knowledge of data governance and data quality…