What are the responsibilities and job description for the Data Architect position at cpisecurity?
CPI Security, a national leader in residential and commercial security solutions, is seeking a Data Architect to join us on our data transformational journey. This is an exciting, hands-on opportunity to implement a cloud data platform at a company that has fully embraced the Snowflake platform. This role will work directly with line of business leaders and technical users to design and implement our cloud data warehouse. CPI will leverage the data cloud for in our data warehouse, machine learning, and AI journies. The ideal person will have extensive experience designing, building, and implementing data warehouses in the cloud. This is an on-site position at our HQ in Charlotte, NC.
What You'll Do:
- Cloud migration: Play and integral role in planning, designing, and implementing the data and digital migration.
- Modernize finance data systems: Support the data migration and modernization of the ERP system, redesign data structures, build new finance data processes, analytics models, and reporting capabilities.
- External data integration: Integrate and operationalize data from external systems such as CRM and IVR platforms via secure cloud data sharing, CDC, and APIs.
- Modernize BI & Analytics: Enhance and streamline reporting and analytics capabilities using leading BI and dashboarding platform that rely on timely, accurate, and correct data.
- Data Modeling: Apply best practices for data modeling; knowledge of Data Vault 2.0, Kimball, Inmon and/or document modeling to build scalable, audit-friendly, business-aligned data structures.
- Build & Automate Pipelines: Design and implement data transformation models using tools like VS Code, dbt, and SQL to build ingestion/processing pipelines using Python.
- Cloud Data Engineering: Understand the modern data engineering experience and agile practices to deliver data solutions. Utilize cloud-native services to enable scalable, secure, and efficient data processing.
- DataOps - Enable reliable, scalable, and automated data workflows by implementing DataOps best practices for continuous integration, testing, deployment, and monitoring across the data pipeline lifecycle.
What We're Looking For:
- 5 - 10 years of experience as a cloud data architect using platforms like Snowflake (preferred) , Databricks, and Google Big Query.
- 5 – 10 years of experience with designing ETL/ELT data pipelines.
- 5 years of experience building data warehouses using Snowflake Data Cloud.
- Deep understanding of Snowflakes security and RBAC model to ensure data security and privacy.
- Data Architect perspective and thinker with an ability to capture current-state and design future-state architectures while delivering immediate business value.
- Strong technical hands-on skills combined with solution design and stakeholder collaboration abilities
- Excited to help build a modern, cloud-first data platform that empowers business transformation
- Deep understanding of the following
- Data Modeling
- Data Engineering
- Orchestration
- Data Governance and Security
- Data Quality
- Understanding of cloud platforms like AWS, Azure, Google Cloud.
- Excellent oral and written communication skills to effectively deliver messages to a wide range of audiences - from executive to technical
- Innovative and positive team member mindset
- Strong teamwork and interpersonal skills, with the ability to deliver results working independently or in a collaborative environment (agile experience preferred)
Other Experience Required
- Bachelor’s degree in Information Systems, Computer Science, or related field of study preferred or work experience equivalent
- A minimum of 5 years of Snowflake experience and configuring declarative solutions
- Snowflake certifications in data engineering and/or architecture is desired.
What’s In It For You:
- Competitive Salary
- Comprehensive and on-going training when you start, includes leadership development.
- Engaging and fun company culture that succeeds through diversity.
- Great medical, dental, vision, 401(k) with company match, short-term & long-term disability and life insurance options. Company paid holidays, floating holiday and (PTO).
- Free monitored security system after 90 days.
