200+ applicants

Company

Orion Groups · 1 day ago

Senior Data Warehouse Engineer

United States

Full-time

Remote

Senior Level

$120K/yr - $130K/yr

Maximize your interview chances

IT Services and IT Consulting

Actively Hiring

Hiring Manager

Jon Jones

Insider Connection @Orion Groups

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

Collaborate with data scientists, report writers, product group customers, stakeholders and other IT resources to define business needs and build scalable data processing pipelines

Provide solution design leadership, as well as mentor junior engineers and team members

In collaboration with the data analytics & reporting team, manage and support Azure Machine Learning environment

Develop ETL using data factory, SSIS tools as well develop visual reports in Power BI

Design, construct, and manage the data lake environment including: data ingestion, staging, data quality monitoring, and business modeling

Design, develop and implement technical solutions in SQL environment (databases, SQL, data marts, integrations)

Maintain and develop queries and stored procedures using T-SQL

Support data integrations

Work in all aspects of development, design, reviews, troubleshooting and post-production issue resolution

Follow SDLC to create and maintain required documentation of newly developed and refactored applications

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 WarehousingSnowflakeSQLPythonETLPower BIT-SQLSSISDAXAzure DevOpsData IntegrationDimensional ModelingData LakeMDMData Quality MonitoringRelational Database Design

Required

Expertise in SQL and Python, solid experience and understanding on Snowflake data cloud and Azure data assets

Strong understanding of data integration, data warehousing and dimensional modeling

Highly skilled in SQL programming in T-SQL building stored procedures and jobs

Ability to manage large volume data integration/ETL; experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agent

Expertise in identifying and mapping data elements across multiple systems

Strong understanding of MDM, data warehouse/data mart, relational database design and Azure DevOps

Bachelor’s degree; emphasis in Computer Science, Computer Engineering or related field preferred

Preferred

Experience with SQL Server 2019+ is desired to support migration from on-prem SQL Server to Snowflake

Hands-on experience in writing DAX queries and custom calculations

Knowledge of Power BI report visualizations, Data Analysis Expressions (DAX), Power Query (M), and Power BI data modeling

Company

Orion Groups

Orion Groups is a professional services firm that provides experienced consultants for your organization’s technology, process improvements, managed services, staff augmentation, program, and project management.

Founded in 2019