Data Warehouse Architect & Administrator

CLASEN QUALITY CHOCOLATE • Madison, WI • 19h ago

JOB REQUIREMENTS: Clasen Quality Chocolate (CQC) is a world-class manufacturer of chocolate and innovative coatings. We have recently been awarded theTop Workplaces Award by the WI State Journal- No. 2 Large Employer and the Benefits Award. CQC has been growing double digits annually because of our flexibility, commitment, respect and integrity, and we are looking for quality individuals to join our team. Working for a family-owned company provides you with the opportunity to wear many different \"hats,\" make a difference every day, and have fun doing it! We are committed to being an Employer of Choice in Southern Wisconsin and offering our employees a variety of traditional and unconventional benefits. We are currently accepting applications for a Data Warehouse Architect & Administrator in our Corporate Office on the East side of Madison, WI ranked the \"#1 Best Place to Live\" by Livability.com JOB SUMMARY This position will play a key role in designing, implementing, and managing our enterprise data warehouse as we transition from Azure Synapse to Microsoft Fabric. The ideal candidate will have deep expertise in Microsoft data technologies, strong SQL skills, and a passion for data governance and security. QUALIFICATIONS: ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned. Architect and design the organization\'s data warehouse, ensuring scalability, performance, and alignment with business needs. Lead the migration from Azure Synapse to Microsoft Fabric, including planning, execution, and optimization. Serve as the primary administrator for the data warehouse, overseeing day-to-day operations, maintenance, and user support. Develop and enforce data governance policies, including data quality, metadata management, and access controls. Implement and monitor data security best practices to ensure compliance with internal and external standards. Collaborate with business stakeholders and team members to understand requirements and deliver robust data solutions. Optimize SQL queries and data models for performance and reliability. Provide documentation, training, and support to team members and end users. Communicate with third party vendors. Perform all tasks assigned by the supervisor, while following all company, safety, and quality policies and procedures. Maintain regular attendance 3 days per week in the office. ** OTHER EXPERIENCE AND QUALIFICATIONS: EDUCATION / EXPERIENCE: Four-year college degree in Information Technology or related field. Working knowledge of Microsoft Fabric Strong proficiency in SQL, including performance tuning and complex query development. 3+ years of experience in data architecture and administration, with a focus on Microsoft data technologies. Excellent communication and collaboration skills. Manufacturing knowledge preferred Working knowledge of Power BI datasets Working knowledge of Microsoft Azure SQL, Data Factor SKILLS AND ABILITIES: Technical aptitude and accuracy Analytical and problem-solving ability Customer focused Good interpersonal skills ** APPLICATION INSTRUCTIONS: Apply Online: https://workforcenow.adp.com/mascsr/default/mdf/recruitment/recruitment.html?cid=e49fd23d-5647-4b6e-a40c-7ba243da87e7&ccId=19000101000001&source=CC2&lang=enUS&selectedMenuKey=CurrentOpenings&jobId=5

Similar Jobs

Electro Mechanical Technician

PROMEGA CORPORATION • Madison, WI • 18h ago

IT & Engineering

JOB REQUIREMENTS: Job Description OUR TEAM: We\'re a collaborative group of skilled technicians and engineers who keep Promega\'s automated production systems running reliably and efficiently. Our team works hands-on wit...

18h ago

Go to Apply