Senior Application Developer

Southern Company - Gulfport, MS

Full-time - Mid Level

Gulfport, MS

5,001-10,000 employees

Utilities

About the position

The Senior Application Developer will play a crucial role in the Analytics Platform Team within the Technology Organization at Southern Company. This position focuses on developing and maintaining analytics platforms that empower decision-makers with timely and accurate information. The role involves application development, data lifecycle management, production support, and the integration of Artificial Intelligence (AI) to enhance data analytics capabilities. The developer will collaborate with stakeholders to optimize analytics outcomes and contribute to project planning.

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.

Requirements

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

Nice-to-haves

• Relevant certifications in Microsoft Azure services.
• Experience working with stakeholders to understand their needs, translate them into clear and concise technical requirements and propose solutions.
• 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.

Benefits

• Health insurance
• 401k retirement plan
• Paid holidays
• Flexible scheduling
• Professional development opportunities
• Employee discount programs