Synechron
Data Modeler/Architect with Azure
Synechron, Saint Paul, Minnesota, United States, 55130
Job Title: Data Modeler/Architect with Azure Location: Minneapolis, MN Full Time/ Permanent Contact: Syed.Khaliq Our Challenge: We are looking for a talented and experienced Data Architect to join our dynamic team and help us design and implement complex data models, lead our data analytics initiatives, and provide data architecture support to our clients. The ideal candidate will have a strong understanding of data modeling principles and techniques, create and maintain complex data models, including conceptual, logical, and physical data models, to support various business processes and applications, extensive experience in designing and implementing data models that support our large-scale, complex datawarehouses and data lakes . You will work closely with data engineers, analysts, and stakeholders to ensure that our data architecture is robust, scalable, and aligned with our business needs. A strong SQL skill with Azure knowledge is a definite plus and experience in Banking KYC is advantageous but not essential. The Role Responsibilities: Data Model Design: Design, develop, and maintain complex data models for large data warehouses and data lakes, ensuring they meet business needs and support data-driven decision-making. Data Architecture: Develop and document data architecture, including data flow diagrams, entity-relationship diagrams, and data dictionaries, to support comprehensive and efficient data management. SQL Development: Write, optimize, and troubleshoot SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes. Collaboration: Work closely with data engineers, analysts, and business stakeholders to understand requirements and translate them into effective data models and solutions. Performance Tuning: Analyze and optimize data model performance, addressing any issues related to data processing, retrieval, and query execution. Quality Assurance: Conduct data quality assessments and ensure data models adhere to data governance and quality standards. Technology Integration: Utilize Azure technologies and services (such as Azure Data Factory, Azure Synapse, or Azure SQL) where applicable to enhance data integration and processing. KYC Domain Knowledge: Apply knowledge of Banking KYC requirements to ensure data models support compliance and regulatory needs (preferred but not required). Best Practices: Stay current with industry best practices, emerging technologies, and methodologies in data modeling and apply them to improve data architecture and practices. Requirements: You are: Bachelor's degree in Computer Science, Information Systems, or related field. Proven experience as a Data Modeler/Architect with strong proficiency in SQL and database design. Proven experience as a Data Modeler with expertise in data modeling and database design. Proficiency in data modeling tools such as ERwin, ER/Studio, or similar. Strong understanding of relational databases, SQL, and database management systems. Proficiency in data modeling tools and techniques. Strong understanding of data governance, data quality, and data security principles. Experience with Azure technologies (e.g., Azure Data Factory, Azure Synapse, Azure SQL) is preferred. Experience or familiarity with the Banking KYC domain is preferred but not required. Strong analytical and problem-solving skills, with the ability to translate complex business requirements into effective data models. Excellent communication skills, with the ability to convey technical concepts to both technical and non-technical stakeholders. Relevant certifications in SQL and Azure are a plus. We can offer you: A highly competitive compensation and benefits package A multinational organization with 55 offices in 20 countries and the possibility to work abroad Laptop and a mobile phone 10 days of paid annual leave (plus sick leave and national holidays) Maternity & Paternity leave plans A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region) Retirement savings plans A higher education certification policy Commuter benefits (varies by region) Extensive training opportunities, focused on skills, substantive knowledge, and personal development On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms A flat and approachable organization A truly diverse, fun-loving and global work culture S YNECHRON'S DIVERSITY & INCLUSION STATEMENT Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative Synclusive' is committed to fostering an inclusive culture - promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.