On Call Dimensional Engineer Jobs Near Me

Kimball Midwest, a national distributor of maintenance, repair, and operation products, is searching for a Software Engineer to join our Data team! We are looking for someone who is driven, passionate about data and technology, and excited about the future of Microsoft Fabric. This role requires a leader who stays up-to-date on technology trends, brings new ideas to the table, and thrives in a collaborative team environment within a Microsoft ecosystem.
As a Kimball Midwest associate, you'll be part of a company built on long-term growth and strong values. From $1 million in sales in 1983 to over $500 million today, our success has been driven by our people. Despite our growth, we have stayed true to our family-owned and operated roots-where employees are recognized as individuals and our culture remains a top priority.
What We Value

• Passion for data, technology, and continuous learning.
• Leadership and initiative to drive innovation.
• Collaboration and teamwork across diverse stakeholders.
• Curiosity and excitement about emerging technologies, especially Microsoft Fabric.
• Commitment to delivering high-quality, secure, and scalable data solutions.

Key Responsibilities

• Architect, develop, and maintain modern data platforms, including data warehouses and lakes.
• Design dimensional models that power reporting, analytics, and advanced insights.
• Build and optimize ETL/ELT pipelines using advanced SQL and PySpark transformations.
• Integrate data from diverse sources: SQL Server, Azure SQL, APIs, and flat files.
• Collaborate on systems such as Dynamics 365 F&SCM and CE, AX, CRM, Infios WMS, custom microservices, and legacy applications.
• Enable advanced analytics and AI/ML workloads through efficient, scalable data pipelines.
• Champion consistency in naming conventions and calculations in partnership with data governance and business teams.
• Implement robust data security measures, including access control, encryption, and auditing.
• Participate in on-call support rotation for complex tier-2/3 incidents.
• Stay ahead of industry trends, share knowledge, and proactively introduce innovative solutions.

Qualifications

• 5+ years of experience in data engineering or a related field.
• Bachelor's degree in Computer Science or equivalent experience.
• Proven passion for data and technology, with a record of continuous learning and leadership.
• Expertise in tools and languages: Python, SQL, Azure Synapse Analytics, Microsoft Fabric (Lakehouse, Dataflows), Azure Data Factory, Spark, Databricks, and integration with Power BI and Copilot.
• Strong understanding of Microsoft ecosystem and enthusiasm for Microsoft Fabric advancements.
• Microsoft Fabric experience highly preferred.

Additional Information
This is a fully on-site position reporting to the Columbus, Ohio office Monday through Friday.
We offer a benefits package that includes health, dental and vision insurance, company sponsored life, optional life and disability insurance, Health Savings Accounts and Flexible Spending Accounts, a 401(k) plus match, Tuition Assistance, Paid Parental Leave, Paid Time Off (PTO), a Dress for your Day dress code and paid holidays.
Kimball Midwest is an equal opportunity employer that is committed to a program of recruitment of females, minority group members, individuals with disabilities, qualifying veterans and any other classification that is protected by federal, state, or local law.
We Participate in E-Verify. Participamos en E-Verify.