FIS is seeking a Data Warehouse Analyst Senior in Jacksonville, FL to architect, develop, and sustain comprehensive data warehouse systems using cloud-based solutions. The role involves engineering advanced ETL processes, collaborating with various teams to align data solutions with organizational objectives, and ensuring optimal performance of cloud data warehouse operations.
Responsibilities:
- Architect, develop, and sustain comprehensive data warehouse systems and their corresponding data marts using cloud-based solutions
- Engineer and implement advanced data extraction, transformation, and loading (ETL) processes in a cloud-agnostic platform
- Conduct thorough analysis and translation of business requirements into sophisticated, long-term data models
- Oversee and ensure the optimal performance and reliability of cloud-based data warehouse operations
- Collaborate extensively with data architects, reporting teams, and various business units to ensure alignment of data solutions with organizational objectives
- Rigorously test cloud data warehouse systems and perform necessary upgrades to maintain system efficacy
- Generate detailed data reports, visualizations, and dashboards to support business decision-making
- Enhance data reliability, efficiency, and quality through continuous process improvements and robust data governance practices in the cloud
- Design and implement robust database solutions and models to meet organizational needs
- Evaluate database implementation procedures to ensure adherence to internal and external regulatory standards
- Prepare comprehensive database design and architecture reports for management and executive review
- Ensure the accuracy and integrity of data loaded into the cloud data warehouse
- Assist in the development, maintenance, troubleshooting and support of the enterprise’s cloud data warehouse system and related data marts
- Innovate and develop new or enhanced components for the data warehouse system
- Develop and enforce data security policies and procedures to ensure compliance with regulatory requirements
- Implement and maintain security measures to protect data warehouse systems from unauthorized access and breaches
- Ensure data encryption and secure data transmission methods are in place to protect sensitive information in the cloud
- Manage the distribution of data across various cloud platforms and systems to ensure efficient data flow and accessibility
- Develop and implement strategies for data distribution in the cloud to optimize performance and minimize latency
Requirements:
- Bachelor's degree or foreign equivalent in Computer Science, Computer Engineering or related field
- seven (7) years of progressively responsible experience in the job offered or a related occupation
- utilizing Databricks for data engineering, analytics, and machine learning tasks
- proficiency in setting up and managing Unity Catalog for data discovery, classification, and lineage tracking
- working with Python scripting skills with libraries including PySpark, Pandas, NumPy, and Scikit-learn for data manipulation and analysis
- leveraging BigID for compliance with regulations (GDPR, PII, PCI) and implementing data governance frameworks
- managing and supporting API platform infrastructure both on-premises and in the cloud, including installation, configuration, upgrades, troubleshooting issues, and API script development for pipeline support on Azure APIM and WSO2 platforms
- identifying, analyzing, and mitigating security vulnerabilities in data products using CheckMarx and Blackduck
- working with CI/CD tools including Jenkins for automation, Git/Bitbucket for version control, and Harness for continuous delivery
- utilizing containerization Docker/AKS/EKS technologies for creating, deploying, and managing containers
- working with Azure cloud services including Azure Storage, Azure Data Factory, Data Lake Storage, Azure Logic Apps, Azure Functions, Web Apps, Key Vaults, and Azure Containers