- Company Name
- Hays
- Job Title
- Enterprise Security Data Solution Designer
- Job Description
-
**Job Title:** Enterprise Security Data Solution Designer
**Role Summary:**
Design, develop, and manage secure, real‑time data pipelines and analytics solutions for an enterprise security organization, ensuring accurate, compliant data flow from source systems to cloud platforms (AWS, Microsoft Fabric) and delivering actionable insights through PowerBI dashboards and automated reporting.
**Expectations:**
- Deliver reliable, high‑throughput ETL and real‑time data pipelines that meet regulatory and business requirements.
- Maintain data integrity, security, and governance across all layers.
- Provide timely, automated compliance and performance reporting to leadership.
- Drive continuous improvement using industry best practices and emerging technologies.
**Key Responsibilities:**
- Architect and implement end‑to‑end data ingestion (extract, transform, load) for AWS Data Lake and Microsoft Fabric.
- Design data models, define data standards, and document data flows aligned with compliance needs.
- Build and maintain automated data quality validation, cleansing, and monitoring systems.
- Enforce data security and privacy controls at report and data layers.
- Create PowerBI dashboards and Fabric reports for real‑time compliance and performance insights.
- Monitor pipeline health (latency, error rates, throughput) and resolve issues proactively.
- Collaborate with business, security, and compliance stakeholders to understand data requirements and translate them into technical solutions.
- Lead the development of automated real‑time compliance monitoring and reporting.
- Evaluate and introduce new tools and techniques to optimize data processing and analytics.
**Required Skills:**
- PowerBI, Microsoft Fabric, AWS (S3, Glue, Lake Formation, Athena, Redshift).
- 5–10 years experience with ETL tools, data warehousing, metadata, and quality management.
- Strong relational database design and SQL proficiency.
- Modern data engineering tools (Kafka, Spark, Snowflake, Databricks).
- Knowledge of KPIs, data governance, and regulatory compliance frameworks.
- Programming fundamentals, data structures, algorithms, and design patterns.
- Excellent analytical, problem‑solving, and communication skills.
- Ability to build collaborative relationships across technical and business teams.
**Required Education & Certifications:**
- Bachelor’s or Master’s degree in Computer Science, Computer Engineering, Software Engineering, or related technical field.
- Certifications in AWS (e.g., AWS Certified Data Analytics – Specialty) or Microsoft Power Platform/Power BI (optional but preferred).