Senior Data Engineer (ETL & BI Focus)

Job Title : Senior Data Engineer (ETL & BI Focus)

Location : Remote - USA

Type : Fulltime

Clearance Requirement : Must be able to obtain and maintain Public Trust security clearance.

Position Summary : We are seeking an experienced and analytical Data Engineer / ETL Specialist to join our technical team. This is a pivotal role responsible for designing, building, and maintaining the data architecture that supports critical agency reporting.The ideal candidate is a "builder" who is comfortable working within the AWS ecosystem to create robust ETL pipelines using Python, and who also possesses the business intelligence sensibilities to develop insightful dashboards using Power BI or Tableau. You will play a key role in transforming siloed, raw data into actionable insights for agency leadership.

Key Responsibilities :

• ETL Pipeline Development : Design, develop, and automate scalable Extract, Transform, and Load (ETL / ELT) processes to move data from various government source systems into our central data warehouse.
• AWS Infrastructure Management : Utilize AWS cloud services (such as S3, Glue, Lambda, RDS, or Redshift) to architect secure and efficient data solutions.
• Data Transformation & Coding : Write clean, maintainable Python code for complex data manipulation, cleansing, and validation to ensure high data quality standards.
• Business Intelligence Reporting : Collaborate with stakeholders to gather requirements and develop interactive, high-impact dashboards and reports using Power BI or Tableau to track key performance indicators (KPIs).
• Data Governance : Ensure all data architecture complies with federal security standards, data governance policies, and privacy regulations.

Required Qualifications :

Preferred Qualifications (Desired but not required) :