DATA SOLUTIONS ARCHITECT SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 8, 2024 – The Data Solutions Architect combines programming expertise with a background in modernizing data applications. This role requires building data solutions on AWS, utilizing databases like Teradata and Snowflake, along with experience in ETL architecture and Master Data Management (MDM). The architect also designs scalable patterns, implements CI/CD practices, and stays updated on emerging data trends to recommend effective solutions.

Essential Hard and Soft Skills for a Standout Data Solutions Architect Resume
  • Data Modeling
  • Cloud Architecture
  • ETL Processes
  • SQL Proficiency
  • Big Data Technologies
  • Data Warehousing
  • Data Integration
  • API Development
  • NoSQL Databases
  • Data Governance
  • Problem-Solving
  • Communication
  • Collaboration
  • Analytical Thinking
  • Adaptability
  • Leadership
  • Critical Thinking
  • Time Management
  • Attention to Detail
  • Stakeholder Engagement

Summary of Data Solutions Architect Knowledge and Qualifications on Resume

1. BS in Computer Science with 6 years of Experience

  • Demonstrable experience performing many of the following tasks across design, build, DevOps, accreditation and deployment.
  • Excellent customer-facing and stakeholder management skills
  • A good understanding of projects that have high security and high regulatory considerations throughout with experience on previous projects
  • Significant experience with data-heavy projects involving the following data integration, data transformation, data security, data regulation, data wrangling, and legacy data ETL
  • Experience with projects using Cloud Architecture, Data Lakes, and Data Visualisation Tools
  • Passionate and affable who takes pride in delivering excellence and delighting the customer
  • Experience working on large Government/Defence/Security projects
  • Experience working in Robot Process Automation
  • Experience working with API design
  • Ability to work under pressure and multitask in a fast-paced start-up environment

2. BS in Information Technology with 9 years of Experience

  • Working experience in a financial services firm
  • Prior development leadership experience
  • Engineering or Mathematics background
  • Experience in distributed in-memory databases delivering performant solutions for a market business
  • Experience in distributed storage in the processing of big data while delivering solutions for a market business
  • Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals.
  • Demonstrated capability to develop and maintain effective work relationships with business stakeholders and front-office technology teams
  • Proven ability to conduct research/analysis, organize findings and build plans
  • Knowledge of financial markets and Risk management
  • Experience working with virtual teams
  • Strong written and verbal communication skills

3. BS in Software Engineering with 7 years of Experience

  • Experience with building BI infrastructure, including optimization, modeling, and communication pathways
  • Experience building out a data product roadmap
  • Demonstrated work ethic and capability to be a self-starter
  • Experience working with all levels of internal stakeholders in understanding their business needs and crafting technical solutions using both off-the-shelf products as well as custom solutions.
  • Technical experience, especially with web and data technologies.
  • Outstanding communication skills, particularly in conveying technical concepts in a manner that is easy for clients and non-technical partners to understand
  • Excellent quantitative skills and comfort with data exploration tools such as Excel, numpy, R, Spark/Scala, etc
  • Demonstrated experience in owning projects end to end that involves coordinating many resources and teams
  • Excellent organizational skills and attention to detail
  • Excellent troubleshooting, analytical and problem-solving abilities with a tenacious commitment to finding the root cause of issues
  • Ability to energize and lead a team of partner engineers

4. BS in Data Science with 11 years of Experience

  • Demonstrate experience in turning business use cases and requirements into technical solutions.
  • Experience in business processing mapping of data and analytics solutions.
  • Ability to conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows.
  • The ability to apply such methods to solve business problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration.
  • Mastery of .NET C# and T-SQL with the familiarity of U-SQL
  • Knowledge of Azure Data Factory, Azure Data Lake, Azure SQL DW, and Azure SQL, Azure App Service
  • Azure IoT, Azure HDInsight + Spark, Azure Cosmos DB, Azure Databricks, and Azure Stream Analytics
  • Knowledge of Python
  • Experience preparing data for Data Science and Machine Learning.
  • Experience preparing data for use in Azure Machine Learning and/or Azure Databricks is a plus.
  • Demonstrate experience preparing data and building data pipelines for AI Use Cases (text, voice, image, etc.…).

