Azure Data Engineer (Remote)

Job Description

Description

At Constellation, a freshly independent and soon-to-be Fortune 200 company, we're providing the energy and services to transform our future. Combining next generation technologies and product offerings with the country's lowest carbon generating fleet, our company is purpose-built to meet the challenges of the climate crisis.

Constellation has been the leader in clean energy production for more than a decade. Now we're speeding delivery of low-carbon or no-carbon power to help families, communities, governments, and businesses meet their sustainability and decarbonization goals. Constellation provides 10 percent of total clean power and 22 percent of clean baseload power in the United States and is the leading competitive retail supplier of energy products, services and clean energy solutions. The race is on to confront climate change, and no company is more ready to meet that challenge.

We are committed to advancing diversity, equity and inclusion and believe in attracting, retaining and advancing employees who will best serve and represent our customers, partners and communities. We provide a workplace that ensures mutual respect, where each individual has the opportunity to grow and contribute at their greatest potential. Constellation will provide you the tools and resources you need to design, build and power a successful career.

Constellation offers a wide range of benefits, designed to help our employees thrive professionally and personally. In addition to highly competitive salaries, we offer a bonus program, 401(k) with company match, employee stock purchase program; comprehensive medical, dental and vision benefits, including a robust wellness program; paid time off for vacation, holidays and sick days; and much more.

Expected salary range of $114,300 - $127,000 per year, varies based on experience, along with comprehensive benefits package that includes bonus and 401k.

PRIMARY PURPOSE OF POSITION

Lead activities relating to designing, building, testing, implementing and maintaining solutions, products and processes around data moves and manipulations. Provide IT teams and business personnel with technology solutions by evaluating technology standards, market availability of products, risks and benefits of technology to deliver solutions that meet business/IT needs. Coordinate the tasks of less experienced engineers and collaborate across teams as needed. Independence level: Works independently with minimal guidance. Works closely with scrum masters, project managers, QA, Creative, and UX team members to ensure compliance with project needs. Your role will be centered on the development and improvement of new and existing features. Additionally, you will be reviewing the code of your peers, advocating for standard development methodologies, and participating in an inclusive, energetic and highly cross-functional team. The role encompasses architect, design, implementation, and testing to ensure building products right and to release them with high quality.

PRIMARY DUTIES AND ACCOUNTABILITIES

• 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.

JOB SCOPE

• Maintain deep knowledge of technology and its application across our business areas or for our customers
• Promote knowledge via seminars, presentations and publications within IT and Exelon
• Participate in technological innovation to drive new business opportunities and solve complex business problems
• Shape and advance core team processes to increase operational efficiency and quality.
• Coach and lead other engineers assigned to their product or project team.
• Considered highly skilled and proficient in discipline. Conducts complex, important work under minimal supervision and with wide latitude for independent judgment.

Qualifications

MINIMUM QUALIFICATIONS

• 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.
• 3+ years of Microsoft Azure experience
• 3+ year experience building and maintaining data pipelines in Azure Data Factory
• Experience with private and public cloud architectures, pros/cons, and migration considerations
• Minimum of 5 years of RDBMS experience
• Knowledge of ETL tools like MS SSIS.
• Experience with JSON, JSON-LD, XML data structures
• Experience with SDLC products (Azure DevOps, JIRA, Confluence, GitHub) or similar agile project management tools
• At least 3-5 years of consulting or client service delivery experience on Azure
• 3-5+ years of hands-on experience in programming languages such as Java 8, c#, node.js, python, SQL, Unix shell/Perl scripting
• 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.
• Excellent problem solving, analytical, and critical thinking skills.
• 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.

PREFERRED QUALIFICATIONS

• Experience with cloud-native Azure technologies like Azure Functions, Event Grids, Service Bus Queues, Cosmos DB, or related is a plus Logic Apps
• Azure Function App
• Microservice Architecture
• Background and knowledge of .NET REST Api.
• Service Bus Queue & Event Grids
• Experience in USQL, Hive SQL, Spark SQL, Data Bricks

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.

VEVRAA Federal Contractor