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.
This position focuses on analytic activities within the Microsoft Business Intelligence and Analytics domain, including 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. The developer will be responsible for developing and implementing AI-driven solutions and collaborating with stakeholders to optimize analytics outcomes.
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.
- Write and optimize Data Analysis Expressions (DAX) queries for data analysis and reporting.
- Ensure accurate extraction, transformation, and loading of data into the data hub/data warehouse.
- Provide ongoing production support for data hub/data warehouse processes.
- Work closely with data architects, data analysts and stakeholders to design and implement efficient data models.
- Uphold data security protocols, maintain data quality standards, and ensure compliance.
- Continuously optimize ETL processes for improved performance.
- Integrate artificial intelligence (AI) technologies to enhance data analytics capabilities.
Knowledge, Skills & Abilities
- Relevant certifications in Microsoft Azure services.
- Strong understanding of database concepts for data modeling and mapping.
- Experience with high volume, complex relational databases, and star schemas.
- Proficiency in writing complex SQL queries.
- 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.
- 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) is a plus.
- Skills in Python, R, or other programming languages used in data analysis are a plus.
- Experience with Microsoft Azure (Fabric, Databricks).
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.
#J-18808-Ljbffr