The company is looking to solve the problem of identifying, defining, and documenting data assets, building scalable data pipelines, and migrating data into the Enterprise Data Management (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.
- 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 medallion architecture.
- Experience with cloud environments, such as Microsoft Azure.
- Experience with Microsoft cloud data tools such as Synapse, Purview, Notebooks.
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
- Bachelor's Degree in Computer Science, Mathematics, Management Information Systems, Business or related field and eight years of IT experience.
- Must pass pre-employment background check and drug screening.
- Must be able to provide REAL ID ACT compliant documentation at time of hire.
- Must be able to obtain Department of Energy access badge.
- Ability to obtain and maintain a U.S. government clearance (which requires U.S. Citizenship).
- Ability to travel by vehicle or aircraft, and ability to safely operate a motor vehicle.
