Match score not available

Data Architect

Remote: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

BS or MS degree in Computer Science or a related technical field, 4+ years of experience in data focus, SQL/Azure tools, schema design and modeling, and integration/analytics.

Key responsabilities:

  • Design and maintain ETL processes, collaborate with teams for data governance, develop scalable data pipelines, implement data governance processes
  • Converse all technologies related to data warehousing, lay out company data assets, develop Spark-based code, write batch and streaming jobs, design data platform architecture
Velosio logo
Velosio https://www.velosio.com
501 - 1000 Employees
See more Velosio offers

Job description

About The Position

Velosio is looking for a Data Architect to be an integral member of the DPS Team.

The Data Architect will be responsible for providing guidance and deployment to customers in the structure, integration, monitoring, storage, and governance of data. You will have experience with creating data pipelines and flows to and between business applications and data repositories. You will have a technical and business understanding and conversancy on approaches to industry leading deployments of Data Lakes, Data Warehouses, Data Marts, and the progression of data from raw/bronze to curated/gold environments. Approaches and expertise to high transaction volume deployments a requirement. It is beneficial to have an understanding of Data Modeling and tabular object model or semantic layer development as well as Microsoft Power BI capability. You will also support the deployment of our Microsoft-based business applications and migrations / integrations with other additional business apps in the enterprise market space as well as our SMB customers of size. You will provide guidance around the development of unique repeatable offerings as they relate to both horizontal and industry vertical customers. The candidate must be self-directed and comfortable supporting the data needs of multiple customer types, teams, systems, and products. Excellent written and verbal skills are a requirement with total comfort presenting and defending assessments, designs, approaches, and technology choices. Being naturally curious and technology-focused is a key to success.

Your Day Might Look Like

  • Design, develop, and maintain ETL/ELT processes to load data and support enterprise reporting capabilities
  • Collaborating with analytics and business teams to assess and improve data governance and flow that feed operational, financial, and business intelligence tools
  • Developing and maintaining scalable data pipelines and building out / deploying new API’s integrations to support continuing increases in data volume and complexity
  • Use of strong T-SQL skills including Data Definition Language (DDL), Data Manipulation Language (DML), views, functions, stored procedures, or performance tuning
  • Implementing Data Governance processes and systems to monitoring data quality, master data management, enhanced security, and redundancy by ensuring production data is always accurate and available for key stakeholders and business processes that depend on it
  • Deployed and conversant in all technologies related to data warehousing, operational data stores, data lakes, etc.
  • Working closely with a team of front-end and back-end engineers, product managers, and analysts
  • Defines company data assets using data models, data catalogs, and data dictionaries
  • Develop Spark-based code in either Azure Databricks or Synapse Notebooks using Spark SQL, PySpark, Scala and/or HiveQL to populate data models
  • Write both batch and streaming jobs as necessary, with the understanding of when to use each type
  • Designing and evaluating open source and vendor tools for data lineage
  • Working closely with all business units and engineering teams to develop strategies for long-term data platform architecture

What You'll Bring

  • BS or MS degree in Computer Science or a related technical field
  • 4+ years of increased focus on data
  • 4+ years of SQL/Azure tools experience
  • 4+ years of experience with data schema design and modeling
  • 4+ years of integration/analytics experience
  • Experience in structuring solutions for high-scale data environments that support high transaction volume and IoT solutions
  • Knowledge of Data Governance principles
  • Complete comfort, understanding, and conversancy in articulating the ROI on corporate data initiatives

You May Also Have

  • Microsoft technical certifications relative to Azure and Data and Analytics.
  • Experience with or knowledge of Agile Software Development methodologies.
  • Excellent problem solving and troubleshooting skills.
  • Process-oriented with great documentation skills.
  • Excellent oral and written communication skills with a keen sense of customer service.
  • Conversancy and expertise in:
  • Microsoft Purview
  • Azure Synapse Analytics
  • Azure Data Lake
  • Azure Data Factory
  • Azure Databricks
  • Azure SQL Database / Azure SQL Managed Instance
  • Logic Apps / SSIS
  • Power Automate / Power Query / DAX
  • Dataverse (Common Data Services)
  • Web Services / REST APIs / JSON
  • Microsoft Customer Insights
  • AWS cloud services: EC2, EMR, RDS, Redshift
  • Hadoop, Spark, Kafka, etc.
  • Experience sourcing passive candidates across a variety of departments and various platforms.

Who We Are

At Velosio, we focus on what matters most - our people. We are a values-driven organization committed to delivering an outstanding employee experience to all our team members.

Velosio’s years of experience with business applications translate to a deep bench of tenured team members with competency across enterprise resource management (ERP), customer relationship management (CRM), and cloud services.

We have earned recognition from Microsoft as a top 1% performing partner worldwide and an emerging NetSuite leader. We have strategic independent software vendor (ISV) partnerships and a portfolio of solution and service offerings to accelerate what’s next for business.

Our mission is to enable clients to realize business value faster, simplify the process of deploying technology, acquire deeper data-driven insights, and explore ongoing innovation to drive business forward. We support the entire Microsoft Dynamics portfolio, Office 365 family and Azure services. Velosio is the only Microsoft Cloud Distributor that specializes in Dynamics 365 and is a prominent Microsoft Master VAR. Headquartered in Columbus, Ohio, Velosio’s 400 employees serve over 4,000 clients.

Beyond our expertise, as a Velosio team member, you can leverage the Velosio award winning culture - a network of top-notch peers, day-to-day flexibility, career development resources and the largest incentive opportunities in the industry.

Some Reasons You Might Like Working With Us

At Velosio, YOU MATTER.

Due to our proven commitment to delivering an exemplary employee experience, Velosio was awarded Best Company Culture and Best Company for Women by Comparably in 2023, 2022 and 2021, in addition to Best Company for Career Growth, Best Perks & Benefits, and Best Leadership Team by Comparably in 2022 and 2023!

About

Access the following link to see why 100% of current Velosio team members feel their company is invested in their career growth, 99% of current Velosio employees feel their manager cares about them as a person, and 99% of current Velosio team members look forward to interacting with their coworkers every day:

https://www.comparably.com/companies/velosio

At Velosio, YOUR WELLNESS MATTERS.

Benefits

We know one size doesn't fit all, which is why we offer a comprehensive benefits package that allows our team members to create a personalized plan best suited for their unique needs, including:

  • 3 Medical Insurance options with a company contribution to HSA
  • 3 Dental Insurance options including adult orthodontics
  • 3 Vision Insurance options
  • PTO with added time with each year of service
  • Remote working environment
  • 401k Match 50% of the first 6%
  • StayWell Program - a cash reimbursement up to $600 a year toward Wellness
  • Quarterly Incentive Program

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Teamwork
  • Communication
  • Problem Solving

Data Architect Related jobs