Senior Data Warehouse Engineer

12 Elements Consulting – Senior Data Warehouse Engineer

About Us

12 Elements Consulting is a dynamic and innovative consulting company with a strong commitment to quality, innovation, and client satisfaction. We have experienced rapid growth and success over the years. With a strong focus on pushing the boundaries of what's possible, we are seeking top-tier talent that adds intrinsic value to our organization.

Role Overview

The Senior Data Warehouse (DW) Engineer will be responsible for designing, developing, and maintaining Business Intelligence solutions by creating and maintaining multiple relational databases which contain strategic information that can be used by the various Business Intelligence teams for analysis and creation of meaningful reports by transforming raw source data into a structured set of objects that drive business value.

The Senior DW Engineer must display the ability to deliver results in a timely manner. The minimum and preferred skills are listed below.

Role Responsibilities

· Design, build, and maintain physical databases, data warehouses with star and snowflake schemas using logical multi-dimensional data models, OLAP cubes, ETL layer design and data integration strategies.

· Implement data quality, data integrity, and data standardization efforts across databases enabling key business processes.

· Strong proficiency in SQL and query writing is required.

· Create, maintain, and enhance ETL/ELT pipelines using SSIS to integrate, scrub or manipulate data from various sources. Implement SSAS, SSIS, and SSRS processes to improve data gathering for reports upon development.

· Design and build T-SQL code to extract, transform and load the data into the star schema objects.

· Provide support to all data warehouse initiatives and interact closely with Business Analysis teams\BI Reporting teams to ensure understanding of proper use of data architecture.

· Collaborate with corporate stakeholders to define and implement actionable metrics, KPIs and data visualizations.

· Scrutinize the company's present data infrastructure, identify gaps, and recommend improvements to enhance existing ETL and data integration processes to enable performance and overall scalability.

· Perform troubleshooting on all ETL processes and resolve issues effectively.

· Debug and tune queries for semantic layer.

· Design, code, test, correct and document programs and scripts using agreed standards and tools to achieve a well-engineered result.

· Derive an overall strategy of data management, within an established information architecture that supports the development and secure operation of existing and new information and digital services.

· Gathers and processes raw, structured, semi-structured, and unstructured data using batch and real-time data processing frameworks.

· Ensures data quality and implements tools and frameworks for automating the identification of data quality issues.

· Collaborate with internal and external data providers on data validation providing feedback and making customized changes to data feeds and data mappings.

.

Minimum Qualifications (required)

· Excellent communication skills, organizational skills, negotiation skills, and flexibility to address competing demands.

· Strong analytical and problem-solving ability to design an effective solution.

· Extensive experience using Microsoft SQL Server, SSIS, SSAS, and SSRS (4+ years).

· Strong Excel skills preferred.

· Ability to work effectively with internal stakeholders to meet the data needs of the business, translating business needs into analytical requirements.

· Ability to manage multiple projects at a time and prioritize accordingly in a fast-paced environment.

· Pro-active work style and creative problem solver who can handle multiple projects, demonstrating a strong work ethic.

· Excellent attention to detail, quality, and follow-through; commitment to continuous improvement and the elimination of performance variability.

· Data modeling with ER/Studio, Erwin, or other data modeling tools preferred.

Pay: $120,000.00-135,000.00

Benefits

401(k) 4% Match
Dental Insurance
Disability insurance
Employee assistance program
Employee discount
Flexible spending account
Health insurance
Health savings account
Life insurance
Paid sick time
Paid time off
Vision Insurance

Schedule: Day shift

Work Location: Remote

Why 12 Elements Consulting

At 12 Elements Consulting, we take immense pride in our team's exceptional skills and their track record of delivering industry-leading results. We aim to invest in dedicated, long-term employees who exhibit a knack for rapid learning and aspire to grow alongside us. Joining our team means actively participating in the creation of cutting-edge solutions, accessing invaluable learning resources, and being part of a company that deeply appreciates its skilled workforce.

We provide a highly competitive benefits package, inclusive of a 401k plan. We are passionate about work-life balance! Expect a vibrant atmosphere and limitless avenues for personal and professional growth.

We are not seeking leads from recruiters at this time, thank you.

Pay: $120,000.00 - $135,000.00 per year

Benefits:

• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Retirement plan
• Vision insurance

Application Question(s):

• Do you have experience working with SQL Server 2016 or later versions in a production environment?
• How would you rate your T-SQL proficiency?
• Do you have hands-on experience writing complex T-SQL queries, stored procedures, views, functions, and performance tuning?
• In your current or most recent role, are you responsible for managing and supporting a Data Warehouse database environment?
• Do you have experience working with data warehouse fact and dimension tables (star schema or snowflake schema)?
• How many years of experience do you have designing, maintaining, or optimizing fact and dimension tables in a Data Warehouse environment?
• Are you comfortable troubleshooting, optimizing, and maintaining large-scale SQL Server Data Warehouse environments?

Work Location: Remote