Logo
Cynet Systems

Cynet Systems is hiring: Senior Programmer Analyst /Data Warehouse Technical Arc

Cynet Systems, Richmond, VA, United States

Job Description:

Responsibilities:
  • Provide technical oversight and support for existing data warehouse technologies including Oracle Data warehouse and DataStage.
  • Collaborate with Enterprise Architecture teams to define and implement roadmaps for transitioning to modern cloud-based data warehousing solutions.
  • Design, develop, and maintain data governance and management processes using tools like IGC, IKC, or Collibra.
  • Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies.
  • Ensure the data infrastructure meets the needs of business operations by ensuring data quality, integrity, and security.
  • Work closely with business analysts, developers, business users, architects, and DBAs to ensure the data warehouse supports business goals.
  • Drive initiatives related to data integration, ETL processes, and data migration strategies.
  • Provide leadership and mentorship to the data warehouse team, ensuring best practices in data architecture and engineering are followed.
  • Monitor performance and manage scaling strategies for existing data warehouse environments.
  • Stay up to date with industry trends and innovations in data warehouse and data management technologies, recommending improvements as necessary.
Required Skills and Qualifications:
  • 15+ years of experience in data warehousing and data architecture.
  • Extensive experience in data mining, large scale data modeling, data profiling, and data mapping.
  • Experience with Azure Cloud, Azure Data Factory, and Data Bricks.
  • Experience with different database platforms and services like SOAP, REST, etc.
  • Strong experience with Oracle, DataStage, and IBM Integration Bus (IIB) for data integration and ETL.
  • Solid experience with data management and governance tools like IBM Information Governance Catalog (IGC), Information Knowledge Catalog (IKC), or Collibra.
  • Expertise with modern cloud data warehouse platforms such as Azure Synapse or Snowflake.
  • Experience in defining and implementing data governance frameworks and ensuring data quality management.
  • Proven experience in designing and implementing scalable data warehouse solutions and strategies.
  • Understanding of ETL processes, data integration strategies, and data migration in both on-premise and cloud environments.
  • Familiarity with data modeling, data lakes, and big data technologies.
  • Strong analytical and problem-solving skills with the ability to balance competing priorities.
  • Experience working in collaboration with Enterprise Architecture teams to create strategic roadmaps for data platforms.
  • Excellent communication and stakeholder management skills, with the ability to work cross-functionally across teams.
Preferred Qualifications:
  • Knowledge of big data tools like Hadoop, Spark, and Kafka.
  • Certifications in Oracle, Azure, or Snowflake technologies.
  • Experience with data privacy regulations like GDPR, CCPA, and best practices in data security.
  • Experience with Automation and AI in Data Warehousing.
Personal Attributes:
  • Strong written and oral communication skills.
  • Strong presentation and interpersonal skills.
  • bility to present ideas in user-friendly language.