Senior Data Engineer (Hybrid)

Blattner Company; United States; On-site; USD 101,000 - 146,000; Full time

Benefits offered by this job

HDHP insurance

401(k) with company match

HSA and FSA options

Dental and Vision insurance

Tuition assistance

Work/Life balance

Gym on site

Job summary

Blattner Company seeks a Senior Data Engineer to design and optimize data warehouse solutions enabling business intelligence and analytics initiatives. You will architect data warehouse designs, ensure data integrity, and support analytics with performant ETL/ELT processes and dashboards.

The role demands hands-on SQL optimization, MS SQL and Azure Data Factory expertise, and collaboration with IT peers and business partners in an agile environment.

Qualifications

• Bachelor's degree in a technology area; CS/MIS/Analytics preferred.
• 5–8 years of database development with data warehouse focus.
• Proficiency in ETL workflows, data cleansing and loading strategies.
• Experience with data dictionaries, data analysis and relational databases.
• Strong SQL optimization skills and ability to interpret execution plans.

Responsibilities

• Design, implement and optimize data warehouse solutions for BI and analytics.
• Develop ETL/ELT processes to move data to staging and warehouse areas.
• Build reports and dashboards using BI tools (Power BI, Tableau).
• Provide technical SME guidance for data and analytics initiatives.
• Support production and perform data quality audits and controls.

Skills

Data warehousing

ETL/ELT design

SQL performance tuning

Power BI

Education

Bachelor's degree in Computer Science or related field

Tools

MS SQL

Azure Data Factory

Power BI

Tableau

Job description

A DAY IN THE LIFE

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. Blattner Company is a nationwide, leading service provider of renewable energy construction. Based in Avon, Minnesota, Blattner provides complete engineering, procurement and construction services for utility-scale solar, wind, energy storage and power delivery projects with proven project management skills and best in class professional services and support. Interested in working in construction craft or management? Our entities, Blattner Energy and DH Blattner, build renewable energy construction across the country. Check out career opportunities for Blattner Energy and DH Blattner.