Data Solution Architect

About the role

Leverage analysis design techniques to solve business problems using information technology to operationalize data and analytical models to drive long-term business results. Partner with MDS in providing accessibility, retrievability, security and protection of data in an ethical manner.

Partner with Product Owners, BI Developers and Business Leads to conduct business requirement gathering and continuous improvement sessions to support the business and understand requirements for analytical projects. Develop necessary requirement documents and acceptance criteria to support their development in line with process guidelines.

Responsibilities

• Develop UAT (User Acceptance Testing) and SIT (System Integration Testing) test cases based on analytical data product requirements.
• Support scoping, building, testing, and maintaining transport/data pipelines and retrieving applicable data sets for specific use cases.
• Support building, testing, and maintaining data models with the flexibility to change when business requirements change, while reconciling multiple logical source models into a single, logically consistent model.
• Analyze the structure, format, and reliability of new and existing data sources, considering factors such as data integrity, completeness, accuracy, and drive continuous improvement.
• Participate in data governance processes to ensure data is properly maintained and documented for reusability by the business.
• Understand data and metadata to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation.

Requirements

• BS in Computer Science, Information Systems, or related field.
• Understanding of Data Engineering concepts within a business setting, including working with multiple systems such as SAP, internal and external data sources.
• Experience in developing, enhancing, testing, and maintaining data products.
• Experience in using a diverse range of languages and tools, including scripting languages, for data extraction, transformation, storage, processing, and integration.
• Analyze business requirements as a guide for data modeling and apply data analysis, design, modeling, and quality assurance techniques. Use a detailed understanding of business processes to establish, modify, or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions).
• Ability to simplify complex problems and effectively communicate technical concepts to a diverse audience.
• 1+ years of Data Engineering/Modeling experience.
• 3+ years of Database Design experience.

Skills

• Cloud computing technologies (Azure, GCP).
• Programming Languages: SQL, Python, PySpark (Apache Spark), DAX.
• Analytics platforms: Databricks, Google Cloud Dataproc.
• Experience with CI/CD, DevOps, and DataOps techniques.
• Experience with ETL, Data pipelines, and architecture.
• Technical Documentation.
• Data modeling and wrangling techniques and tools (e.g., Star Schema, Snowflake Schema, Data Vault, Alteryx, Power BI, Tableau).
• Data quality and profiling methods.

Benefits

• Healthcare Insurance: Eligible employees and their dependents receive healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full-time employment. Premiums are subsidized by Synectics.
• Dental Insurance: Eligible employees and their dependents receive a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full-time employment.
• Vision Insurance: Eligible employees receive vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full-time employment.
• 401(k) Plan: Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first of the month following at least 1 calendar year after employment begins.