OSC Technical Solutions is looking to solve the problem of modernizing their Enterprise Data Management (EDM) environment by identifying, defining, and documenting data assets, building scalable data pipelines, and migrating data. This involves developing and maintaining data products and pipelines, implementing data management practices, and partnering with Solution Architects to design and implement processes for the evolving EDM environment.
Requirements
- Advanced knowledge of general data and database design concepts such as master data, tables vs views, normalization, data quality and security, etc.
- Strong understanding of flow charts, data flow diagrams, and system integration diagrams.
- Ability to research, organize and analyze technical information with particular attention to accuracy and detail.
- Demonstrated ability to learn new computer programs quickly.
- Proficient using Microsoft Office products, such as Word, Excel and PowerPoint, and industry-standard computer software and databases.
- Experience with legacy data and reporting environments such as Microsoft SQL Server, Oracle, Crystal Reports, or SSIS.
- Experience with cloud environments, such as Microsoft Azure.
Responsibilities
- Create detailed, well-structured data models and relationship diagrams.
- Analyze and verify existing data sources for accuracy and relevance.
- Design test cases, scenarios and test plans based on documented requirements.
- Ensure data quality, integrity and timeliness by developing robust and resilient data pipelines.
- Integrate structured and unstructured data sources into the Lakehouse architecture, creating standardized and enriched models for advanced analytics.
- Partner with infrastructure team to optimize cloud architecture for performance, scalability, and cost-efficiency, enabling reliable and efficient data processing at scale.
- Partner with data analysts, scientists and stakeholders to enhance organizational data capabilities and drive data-informed decision-making.
Other
- Perform all work safely and in compliance with environmental obligations using the core functions and core. elements of the Integrated Safety Management System/Environmental Management System (ISMS/EMS).
- Prepare and maintain required documentation, including weekly status reports.
- Work well under pressure and independently prioritize workload, while working on multiple projects.
- Make decisions, solve problems, and exercise excellent judgment.
- Strong technical writing skills.
