ETL Developer (Local Only)

Company Overview At 4A Consulting, we turn complexity into opportunity. Founded in 2014 and headquartered in Baltimore, MD, we are a women-owned, boutique consulting firm specializing in delivering innovative, data-driven solutions to both the Federal Government and Fortune 500 clients. Our team blends deep industry knowledge with advanced technologies to design tailored strategies that drive measurable and sustainable outcomes. We pride ourselves on an agile, collaborative approach that helps organizations navigate challenges and seize emerging opportunities in a rapidly evolving digital landscape. At 4A, we don’t just deliver projects, we build trusted partnerships that empower our clients to lead with confidence in the digital age. Position Overview The Data Engineer will serve as a key contributor to the design, development, and enhancement of a modern data integration hub. You will support end-to-end data engineering activities—including data acquisition, complex SQL development, ETL automation, validation, and performance optimization—within an Agile SDLC framework. This role requires strong analytical skills, deep technical expertise in Informatica, SQL, and dimensional modeling, and the ability to work closely with architects, developers, analysts, and business teams to deliver reliable, scalable data solutions. Key Responsibilities • Lead and participate in Agile development activities, including requirements, design, development, testing, and deployment. • Acquire data from a variety of sources and prepare it for analytical and operational use. • Design and develop complex SQL scripts to transform data into dimensional models and build views and materialized views. • Develop ETL automation using Informatica Power Center or IICS, including extraction, transformation, and loading of structured and semi-structured data. • Collaborate with architects and engineering teams to design optimal data models and integration strategies. • Develop automated processes for verification, validation, and quality assurance of data pipelines. • Participate in sprint ceremonies as part of a high-performing Agile development team. • Engage with stakeholders to create mockups, validate requirements, and refine deliverables. • Support design and configuration of development tools, data infrastructure, and integration environments. • Produce and maintain technical specifications, diagrams, mappings, and documentation supporting DD&I efforts. • Analyze impacts of new or changing business requirements and propose enhancements or design modifications. • Troubleshoot technical issues, perform root-cause analysis, and implement effective solutions. • Support data pipeline performance tuning, process automation, and continuous improvement initiatives. • Perform all other duties as assigned to support the development, maintenance, and operations of the data integration environment. Required Qualifications • 8+ years of experience developing ETL mappings and workflows using Informatica Power Center or IICS. • 8+ years of experience acquiring and integrating data from multiple sources (Oracle, SQL Server, Excel, Access, Adobe PDF) into ETL workflows for analytics or visualization platforms. • 8+ years of experience designing and developing complex SQL scripts for Oracle and/or Snowflake that are optimized for performance and scalability. • 8+ years of analytical and problem-solving experience as a systems analyst supporting data analytics, performance management, or data warehousing projects. • 8+ years of experience producing technical documentation, data mappings, diagrams, and requirements using tools such as Visio, Erwin, and Microsoft Office applications. • 8+ years of experience planning, designing, and delivering software platforms used across multiple business units or product lines. • 8+ years of experience writing testable, well-structured, and efficient code using best development practices. Preferred Qualifications • 6+ years of excellent written and verbal communication experience, including presenting findings to technical and non-technical stakeholders. • 6+ years of experience managing multiple assignments concurrently, prioritizing deadlines, and adapting to rapidly changing requirements. • 4+ years of experience working on Agile sprint teams in a collaborative, fast-paced environment. • 4+ years of understanding security principles, particularly as they relate to sensitive healthcare data (PII/PHI). • 4+ years of experience with modern BI, analytics, or data visualization technologies, especially those supporting performance metric dashboards. • 4+ years of experience developing SDLC artifacts, including requirements, gap analyses, data flow diagrams, design documents, test cases, and use cases. • 4+ years of experience in the healthcare industry, ideally within government health programs. • 4+ years of experience working with PII or PHI data in secure enterprise environments. • 4+ years of hands-on experience designing and developing scripts using Python. • 4+ years of experience with Jira for Agile project management. • 2+ years of functional or hands-on experience with REST/SOAP Web Services. • 2+ years of experience developing code using Java and JavaScript. • 2+ years of experience developing CI/CD pipelines with GitHub and GitHub Actions. • 2+ years of experience as a Mulesoft developer or integrator. • 2+ years of experience developing C# code for enterprise applications. Why Join 4A • Be part of a mission-driven, women-owned consulting firm with a reputation for excellence. • Work on high-impact projects across federal and commercial clients. • Collaborate in an inclusive, growth-oriented culture where innovation is valued. • Access career development programs, mentorship, and learning opportunities. • Enjoy a comprehensive benefits package, flexible work options, and a focus on work-life balance. Equal Opportunity Statement 4A Consulting is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. Stage