Salary
💰 $120,660 - $224,000 per year
Tech Stack
AzureCloudMS SQL ServerOracleSQLSSIS
About the role
- Collaborate with Data Stewards to identify, define, and document data assets.
- Build scalable data pipelines and migrate data into the Enterprise Data Management (EDM) environment.
- Manage data quality and data security.
- Analyze and verify existing data sources for accuracy and relevance.
- Create detailed, well-structured data models and relationship diagrams.
- Business process analysis and understanding of flow charts, data flow diagrams, and system integration diagrams.
- Collaborate with business stakeholders and end-users to elicit and document data requirements.
- Support the implementation of IT solutions aligned with business needs.
- Partner with quality assurance teams to develop test cases, scenarios, and test plans based on documented requirements.
- Prepare and maintain required documentation, including weekly status reports.
- Engage with software engineers, project managers, customers, and quality assurance professionals across all levels.
- Design, build, and maintain scalable data models, ELT processes, and pipelines to support enterprise-wide reporting and analytics.
- Integrate structured and unstructured data sources into the Lakehouse architecture.
- Partner with infrastructure team to optimize cloud architecture for performance, scalability, and cost-efficiency.
- Provide technical leadership and mentorship across teams.
- Tackle challenging data problems and foster best practices.
Requirements
- Bachelor's Degree (Computer Science, Mathematics, Management Information Systems, Business or similar) and 8 or more years of IT experience, or an equivalent combination of IT education, training and experience.
- You are analytical and solution oriented.
- Ability to manage multiple projects from beginning to completion.
- Excellent written and verbal communication skills.
- Proven technical writing experience.
- Strong organizational skills and can work under tight deadlines.
- Commitment to teamwork and collaboration.
- Highly self-motivated and self-directed.
- Ability to learn new computer programs quickly.
- Must pass pre-employment background check.
- Must pass pre-employment drug screening.
- Applicants are required to have REAL ID ACT compliant documentation at time of hire and nothing on record that would prohibit you from gaining access to Department of Energy sites.
- Candidates may be required to obtain and hold a Secret or Higher US Government Clearance.
- Experience with legacy data and reporting environments such as Microsoft SQL Server, Oracle, Crystal Reports, SSIS (preferred).
- Experience with medallion architecture (preferred).
- Experience with cloud environments, preferably Microsoft Azure (preferred).
- Experience with Microsoft cloud data tools such as Synapse, Purview, Notebooks (preferred).
- Familiarity working in a Nuclear Quality Assurance (NQA-1) or similar regulatory environment (preferred).