Senior Application Developer

JOB TITLE: Senior Application Developer

LEVEL: 6

JOB SUMMARY:

The Analytics Platform Team plays a pivotal role in the Technology Organization by developing and maintaining robust analytics platforms to empower decision-makers with timely and accurate information, enabling them to make informed decisions.

This position will primarily be focused on analytic activities within the Microsoft Business Intelligence and Analytics domain which include all aspects of application development and data lifecycle, production support for vendor managed and custom solutions, solution delivery of new enhancements and bug fixes. It also includes data modeling, ensuring data security, quality and compliance, understanding of data warehouse concepts and continuous performance optimization. Additionally, the role involves integrating Artificial Intelligence (AI) to enhance data analytics capabilities, automate processes, and provide advanced insights. The developer will be responsible for developing and implementing AI-driven solutions, leveraging existing machine learning models, and collaborating with stakeholders to optimize analytics outcomes. The developer will also be required to provide time/effort estimates and contribute to project planning.

Education and Experience

• B.S. or M.S. in Computer Science, Management Information Systems, Engineering, Mathematics or related field
• 5+ years of experience in BI development, data warehousing and data lifecycle management utilizing the Microsoft Technology Stack

Key Responsibilities

• Design, develop and maintain complex SQL queries and PL/SQL stored procedures for Oracle databases, ensuring data integrity and performance optimization.
• Design, develop and maintain multi-dimensional cubes to support complex analytical queries and reporting requirements.
• Use Tabular Editor to manage and optimize tabular models, making adjustments and enhancements to improve performance and maintainability.
• Write and optimize Data Analysis Expressions (DAX) queries for data analysis and reporting, ensuring efficient and accurate data retrieval; utilizing DAX studio.
• Ensure accurate extraction, transformation, and loading of data into the data hub/data warehouse while adhering to established standards and guidelines.
• Provide ongoing production support for data hub/data warehouse processes, promptly addressing any issues or discrepancies that arise.
• Work closely with data architects, data analysts and stakeholders to design and implement efficient data models that align with business requirements.
• Uphold data security protocols, maintain data quality standards, and ensure compliance with industry regulations.
• Continuously optimize ETL processes for improved performance, reduced load times, scalability, and reliability.
• Integrate artificial intelligence (AI) technologies to enhance data analytics capabilities and automate repetitive tasks.

Knowledge, Skills & Abilities

Technical Skills

• Relevant certifications in Microsoft Azure services.
• Strong understanding of database concepts for data modeling and mapping including referential integrity, indexes, keys, common dimensions, master data and metadata.
• Experience with high volume, complex relational databases, and star schemas.
• Proficiency in writing complex SQL queries for data analysis and troubleshooting.
• Strong understanding of dimensional modeling (star schema).
• Demonstrated expertise in designing and implementing scalable data models.
• Solid understanding of data warehousing concepts.
• Strong knowledge of BI design best practices.
• Optimize the performance of Power BI reports and dashboards.
• Design and implement data models in Power BI to support reporting requirements.
• Working knowledge of SQL Server Management Studio.
• Experience working with SQL Server Analysis Services (SSAS).
• Familiarity with ETL processes using SQL Server Integration Services (SSIS) and other relevant tools to ensure efficient data transformation and loading, is a plus.
• Skills in Python, R, or other programming languages used in data analysis are a plus.
• Experience with Microsoft Azure (Fabric, Databricks).

Data Management

• Understanding of data lifecycle concepts, including data collection, processing, and visualization.
• Knowledge of data modeling techniques and data warehouse concepts.
• Understanding of data security and compliance principles.

Communication and Collaboration

• Strong communication and interpersonal skills.
• Effective collaboration within a team.
• Ability to build and effectively manage relationships within a large, multi-state organization.
• Experience working with stakeholders to understand their needs, translate them into clear and concise technical requirements and propose solution.

Problem Solving and adaptability

• Ability to interpret and analyze data to generate insights.
• Ability to think analytically and critically to solve complex problems and make informed decisions based on data.
• Skills in assessing and improving data quality through profiling, cleansing, and validation.
• Self-motivation to work effectively with limited direct supervision.
• Ability to effectively move forward on tasks even with ambiguous or changing requirements.
• Aptitude and willingness to learn new technologies.
• Ability to write clear, concise, and comprehensive technical design documents that can be understood by both technical and non-technical stakeholders.
• Ability to manage production support and project related activities simultaneously.

Soft Skills

• Strong communication skills to collaborate with team members and stakeholders.
• Attention to detail and a commitment to quality and accuracy.
• Ability to manage time effectively and handle multiple tasks simultaneously.
• Ability to execute tasks provided by management or senior team members.
• Experience in documenting Mapping Specifications for source to target mapping.

Project Support

• Basic understanding of project management principles.
• Ability to provide time/effort estimates for tasks.
• Knowledge and experience with SDLC.
• Willingness to learn and contribute to project planning and execution.
• Working knowledge of SAFe Agile Framework.

Artificial Intelligence

• Knowledge of artificial intelligence and machine learning concepts.
• Knowledge of integrating AI technologies, such as machine learning models, into analytics platforms to enhance capabilities, automate processes, and generate advanced insights

Behavioral Attributes

• Takes personal ownership of career development
• Demonstrates Our Values – Safety First, Intentional Inclusion (We are One Team), Act with Integrity, Superior Performance
• Continuous learner with a high level of interest in learning and applying new technologies and concepts
• Result Oriented, can act with speed and decisiveness; take initiative and does what it takes to meet commitments.
• Strong focus on quality, reliability, efficiency, and cost effectiveness of solutions
• Effective in organizing tasks, managing multiple priorities, meeting schedules, and delivering on commitments
• Strong presentation skills and ability to relate and connect with a variety of audiences
• Methodical approach to solving problems

Other:

Candidate must be available weekends and after normal business hours for on-call support. Some travel may be required within the Southern Company footprint.

Southern Company (NYSE: SO) is a leading energy provider serving 9 million residential and commercial customers across the Southeast and beyond through its family of companies. Providing clean, safe, reliable and affordable energy with excellent service is our mission. The company has electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company, a leading distributed energy infrastructure company with national capabilities, a fiber optics network, and telecommunications services. Through an industry-leading commitment to innovation, resilience, and sustainability, we are taking action to meet our customers and communities needs while advancing our commitment to net zero emissions by 2050. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and are the key to our sustained success. We are transforming energy into economic, environmental and social progress for tomorrow. Our corporate culture and hiring practices have earned the company national awards and recognition from numerous organizations, including Forbes, Military Times, DiversityInc, Black Enterprise, J.D. Power, Fortune, Human Rights Campaign and more. To learn more, visit www.southerncompany.com.

Southern Company is an equal opportunity employer where an applicant’s qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

Job Identification: 7939

Job Category: Information Technology

Job Schedule: Full time

Company: Southern Company Services