Sr. Data Engineer

Who We Are

As the largest private-sector power producer in the world and the nation's largest producer of clean and reliable energy, Constellation is focused on our purpose: lighting the way to a brilliant tomorrow for all. We have been the leader in clean energy production for more than a decade, and we are cultivating a workplace where our employees can grow, thrive, and contribute. Now integrated with Calpine, our portfolio includes 55 gigawatts of capacity from nuclear, natural gas, geothermal, hydro, wind and solar facilities, with the generating capacity to power the equivalent of 27 million homes.

Our culture and employee experience make it clear: We are powered by passion and purpose. Together, we're creating healthier communities and a cleaner planet, and our people are the driving force behind our success. At Constellation, you can build a fulfilling career with opportunities to learn, grow and make an impact. By doing our best work and meeting new challenges, we can accomplish great things. Join us in meeting the country's energy needs today and tomorrow.

Total Rewards

Constellation offers an extensive selection of benefits and rewards to help our employees thrive professionally and personally. We provide competitive compensation and a wide-range of benefits that support both employees and their families, helping them prepare for the future. In addition to highly competitive salaries, eligible employees are offered a bonus program, 401(k) with company match, employee stock purchase program; comprehensive medical, dental and vision benefits, including robust wellbeing programs; disability and life insurance benefits; paid time off for vacation, holidays, and sick days; and much more.

Expected salary range of $132,300 to $147,000, varies based on experience, along with comprehensive benefits package that includes bonus and 401(k).

Primary Purpose of Position

Lead the design, build, test, implementation, and ongoing maintenance of technology solutions, products, and processes that support business and IT needs. This role evaluates technology standards, market-available products, and associated risks and benefits to deliver effective, scalable solutions. The position operates independently with minimal guidance and coordinates the work of less experienced engineers while collaborating across teams to meet project objectives. The role is centered on developing and enhancing new and existing features and spans architecture, design, implementation, and testing to ensure high-quality product delivery. Responsibilities include close collaboration with scrum masters, project managers, QA, Creative, and UX partners to ensure alignment with project requirements. The role also includes reviewing peer code, promoting standard development methodologies, advancing core team processes to improve efficiency and quality, and coaching engineers assigned to the product or project team. The individual is expected to maintain deep technical knowledge, contribute to innovation, share expertise across the organization, and perform complex, high-impact work with broad latitude for independent judgment.

Primary Duties and Accountabilities

• Build and support data warehouses, data lakes, and high-performance database objects including SQL scripts, stored procedures, and views.

• Implement automated data ingestion, transformation, validation, reconciliation, and monitoring processes to ensure reliable and accurate data delivery.

• Partner with business stakeholders and BI teams to translate requirements into technical solutions that support reporting and analytics.

• Analyze existing operational standards, processes, and/or governance to identify and implement improvements

• Conduct technical discovery sessions with vendors and customers.

• Configure logging, reporting, and alerts for cloud services, applications and databases.

• Create documentation to install, replace, and upgrade network cloud components.

• Create requirements document, SOW, logical & physical network diagrams, and implementation plans to integrate in customers' environments.

• Design and recommend solutions to mitigate risks discovered through business impact analysis, site risk assessments and disaster recovery planning.

• Design, develop and/or review IaC code or configurations to ensure solutions meet the requirements of functional and technical specifications.

• Design, develop, and implement highly available, multi-region solutions within Microsoft Azure

• Develop and/or review project technical architecture design and development.

• Develop infrastructure as code (IaC) leveraging cloud native tooling to ensure automated and consistent platform deployments

• Engage with business partners to gather information, analyze requirements and deliver practical, efficient and cost-effective solutions that satisfy business needs.

• Lead assigned network integration projects and deployments and ensure solutions are delivered to meet business requirements.

• Lead team members and provide oversight for less experienced engineers; Stay on top of the latest technologies and trends.

• Lead the network assessment, design, connectivity, and process for connecting to the various cloud vendors.

• Maintain and deploy infrastructure and services through templates and code. Document network configurations, layouts, business changes.

• Maintain relevancy and knowledge in current cloud, evolving, emerging networking technologies.

• Maintain technical knowledge and business acumen within own discipline or function and manage ongoing professional development.

• Manage security and access controls of cloud-based solutions

• Overall responsibility for the evaluation of vendor quality programs and maintenance of Approved Vendors List in support Clearsight's Quality program.

• Participate on capital projects and champion key operational decisions.

• Perform custom network integration with cloud platform specific to the needs of the enterprise.

• Participate in potential refactoring, rebuild, or redesign required during Cloud migration.

• Provide Cloud product & service evaluation, testing, lab and mockup solutions as needed.

• Provide consulting, guidance and recommendations to senior leadership.

• Provide input into presentations and/or Engineering and Architecture Review Boards.

• Provide SME-level network analysis, design, consultation with leadership, project teams and end users to identify network runtime requirements and perform feasibility analysis on potential changes related to security and network architecture.

• Responsible for annual relationship meetings with firms.

• Serve as subject matter expert while leading in the Hybrid Cloud enterprise journey encompassing ongoing architecture, design, planning, configuration, implementation, testing, and documentation of the enterprise network.

• Solutions may include but are not limited to the development of various types of applications, web, mobile app, full stack or integrations hosted on premises data centers or in the cloud.

• Support and research cloud issues

• Support development of version control principles (e.g. Git and working within an agile environment)

• Understand technologies and service offerings.

• Work closely with leadership to develop future plans, resource requirements, migrations strategies, and project schedules.

Minimum Qualifications

• Bachelor's degree in Information Systems with 5-years experience, in lieu of degree 9-years experience

• Technical knowledge and experience in relational database architecture, and/or HRMS systems including SQL, Oracle BI, Business Objects, Hyperion, etc.

• A thorough grasp of agile and lean delivery concepts and methodologies, and a history of successfully applying this knowledge to manage teams

• Understanding of network fundamentals: Firewalls, VPN tunnels; DNS; Load balancers; Subnets; VLANs; etc

• Experience in IaC development with ARM templates, Bicep, Terraform, Azure CLI or similar

• Ability to train and mentor teammates and cross functional partners

• Experience with leveraging AppInsights to drive Alerting, Monitoring, and Reporting

• Demonstrated proficiency in use of network routing, switching and security protocols

• Competence in a wide range of IT skills including networking, systems administration, data protection, information security and CI/CD tooling

• Cloud and services experience, with Azure cloud experience highly desirable.

• Experience scripting with PowerShell

• Proficient with GIT (or similar) to perform source code management

• Ability to work in an operating environment that requires 24x7 rotating shift work, on-call, weekends, overtime, including holidays

• Ability to travel domestically to include overnight

• Demonstrated consulting, presentation, and project management skills, with the ability to champion and influence decisions.

• 3-years experience with IaaS and PaaS solutions

• 3-years Microsoft Azure experience involving design, deployment, configuration and optimization

• 3-years professional experience as a data analyst, data engineer, or analytics engineer

Preferred Qualifications:

• Master's degree in computer science or a related field and 5 years of relevant experience

• Design and maintain scalable ETL/ELT pipelines and optimize data integration solutions, automating data ingestion, and deployment processes.

• Build and support data warehouses and data lakes, developing optimized SQL and database objects to enable efficient data storage and access.

• Implement data engineering best practices and create technical documentation that translates business requirements into technical solutions.

• Support Agile development, sprint planning, and production operations.Perform data quality analysis, reconciliation, and issue resolution, and ensure data reliability, availability, and accuracy.

Constellation is proud to be an equal opportunity employer and employees or applicants will receive consideration for employment without regard to: age, color, disability, gender, national origin, race, religion, sexual orientation, gender identity, protected veteran status, or any other classification protected by federal, state, or local law.