Title: Data Engineer
Location: Remote
About iWorks:
iWorks Corporation, founded in 2005, is a leading provider of information technology and professional services to the federal government. We are a recognized leader in personnel security and vetting solutions, Agile, DevOps, DevSecOps, data analytics, and cloud solutions. Our continuous process improvement approach, combined with our business and technology expertise, results in innovative solutions.
About this position:
We are seeking a highly skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will be responsible for performing data mapping, data quality management, metadata management, and master data management, as well as conducting in-depth data analysis to inform and progress our current and future data operating models. The Data Engineer will play a critical role in shaping our data architecture and ensuring the integrity and quality of our data assets.
Salary Range: 115k-125k - commensurate with the candidate's skills, experience, location, and qualifications.
On a day-to-day basis you will:
-
Develop, maintain, optimize, and document SQL queries for data analysis and reporting tasks to ensure, reuse and meet stakeholder needs.
-
Identify and fix data issues (e.g., missing values, outliers, duplicates, inconsistencies) by developing and executing Oracle DML statements, and clean and preprocess raw data for accuracy and consistency.
-
Using Excel and SQL to prepare, analyze, and transform data; conduct statistical analyses; and create visual reports to highlight trends and insights.
-
Communicate findings and insights clearly to both non-technical and technical stakeholders using tools such as Excel, Word, PowerPoint, and Visio.
-
Continuously monitor and implement data validation checks, manage data quality, metadata, and master data, and perform data mapping and analysis. Document findings, provide recommendations, and develop data architecture artifacts to enhance current and future data operating models.
-
Leverage AWS services (e.g., S3, RDS, Lambda) to manage, store, and process large datasets, ensuring data security and compliance with best practices.
-
Monitor and manage data storage costs in AWS, ensuring efficient use of resources and scalability of the database environment.
Required Education/Qualifications:
-
Clearance: MUST be fully adjudicated & maintain a Top Secret security clearance or higher.
-
Associate/bachelor's degree with 3+ years of relevant experience
-
Proficiency in Excel, Visio, and Oracle SQL Developer.
-
Experience performing the tasks identified above in AWS and Oracle environments.
-
Strong expertise in data analysis, data architecture, and data services development.
-
Ability to work independently and as part of a team, effectively collaborating with various stakeholders.
-
Advanced analytical and troubleshooting skills with good problem-solving abilities.
-
Experience working with and supporting Agile development teams.
-
Excellent written and verbal communication skills
Preferred Qualifications:
-
Experience with data visualization tools (e.g., Tableau, Power BI, or Pentaho Report Designer) is a plus.
-
Knowledge of data governance and data management best practices is also a plus.
Security+ Certification, preferred
FLSA & EMPLOYMENT STATUS: FLSA EXEMPT AND FULL-TIME POSITION
iWorks Corporation is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, Veteran status, sexual orientation, or other protected characteristic.
