Job Information
CIRTEC MEDICAL CORPORATION Data Warehouse Architect in Brooklyn Park, Minnesota
About us: For over three decades, Cirtec Medical has been a leading outsourcing partner for complex medical devices. We specialize in providing comprehensive solutions for Class II and III devices, from design and development to precision components and finished device assembly. Our expertise spans neuromodulation, implantable drug delivery, cardiac rhythm management, structural heart, mechanical circulatory support, and minimally invasive surgical systems. Our dedicated teams prioritize growth, innovation, and collaboration. We actively seek opportunities for improvement to enhance our support for clients. If you embrace a growth mindset and thrive on challenges, you may be a perfect fit for our team! Position Summary: The Data Warehouse Architect is responsible for designing, developing, and maintaining the organization's data warehouse and related data infrastructure. This role involves working closely with business stakeholders, data analysts, and IT teams to ensure data is accurately collected, stored, and accessible for reporting and analysis. The Data Warehouse Architect will develop and optimize ETL processes, manage data integrations, and ensure the reliability, scalability, and performance of the data warehouse. The ideal candidate will have strong technical skills in database management, data modeling, and cloud-based data solutions, as well as a deep understanding of business intelligence and analytics. Key Responsibilities: Design, develop, and maintain scalable and high-performance SQL databases, ensuring they meet business requirements. Architect and implement data warehouse solutions, including data integration, ETL processes, and optimization. Create, manage, and optimize stored procedures, views, functions, and queries to support reporting and business intelligence initiatives. Collaborate with IT, business analysts, and other stakeholders to define data requirements and develop solutions that align with company goals. Optimize database performance by monitoring and tuning queries, database indexes, and other database components. Ensure data integrity, security, and compliance within the database systems, adhering to industry standards and company policies. Support existing ERP systems and third-party integrations with respect to data warehouse needs. Develop and maintain technical documentation, including data flow diagrams, data dictionaries, and database schemas. Provide technical guidance and support to other developers and end-users as needed. Must Have: Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent work experience). 5+ years of experience in SQL database development, with a strong focus on data warehouse design and ETL processes. Proven experience in SQL Server, Oracle, or other relational database management systems. Proficiency in writing complex SQL queries, including the use of stored procedures, triggers, and performance tuning techniques. Strong understanding of data modeling, database architecture, and data governance best practices. Knowledge of BI tools (Power BI, Tableau, etc.) and how to integrate them with a data warehouse. Ability to collaborate effectively with cross-functional teams and communicate technical concepts to non-technical stakeholders. Strong analytical skills and attention to detail, with a commitment to data accuracy and reliability. Good to have: Experience with cloud-based data warehouse solutions (e.g., Azure Synapse, AWS Redshift) is a plus. Competitive market salary from 100 to 115K/yr depending on qualifications and experience. Cirtec Medical Corporation considers for employment and hires qualified candidates without regard to age, race, religion, color, sex, sexual orientation, gender identity, national origin, ancestry, protected veteran or disability status or any factor prohibited by law. Cirtec Medical Corporation and all of its related companies fully endorse equal opportunity for all. Cirtec Medical provides reaso able accommodation for qualified individuals with disabilities and disabled veterans in the job application process. We work to create a culture that is built on innovation, respect, transparency and communication, and hope you take pride in being a member of our team. It is Cirtec's goal to create a great work environment and to keep the company a great place to work. We offer a wide range of benefits, resources, and competitive compensation plans designed to support you at every career and life stage. Our benefits include Training and career development, Healthcare and well-being programs including medical, dental, vision, wellness and occupational health programs, Paid Time Off and 401(k) retirement savings with a company match. Cirtec Medical Corporation considers everyone for employment and hires qualified candidates without regard to age, race, religion, color, sex, sexual orientation, gender identity, national origin, ancestry, protected veteran or disability status or any factor prohibited by law. Cirtec Medical Corporation and all its related companies fully endorse equal opportunity. Cirtec Medical provides reasonable accommodation for qualified individuals with disabilities and disabled veterans in the job application process.