• Provide support for the Army's Headquarters Installation Information System (HQIIS) by extracting, modeling, and validating data with SQL, Python, and Power BI to deliver decision-ready reporting. • Identify process gaps and plan, build, and deploy low-code solutions on Microsoft Power Platform, including Power Apps, Power Automate, and Dataverse, to reduce manual work and improve data quality. • Responsibilities include designing secure datasets and DAX models, developing ETL routines, integrating on-prem and cloud sources through the data gateway, and implementing row-level security and incremental refresh. • Document business rules, produce clear user guides, brief findings and recommendations to installations, and train users to adopt BI and Power Platform solutions. • Build Power BI datasets, models, and dashboards using DAX and Power Query to drive decisions. • Write advanced SQL and Python for ETL, data validation, API ingestion, and automation. • Design, plan, and deliver low-code apps on Microsoft Power Platform: Power Apps (canvas and model-driven), Power Automate flows, and Dataverse schemas and roles. • Configure row-level security (RLS), incremental refresh, and performance tuning in Power BI. • Integrate on-prem and cloud sources via the on-premises data gateway and standard or custom connectors. • Collect, organize, and maintain governed datasets and documentation following best practices. • Assemble large, complex data sets aligned to business rules with built-in QA/QC checks. • Identify and prioritize process improvement opportunities; automate recurring tasks to reduce manual work. • Create ad hoc reports and self-service analytics from SQL Server, SharePoint, Excel, and other sources. • Establish environment and DLP guardrails; monitor usage, access, and data movement. • Create concise user guides and job aids; train users on Power BI and Power Platform solutions. • Organize and brief findings and recommendations to government and installation stakeholders. • Support data quality remediation by codifying business rules in SQL, DAX, and Python.