Senior Data Engineer (Hybrid)

Blattner; Avon (MN); On-site; USD 101,000 - 146,000; Full time

Benefits offered by this job

HDHP insurance

401(k) match

HSA

Dental & Vision

Education Assistance

Work/Life Balance

On-site Gym

Job summary

Blattner in Avon, MN seeks a Senior Data Engineer specializing in Data Warehouse and Analytics to design, implement, and optimize database solutions supporting BI and analytics initiatives. You will architect data warehouse solutions, ensure data integrity, optimize performance, and support analytics teams in extracting meaningful insights from data.

This role serves as SME for data and analytics, collaborates with IT and business partners, builds ETL/ELT pipelines with MS SQL and Azure Data

Qualifications

• Bachelor's degree in a technology area; MIS/Analytics preferred.
• 5–8 years of database development focusing on data warehouse design and optimization.
• Experience in ETL/ELT, data cleansing, data loading, data dictionaries, and SQL optimization.

Responsibilities

• Designs, develops and optimizes ETL/ELT solutions using data warehouse design best practices for MS SQL and Azure Data Factory ETL/ELT solutions.
• Analyzes data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming, and loading the data into the data staging, warehouse, and other system integration projects.
• Analyzes business requirements and outlines solutions.
• Provides technical assistance in identifying, evaluating, and developing systems and procedures.
• Builds custom reports and business dashboards utilizing BI tools like Power BI, Tableau, and other industry leading tools.

Skills

Data warehouse design

ETL/ELT development

SQL performance tuning

Communication

Education

Bachelor's degree in Computer Science/MIS/Analytics

Tools

Power BI

Tableau

MS SQL

Job description

A DAY IN THE LIFE As a Senior Data Engineer specializing in Data Warehouse and Analytics, you will play a critical role in designing, implementing, and optimizing database solutions to support business intelligence and analytics initiatives. You will be responsible for architecting data warehouse solutions, ensuring data integrity, performance optimization, and supporting the analytics team in extracting meaningful insights from the data. This position will serve as the technical SME for data and analytics and enabling processes, design and solutions that drive efficiency, reduce the cost of operations, and mitigate operational risk. Additional responsibilities would include development of reports, data loads, data audits, compliance, production support. This role is technical in nature and requires product knowledge as well as hands-on implementation and post-production support experience. This role will work closely with other peer IT team members and Business partners to design and configure solutions to meet Business needs. Working in an agile methodology, provides both development and quality assurance on multiple platforms, applications and middleware integrations such as SQL, Azure, Power BI and custom applications. This position is part of a team working with application subject matter experts to maintain and design system solutions to create successful software adoption and retention of our end users.

STEP INTO THE ROLE

• Designs, develops and optimizes ETL/ELT solutions using data warehouse design best practices for MS SQL and Azure Data Factory ETL/ELT solutions.
• Analyzes data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming, and loading the data into the data staging, warehouse, and other system integration projects.
• Analyzes business requirements and outline solutions.
• Provides technical assistance in identifying, evaluating, and developing systems and procedures.
• Builds custom reports and business dashboards utilizing BI tools like Power BI, Tableau, and other industry leading tools.

What You’ll Need

• Bachelor's Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.
• Previous experience as a database developer with 5-8 years of database development, with a focus on designing, implementing, and optimizing data warehouse solutions. Proficiency in designing ETL workflows, including data cleansing, transformation, and data loading strategies. Extensive experience with data dictionaries, data analysis, and relational databases. Proven understanding of SQL optimization (indexing and ability to interpret and act on execution plans).

What Sets You Apart

• Excellent communication (oral and written), organization and interpersonal skills.
• Self-motivated, ability to work within Corporate IT guidelines, passionate about quality of work, and ability to thrive in a team environment.
• Expert knowledge in MS SQL Development (SQL queries, Stored Procedures, Functions, etc.).

How We Invest In You

• Competitive pay
• 100% employer paid HDHP insurance premiums for employees
• 401(k) with company match
• HSA and FSA options
• Dental and Vision insurance
• Education Assistance (Tuition Reimbursement)
• Work/Life balance
• Employee/Family focused culture
• Gym on site
• And more!

$100,561.00 - $145,814.00 Individual Compensation to be determined based on the applicant's applicable experience and qualifications balanced against internal equity.

WHO ARE WE?

With more than 115 years of construction experience, Blattner has played a vital role in building America’s critical infrastructure, ranging from railroads and highways to dams and mines. Since 1997, the company has focused on renewable energy solutions and is responsible for some of the most significant solar, wind and storage projects in the U.S. Today, Blattner has installed over 20% of America’s utility-scale wind, solar and energy storage capacity. Blattner Company is the parent company of Blattner Energy and D.H. Blattner & Sons, of which all are members of the Quanta Services family of companies. Company headquarters are in Avon, Minnesota.

Blattner is an Equal Employment Opportunity Employer committed to diversity and inclusion in the workplace. Blattner will not tolerate discrimination against any applicant for employment or employee on the basis of age (40 and over), ancestry, color, religious creed, gender, gender expression, gender identity, genetic information, marital status, medical condition, mental disability, military or veteran status, national origin, physical disability, race, receipt of public assistance, sex, sexual orientation, or any other status protected by federal, state, or local laws. This commitment governs all aspects of employment including, but not limited to: hiring, promotion, demotion, transfer, layoff, termination, compensation, discipline, and access to benefits and training. Additionally, Blattner is committed, in accordance with applicable law, to making reasonable accommodations for job applicants and employees based on a qualifying disability, a sincerely held religious belief or practice, and for pregnancy, childbirth or related health conditions. Applicants and employees who feel they have experienced or witnessed discrimination or who wishes to request a reasonable accommodation should contact the Human Resources Department. Blattner prohibits retaliation against any individual for making a complaint under this policy, for opposing discrimination, for participating in an investigation pursuant to this policy, or for requesting a reasonable accommodation.