5. BS in Mathematics with 8 years of Experience

  • Professional experience architecting solutions in AWS with a majority of the following - AWS, Atlassian Suite products including Jira/BitBucket/Confluence, Python or Lambda, Linux bash shell
  • Professional experience in ETL tools such as Talend or Informatica
  • Professional experience in provisioning big data solutions using AWS Analytics services and frameworks (e.g., EMR, Spark, Hortonworks, Cloudera, etc.)
  • Proficiency with AWS including Amazon Redshift, EC2, EMR, Spark, S3, Kinesis and RDS Databases
  • Experience in Agile software development, and infrastructure management
  • Ability to make the appropriate recommendations based on the AWS Well-Architected framework and best practices for multiple AWS service categories
  • Understanding of other cloud service provider offerings including Azure & Google Cloud
  • Experience working with AWS Athena and Glue
  • Excellent written, verbal, and meeting facilitation skills
  • Have AWS Solutions Architect – Associate Certification

6. BS in Information Systems with 12 years of Experience

  • Experience supervising or leading technical projects and teams
  • Previous experience as a Chief Engineer or equivalent for COTS and open source solutions with broad expertise guiding projects and operations across multiple related IT disciplines throughout the project lifecycle
  • Experience in software engineering and design, including working cooperatively with Data Scientists
  • Possess broad IT knowledge of contemporary IT technologies to include end user computing, n-tier architectures, database and data warehouse technologies, network, cybersecurity architecture components and controls, virtualization technologies, DevOps, and web services
  • Understanding of data cataloging/data quality/data security
  • Prior hands-on experience with relational data/SQL/data modeling and scripting tools
  • Ability to communicate with executive leadership regarding matters of significant importance to the organization.
  • Experience and ability to successfully negotiate and influence others to understand and accept new concepts, practices and approaches.
  • Experience estimating all technical and operations labor and material costs
  • Experience identifying and assessing business impacts to proposed changes to a largely technical solution or enterprise operations
  • Excellent written and oral communication capability

7. BS in Statistics with 7 years of Experience

  • Experience developing strategic roadmaps for IT services and providing technical oversight to ensure developed solutions, satisfy customer and business requirements
  • Recent experience migrating and sustaining applications from on-premise solutions to CSPs
  • Experience working with Git/TFS/VSTS
  • Familiarity with the processes, tools, and techniques to develop AI/ML solutions
  • Experience designing and building Data Pipelines using streams of IOT data.
  • Knowledge of Lambda and Kappa architecture patterns.
  • Knowledge of Master Data Management (MDM) and Data Quality tools and processes
  • Strong team collaboration and experience working with remote teams.
  • Working experience with Visual Studio, PowerShell Scripting, and ARM templates.
  • ITIL foundations certification with Enterprise IT experience using ITIL 4
  • Technical Certifications such as AWS/MS or Security Certifications such as CISSP

8. BS in Computer Engineering with 9 years of Experience

  • Hands-on programming experience, architecting and modernizing to next-generation data applications
  • Hands-on programming experience, architecting next-generation data applications
  • Relevant hands-on data architecture experience
  • Relevant hands-on exposure to building data and analytics solutions on AWS
  • ETL architecture experience (Ab Initio or cloud-native tools)
  • Experience with a variety of databases e.g. Teradata, Oracle, Maria DB, Snowflake
  • Expertise in building Master Data Management (MDM) solutions
  • Experience building architectural patterns at scale, including thoughtfully designed data solutions, repeatable data pipelines, and efficient software engineering principles
  • Sound understanding of CI/CD, infrastructure engineering and building future-ready technology solutions
  • Experience with building data warehouses, marts, business intelligence reports and operational systems
  • Knowledge of emerging trends in the data space and ability to recommend solutions
Relevant Information
Big Data Architect Skills, Experience, and Job Requirements
Cloud Data Architect Skills, Experience, and Job Requirements
Data Architect Skills, Experience, and Job Requirements