Senior Data Engineer (Hybrid)

Blattner Company; Northern (KY); Hybrid; USD 101,000 - 146,000; Full time

Benefits offered by this job

Competitive pay

HDHP insurance premiums for employees

401(k) with company match

HSA and FSA options

Dental and Vision insurance

Job summary

Blattner Company is seeking a Senior Data Engineer (Hybrid) to design, implement and optimize data warehouse solutions that support BI initiatives. You will work with MS SQL, Azure Data Factory, and BI tools to drive data-driven decisions across the business.

The role requires 5–8 years in database development, strong SQL optimization, and collaboration with IT and analytics teams. Hybrid work in Avon, MN with competitive compensation and benefits is offered.

Qualifications

• Bachelor's degree in a technology area; CS/MIS/Analytics preferred.
• 5-8 years of database development experience focusing on data warehouse design and optimization.
• Proficiency in designing ETL workflows: cleansing, transforming and loading data.
• 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 using MS SQL and Azure Data Factory.
• Build custom reports and dashboards with Power BI/Tableau for business insights.
• Collaborate with IT and business partners to ensure data quality, integrity and performance.

Skills

MS SQL Development

SQL optimization

ETL/ELT design

Data warehousing

Azure Data Factory

Data modeling

Education

Bachelor's degree in CS/MIS/Analytics

Tools

Power BI

Tableau

Job description

## Senior Data Engineer (Hybrid)Applylocations: Avon, MNtime type: Full timeposted on: Posted Yesterdayjob requisition id: R8400**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.*