Data Engineer 1 - Data Modeling

Exelon • Oakbrook Terrace, IL

12h • Onsite

About The Position

Exelon is leading the energy transformation and is seeking problem solvers, innovators, community builders, and change makers to deliver solutions that make diverse cities and communities stronger, healthier, and more resilient. The company is powered by purpose-driven people who believe in being inclusive and creative, and value safety, innovation, integrity, and community service. Exelon is a Fortune 200 company with 20,000 colleagues serving over 10.7 million customers across six energy companies. They are committed to creating an environment where every person can thrive, focusing on purposeful careers, growth opportunities, community impact, and support to thrive. Exelon elevates diverse voices, fresh perspectives, and bold thinking, and provides competitive compensation, incentives, excellent benefits, and the opportunity to build a rewarding career.

Requirements

• Bachelor's degree in computer science or related discipline and 2-4 years' relevant experience in data warehouse design, business intelligence reporting and ETL/TLT processing or 3-6 equivalent combination of education and work experience.
• Ability to write clear, concise, and comprehensive documentation, such as systems specifications, product descriptions, operational procedures, etc.
• Some experience or exposure to the various commands and components of a variety of tools. Understands basic concepts, symbols, and conventions.
• Understands how tasks are integrated to produce final deliverables and able to recognize 'textbook' problems and resolve them with assistance.
• Experience implementing a data naming standard for a business area or department, recommended appropriate levels of data access for different user groups and suggested appropriate backup and recovery strategies for various categories of data.

Nice To Haves

• Knowledge of Data modeling and experience of building models and catalogs.
• Databricks cataloging, collibra catalog, lineage, policies
• Data Modeling Experience, building Data models for Utilities
• Experience working with Exelon Customer, MDM, ADMS systems familiarity of the data
• Demonstrates a basic understanding of how the business works and can maintain a focus on what is good for the business.
• Understanding of current process with regular evaluation and ability to participate and provide suggestions for innovative improvements for future tasks.
• Demonstrated knowledge of industry trends and experience developing and implementing new technologies or platforms.
• Displays an attitude commensurate with being a good negotiator, including goodwill, collaboration, and mutual satisfaction.
• Ability to build and maintain relationships and aptitude to synthesize what a business partner is asking for.
• Ability to learn to create simple scripts.
• Has light experience, training, direct exposure, or experience working with Data Interpretation and some experience with statistical analysis.
• Has general knowledge of security as it relates to data sets, passwords, and user IDs, including the basic concepts of confidentiality and integrity. Has basic knowledge of virus prevention, firewall protection and other data protection and privacy tools and concepts.
• Has knowledge of the architecture of the data and databases related to work assignments.
• Has light experience, training, direct exposure, or experience working with the company's data management processes.

Responsibilities

• Perform activities relating to designing, building, testing, implementing, and maintaining Data Models in EU Analytics under the guidance of a Sr. Data Engineer - Data Modeler or Manager.
• Perform, document, and assist in planning work activities relating to projects, sub-projects, or processes. For Projects: analyze requirements, design, build, and test IT software solutions in accordance with IT project management standards. For operations/application maintenance: enhance, maintain, or support existing Data Models and Data Products (70%)
• Assist in creation of documentation for products and services. Use best practices to improve products and services provided to business unit partners, and monitor adherence within Team/Group to standards as defined within the Management Model (20%)
• Proactively build business relationships, technical knowledge, and business acumen within own discipline or function. (10%)

Benefits

• Annual salary will vary based on a candidate’s skills, qualifications, experience, and other factors: $80,800.00/Yr. – $111,100.00/Yr.
• Annual Bonus for eligible positions: 10%
• 401(k) match and annual company contribution
• Medical, dental and vision insurance
• Life and disability insurance
• Generous paid time off options, including vacation, sick time, floating and fixed holidays, maternity leave and bonding/primary caregiver leave or parental leave
• Employee Assistance Program and resources for mental and emotional support
• Wellbeing programs such as tuition reimbursement, adoption and surrogacy assistance and fitness reimbursement
• Referral bonus program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 5,001-10,000 employees