Data Architect
Columbus, Ohio, United States - Remote
Workstate
At Workstate, we solve complex technology problems for our clients by providing leadership and expertise around strategy, development and testing.Workstate seeks a Data Architect to join our team! If your mission is to find a career that delivers collaborative teamwork, active learning and mentoring, and leaving a legacy of best-in-class results, you’ll fit right in at Workstate.
We seek professionals who can engage with and motivate our clients beyond hands-on keyboard, both diving into the work of the moment, while envisioning a project's future. Our consultants are quick on their feet, able to make fast, informed and smart decisions to save or propel client’s initiatives and champion their vision. Workstate developers persevere in their quest for excellence.
This is a remote friendly, full-time position, available to U.S. residents based in the continental U.S. who are eligible to work for any employer without need for visa sponsorship or transfer.
Responsibilities:
- Design, develop, implement, and maintain conceptual, logical, and physical data models that adhere to business objectives and data governance standards.
- Optimize data architectures to enhance operational and analytical performance and scalability.
- Provide leadership and best practices to other team members as an individual contributor, deliver working solutions including data pipelines, worksheets, snowflake environments, Snow SQL, and Python automation code.
- Ensure data integrity and quality by creating and implementing data governance and validation processes.
- Responsible for maintaining and updating data models, working closely with the business team to understand requirements and provide guidance to the development team.
- Work closely with data engineers and IT personnel to implement and refine data models within our data warehousing and business intelligence environments.
Requirements
Skills of interest include the following. The ideal candidate will have demonstrated some of these skills professionally, but not necessarily all.
- 4+ years of experience as a Data Modeler with a background in data architecture and modeling projects within SDLC/Scaled agile delivery framework
- Proficiency in data modeling tools and technologies, with a deep understanding of relational and non-relational database systems.
- Proficiency in Snowflake database profiling, creating, advising, and reviewing data models for data warehousing and data mart areas.
- Familiarity with data governance, data quality management, and data security practices.
- Knowledge of SQL, NoSQL, ETL processes, and business intelligence platforms.
- Experience with GraphDB, Oracle, and SQL coding
- Proficiency in OLTP/3NF and dimensional/data mart modeling (star schema, snowflake)
- Ability to design table structures with proper data analysis and mapping capabilities.
- Bachelor’s degree in computer science, Information Technology, Data Science, or a related field.
If you are excited about this position but your past experience doesn't align perfectly with all the listed skills, we encourage you to apply anyway. You may be just the person we are looking for in this or another role.
Benefits
- Medical, dental, and vision insurance with employer contribution
- Free life insurance policy
- Simple IRA plan with 3% employer match
- 9 paid company holidays
- 15 days PTO that increases to 20 days after year 2 of employment
- Professional development through internal programs and on-the-job training. In addition, all employees are given a yearly professional development budget that can be used towards courses, certifications, and more.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Business Intelligence Computer Science Data analysis Data governance Data pipelines Data quality Data Warehousing ETL NoSQL Oracle Pipelines Python RDBMS SDLC Security Snowflake SQL
Perks/benefits: Career development Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs