Sr. Data Engineer

Constellation Energy Generation, LLC.•Baltimore, MD

About The Position

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.

Requirements

Bachelor's degree (ex: Computer Science or related discipline) and 5 - 8 years of relevant experience (programming technologies) or minimum 9-12 years of relevant combination of education and work experience
Knowledge of ETL tools.
Experience with private and public cloud architectures, pros/cons, and migration considerations
Minimum of 5 years of RDBMS experience
Experience with JSON, Parquet, Delta, Avro data structures
Experience implementing data pipelines using latest technologies and techniques
Experience with SDLC products (Azure DevOps and GitHub) or similar agile project management tools
3-5+ years of hands-on experience in programming languages such as c#, node.js, python, Pyspark, Spark SQL
At least 3-5 years of consulting or client service delivery experience on Azure
Experience handling Structured and unstructured datasets
Strong t-SQL skills with experience in Azure SQL DW
Experience in Data Modeling and Advanced SQL techniques
Cloud migration methodologies and processes with tools like Azure Data Factory, Databricks, Fivetran, Event Hub, etc.
Excellent problem solving, analytical, and critical thinking skills.
Experience with cloud-native Azure technologies like Azure Functions, Event Grids, Service Bus Queues, Cosmos DB, or related is a plus.
Experience with designing integration applications, both upstream and downstream applications.
Experience with git, Azure DevOps, build pipelines, code branching/merging, code management.
Experience writing and executing stored procedures
Knowledge of Event driven architecture.

Nice To Haves

Experience in Medallion Architecture, Data Vault
Near real time and batch ingestion

Responsibilities

Produce high-quality, secure, and maintainable code/configurations
Learn and understand business processes with limited guidance
Work collaboratively as a member of the development team to build best-in-class software solutions in an agile environment
Support and research issues across all application layers and database
Identify areas to improve and scale our Azure architecture and application design
Ensure code can be deployed using Azure DevOps
Design and query database tables, views, functions, stored procedures and batch processes
Develop, implement, and support interfaces that connect our websites, back-end systems, and various 3rd party cloud solutions, vendors and customers.
Engage with business partners to gather information, analyze requirements and deliver practical, efficient and cost-effective solutions that satisfy business needs. Write product specifications and design documentation for assigned system components.
Design, develop and/or review complex code or configurations to ensure solutions meet the requirements of functional and technical specifications. Develop and/or review project technical architecture design and development. 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. Develop automated Unit tests and/or automated UI tests.
Lead team members and provide oversight for less experienced engineers; Stay on top of the latest technologies and trends. Support development of version control principles (e.g. Git and working within an agile environment)
Enhance knowledge of and compliance with preferred technologies, methodologies, standards and policies. Maintain technical knowledge and business acumen within own discipline or function. Strong debugging and problem-solving skills; lead peer code reviews.
Provide IT teams and business personnel with technology solutions by weighing advantages of technology trends, market availability of products, risks and benefits of technology to meet business/IT needs. Participate in IT architecture review and standards setting. Assist in the development of white papers, conducting presentations as needed to explain why a technology is being recommended by IT.