Veteran-Owned Firm Seeking a Data Warehouse ETL Developer for a Hybrid Assignment based in Baltimore, MD My name is Stephen Hrutka. I own a Veteran-Owned management consulting firm in Washington, DC, focused on Technical/ Cleared Recruiting for the DoD and IC. HRUCKUS helps other Veteran-Owned businesses recruit for positions in the VA, SBA, HHS, DARPA, and other cutting-edge R&D-related defense agencies. Our client is seeking a Data Warehouse ETL Developer to support the Data Analytics Team at Baltimore County Public Schools. The ideal candidate is a Baltimore resident with at least 5+ years of experience in ETL methodologies and development, 3+ years of SSIS experience, and a bachelor’s degree in computer science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications, or related field experience. If you’re interested, I'd gladly provide more details about the role and discuss your qualifications further. Thanks, Stephen M Hrutka Principal Consultant www.hruckus.com Executive Summary: HRUCKUS is seeking a Data Warehouse ETL Developer to support the Data Analytics Team at Baltimore County Public Schools. Please note: The position is currently hybrid- part-time in the office and part-time virtual, but may soon revert completely to the office work site at Baltimore County Public Schools; Department of Research, Accountability, and Assessment; 9611 Pulaski Park Drive, Suite 307, Middle River, MD 21220. Position Duties and Responsibilities: • Support the Data Analytics Team in retrieving data from multiple data systems for use in data extracts, reports, and dashboards to ensure data quality before release. • Create, execute, and monitor ETL processes, including tracking and documenting findings. • Create test scripts using SQL programming to validate data points against transactional systems and the data warehouse. • Creating documentation needed to support the repeatability of testing metrics. • Develop and maintain the Data Warehouse based on business and technology requirements and industry-standard best practices. • Ability to work with SQL Server DBAs, system architects, and application developers to design stable, reliable, effective, and optimized databases. • Plan and coordinate data migrations between systems. • Assists in the formulation of business and testing requirements. • Develop high-quality deliverables. • Follows all required software development standards, change control procedures, and security requirements. • Ensure that the databases meet organization and performance requirements. • Ability to build relationships with project sponsors, stakeholders, other technical staff, vendors, and end-users. • Coordinates and performs required unit, system, and performance testing. • Works with other team members on User Acceptance testing and issue resolution. • Participates in continuous improvement activities by identifying and analyzing the effectiveness and efficiency of existing processes and developing strategies for improvements. • Produces status reports and communications regularly. The ideal candidate must possess the following: • Thorough knowledge of the principles and practices of software development best practices • At least five years of experience in ETL methodologies and development • Degree from an accredited college with a bachelor’s degree in computer science, Information Technology, Management Information Services, Business Management, Engineering, Project Management, Business or Public Administration, Communications, or a related field. It may be substituted with relevant software development experience of 5 or more years Required Skills: • 3+ years of SSIS experience • Experience working with Azure SQL Instance • Skill in SQL Server scripting • Skill in data modeling • Skill in the operation of computers and peripheral equipment • Skill in creative and analytic problem-solving • Understanding of Data Warehousing principles, concepts, and architecture • Ability to manage multiple priorities and meet project delivery dates • Ability to effectively analyze and manage requirements • Ability to visualize complex issues • Knowledge of personal computers, Microsoft Office suite of tools including Word, Excel, PowerPoint, and Visio • Knowledge of programming concepts and the Software Development Lifecycle (SDLC) • Ability to coordinate the work of a team with the work of other units within the Department of Research, Assessment, and Accountability and other BCPS offices, schools, and departments • Practical verbal and written communication skills • Ability to effectively communicate with all levels of users and team members Details: • Job Title: Data Warehouse ETL Developer • Location: 9611 Pulaski Park Drive, Suite 307, Baltimore, MD 21220 • Assignment Type: 12-month contract • Salary Rate: The target salary is $110,000 to $125,000 per year on W2.