200+ applicants

Company

Velosio · 1 day ago

Data Architect

United States

Full-time

Remote

Mid Level

4+ years exp

Maximize your interview chances

ComputerSoftware

Growth Opportunities

H1B Sponsor Likely

Hiring Manager

Jeremy Hunt

Insider Connection @Velosio

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ArchitectureETL/ELT ProcessesData GovernanceSQL/Azure ToolsData ModelingMicrosoft Power BIT-SQLAzure DatabricksData LakesCommunication SkillsProblem SolvingAgile Methodologies

Required

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

Experience with creating data pipelines and flows to and between business applications and data repositories

Technical and business understanding and conversancy on approaches to industry leading deployments of Data Lakes, Data Warehouses, Data Marts

Approaches and expertise to high transaction volume deployments

Excellent written and verbal skills

Comfort presenting and defending assessments, designs, approaches, and technology choices

Self-directed and comfortable supporting the data needs of multiple customer types, teams, systems, and products

Preferred

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

Conversancy and expertise in Azure Synapse Analytics

Conversancy and expertise in Azure Data Lake

Conversancy and expertise in Azure Data Factory

Conversancy and expertise in Azure Databricks

Conversancy and expertise in Azure SQL Database / Azure SQL Managed Instance

Conversancy and expertise in Logic Apps / SSIS

Conversancy and expertise in Power Automate / Power Query / DAX

Conversancy and expertise in Dataverse (Common Data Services)

Conversancy and expertise in Web Services / REST APIs / JSON

Conversancy and expertise in Microsoft Customer Insights

Conversancy and expertise in AWS cloud services: EC2, EMR, RDS, Redshift

Conversancy and expertise in Hadoop, Spark, Kafka, etc.

Experience sourcing passive candidates across a variety of departments and various platforms

Benefits

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

Company

Velosio

Velosio formed by combining SBS Group and Socius.

Founded in 1984

Columbus, Ohio, USA

501-1,000 employees

http://velosio.com/

H1B Sponsorship

Velosio has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2022 (2)

2021 (1)

2020 (1)