Senior Data Architect - Remote / Telecommute, Cynet Systems, All cities, AK
Cynet Systems -
All cities, AK,
US
Senior Data Architect - Remote / Telecommute
Date Posted: 2024-05-12
Job description
Job Description:
Minimum Requirements:
- gile Project Work: Work in cross-functional, geographically distributed agile teams of highly skilled delivery teams to continuously innovate analytic solutions.
- Develop data requirements through data modeling techniques and structured working sessions.
- Take action to express data requirements as 3rd Normal Form logical data models through review of source system documentation, review of system features, and workshop sessions.
- Create physical databases design for the Snowflake data warehouse and other database technologies in partnership with other technical resources.
- Develop documentation of Data Lineage and Data Dictionaries to create a broad awareness of the enterprise data model and its applications.
- Develop real-time/bulk data pipelines from a variety of sources (streaming data, APIs, data warehouse, messages, images, video, etc).
- Partner with key business SMEs to build and manage the workgroup database view library by building relevant data shapes in SQL.
- ctively apply best practices within DataOps (Version Control, P.R. Based Development, Schema Change Control, CI/CD, Deployment Automation, Test Automation, Shift left on Security, Loosely Coupled Architectures, Monitoring, Proactive Notifications).
- Problem-Solving/Project Management: Constructively challenge while actively participating in problem-solving to enrich possible solutions.
- rchitecture: Utilize modern cloud technologies, follow established design patterns, and employ best practices from DevOps/DataOps to produce enterprise-quality production Python and SQL code with minimal errors.
- Participate in regular code review sessions, collaboratively discuss opportunities for continuous improvement, and diligently implement feedback in all solutions.
- Self-Development: Flexibly seek out new work or training opportunities to broaden experience.
- Independently research the latest technologies and openly discuss applications within the department.
- Perform other duties as requested.
Minimum Requirements:
- Bachelors degree in engineering, computer science, analytical field (Statistics, Mathematics, etc.), or related discipline and three (3) years of relevant work experience
- Masters or Ph.D. in engineering, computer science, analytical field (Statistics, Mathematics, etc.), or related discipline and one (1) year of relevant work experience.
- Knowledge of data models using IDEF1X or similar data modeling methodologies.
- Knowledge of data modeling tools like ER Studio or ERwin.
- Proficient practitioner of SQL development.
- Experience leading joint design sessions and working in groups.
- Proficient practitioner of Python development.
- Working knowledge of Software Engineering and Object Orient Programming Principles.
- Working knowledge of Parallel Processing Environments such as Snowflake or Spark SQL.
- Working knowledge of problem-solving/root cause analysis on Production workloads
- Working knowledge of Agile, Scrum, and Kanban
- Working knowledge of enterprise scheduling and workflow orchestration using tools such as Airflow, Prefect, Dagster, or similar tooling.
- Working knowledge with CI/CD and automation tools like Jenkins or Azure DevOps.