Sql data analyst h1.location_city

Job Description: Job Requisition: AL - DOW- Data Quality Analyst/Data Steward Contract Length: 12+ months contract – Potential renewal each fiscal year Interview Types: Video or in-person based on location Work Location: 100% onsite – Montgomery, AL - This is scheduled to be a long-term contract. No remote work will be allowed during the duration of the contract. Short Description: Experienced data professional skilled in building and scaling data quality and governance foundations from scratch in low structure environments collaborating across business and IT to deliver AI ready data ecosystems. Role Purpose Establish, advance, and mature data quality and governance capabilities in a green field, low maturity data environment. Support enterprise analytics, BI, and AI/ML readiness through SQL/ETL engineering, data profiling, validation, stewardship, metadata management, and early stage data architecture. Drive long term improvement of data standards, definitions, lineage, and quality processes. Data Quality & Engineering Perform data audits, profiling, validation, anomaly detection, and quality gap identification. Develop automated data quality rules and validation logic using T SQL, SQL Server, stored procedures, and indexing strategies. Build and maintain SSIS packages for validation, cleansing, transformation, and error detection workflows. Troubleshoot ETL/ELT pipelines, data migrations, integration failures, and data load issues. Conduct root cause analysis and implement preventive and long term remediation solutions. Optimize SQL queries, tune stored procedures, and improve data processing performance. Document audit findings, validation processes, data flows, standards, and quality reports. Build dashboards and reports for data quality KPIs using Power BI/Tableau Data Stewardship & Governance Define, maintain, and enforce data quality standards, business rules, data definitions, and governance policies. Monitor datasets for completeness, accuracy, timeliness, consistency, and compliance. Ensure proper and consistent data usage across departments and systems. Maintain business glossaries, data dictionaries, metadata repositories, and lineage documentation. Partner with IT, data engineering, and business teams to support governance initiatives and compliance requirements. Provide training on data entry, data handling, stewardship practices, and data literacy. Collaborate with cross functional teams to identify recurring data issues and recommend preventive solutions. Green Field / Low Maturity Environment Architect initial data quality frameworks, validation layers, governance artifacts, and ingestion patterns. Establish scalable data preparation workflows supporting analytics, BI, and AI/ML readiness. Mature data quality and governance processes from ad hoc to standardized, automated, and measurable. Drive adoption of data quality and governance practices across business and technical teams. Support long term evolution of enterprise data strategy and governance maturity. Required Technical Skills Advanced T SQL, SQL Server development, debugging, and performance tuning. SSIS development, deployment, and troubleshooting. Data profiling, validation rule design, quality scoring, and measurement techniques. ETL/ELT pipeline design, debugging, and optimization. Data modeling (conceptual, logical, physical). Metadata management and lineage documentation. Reporting and dashboarding with Power BI, Tableau, or similar tools. Strong documentation and communication skills. Preferred Skills Knowledge of DAMA DMBoK, DCAM, MDM concepts, and governance frameworks. Experience in low maturity/green field data environments. Familiarity with AI/ML data readiness and feature store aligned data structuring. Cloud data engineering exposure (Azure, Databricks, GCP).