Data Architect (Snowflake)
InfoCepts - boston, MA
Apply NowJob Description
Job Title: Senior Data Integration Architect (DBT+ Snowflake) Work Location: Hybrid - Boston, MAType of Employment: FTE ExemptPurpose of the Position: As a Senior Data Integration Architect (DBT), You will be responsible for development, and optimization of data solutions using Snowflake and DBT, ensuring efficient data integration, transformation, and real-time analytics. This role involves collaborating with cross-functional teams to translate business requirements into technical solutions, maintaining data integrity and compliance, and driving innovation in data engineering practices. Infocepts is a global leader of end-to-end data and analytics solutions with nearly 20 years' experience enabling customers to derive value from a variety of data-driven capabilities. Unique among its peers, InfoCepts operates with the scale of a global consulting firm, yet the expertise of a niche partner. At Infocepts, you'll be challenged to think innovatively, while growing your own personal and professional skills designed with the future in mind. We have more than 1200 global professionals working on cutting edge technology solutions with a single mission - transforming our customers' journey with data-driven modernization. Infocepts has been recognized as Gartner Peer Insights â„¢ Customers' Choice for two consecutive years in 2020 and 2021 which recognizes our best-in-class services that help our customers approach any data analytics problem. We are certified by Great Place to Work®, India in 2021, 2022, 2023 which recognizes our high-trust and high-performance work culture, and great employee experience in the industry. Our award-winning reusable solutions approach is well recognized in the D&A industry and lets our associates leverage our collective and proven consultative expertise, accelerate solution delivery through automation, enable faster time to value with reusable toolkits - all while delivering exceptional customer experience. Our success has been unique, and we are looking for professionals who are enthusiastic and passionate about data & analytics, delivering differentiated experiences, and solving real world problems for our global customers. This position works with the competency and delivery team to execute on the assigned responsibilities. Key Result Areas and Activities: Data Architecture and Pipeline Development: Design, build, and maintain robust Snowflake architectures and data pipelines using DBT to ensure efficient data integration and transformation. Performance Optimization: Optimize the performance of Snowflake databases and DBT models to ensure high efficiency and scalability of data solutions. Data Quality and Compliance: Ensure data integrity, quality, and compliance with data governance and security policies. Collaboration and Stakeholder Management: Work closely with analysts, and business stakeholders to understand requirements and deliver effective data solutions. Innovation and Continuous Improvement: Drive innovation in data engineering practices and continuously improve processes and tools to enhance data capabilities. Essential Skills: Deep understanding of Snowflake architecture, data warehousing, and performance optimization, High proficiency in SQL Collaborate with analysts and business stakeholders to gather requirements, translate them to business requirements, design scalable and reliable solutions Strong skills in developing, testing, and deploying DBT models for data transformation and pipeline management. Expertise in data modelling (both relational and dimensional) and designing efficient ETL processes. Agile - SCRUM, JIRA and Prior experience in Analytics with PowerBI know how Preferred Skills:Basic knowledge of integrating machine learning models and AI algorithms with data pipelines. Experience with DevOps practices and continuous integrationcontinuous deployment (CICD) pipelines. Understanding of compliance standards such as GDPR, HIPAA, etc Pharmaceutical experience - Commercial Operations, Patient Engagement Qualifications: Minimum of 8+ years of experience in data engineering, with a focus on Snowflake and DBT. Proven track record of designing and implementing data solutions in complex environments. Relevant certifications in Snowflake and other cloud technologies are highly desirable. Bachelor's or master's degree in computer science, Information Technology, Data Science, or a related field. Qualities: Can influence and implement change; demonstrates confidence, strength of conviction and sound decisions Able to consult, write, and present persuasively. Able to work seamlessly with clients across multiple geographies. Excellent analytical, presentation and reporting skills. Collaborate with data engineers, analysts, and stakeholders to translate business requirements into technical solutions. Strong problem-solving skills and ability to work effectively in a collaborative team environment. Approach problems logically and systematically; persistent and patient in tackling issues. Work effectively in a self-organized, cross-functional team. Iterate based on new information, peer reviews, and feedback. Work seamlessly with clients across multiple geographies. Research-focused mindset. Proficient in English communication (readwritespeak) and able to consult, write, and present persuasively.
Created: 2024-10-07