Data Transformation Specialist/Database Developer

$66,100 - $135,600/Yr

CACI International - Rockaway Township, NJ

Full-time - Mid Level

Rockaway Township, NJ

Professional, Scientific, and Technical Services

About the position

As a Data Transformation Specialist / Database Developer, you will be instrumental in modernizing and transforming legacy data tools into efficient systems for the U.S. Navy Self Defense Systems Division at Picatinny Arsenal, New Jersey. This role involves collaborating with cross-functional teams to enhance data management, accessibility, and collaboration, ensuring that the Navy's data needs are met effectively.

Responsibilities

• Analyze and assess legacy tools, including Excel tracking spreadsheets and MS Access databases, to develop modern, scalable database solutions.
• Lead transformation efforts, ensuring data is transitioned into optimal formats for relational databases.
• Develop, configure, and manage Point Lists and other data storage solutions for team-wide sharing and access.
• Design and implement front-end applications using Microsoft PowerApps.
• Create dynamic dashboards with Microsoft Power BI to visualize data insights.
• Collaborate with internal teams to understand business requirements and translate them into technical solutions.
• Optimize database structures and ensure data accuracy and integrity throughout the transformation process.
• Build analytical tools to extract data from modernized systems for advanced reporting and decision-making.

Requirements

• U.S. Citizenship
• Active Secret Security Clearance, or the ability to obtain one
• Minimum bachelor's degree in a field related to computer or information science
• Minimum of 3 years' experience building database solutions
• Strong proficiency in relational databases and SQL
• Hands-on experience with data migration, transformation, and database design
• Experience in developing solutions for cross-team sharing
• Familiarity with Microsoft Power Platform tools (PowerApps, Power BI) or similar tools
• Strong problem-solving skills
• Excellent communication and collaboration skills

Nice-to-haves

• Familiarity with scripting languages such as Python, VBA, JavaScript, or Power Fx
• Certifications or training certificates relating to Microsoft Power Platform or related technologies

Benefits

• Healthcare
• Wellness programs
• Financial benefits
• Retirement plans
• Family support
• Continuing education
• Flexible time off