Data Analytics Analyst, Sr. (Atlanta or Birmingham)

Description

Purpose:

This position will be filled in the Data Analytics & Reporting team within Technology Services. Key responsibilities as a member of the team include detailed data engineering and integration, data analysis, data architecture and requirements mapping, Data Virtualization and big data design, development and implementation. This position also works closely with Data Architects within the organization to ensure that new analytics solutions align with the enterprise data management strategy. This includes identification of the true source of data, reducing data redundancy and focusing on increased integration of data across business units. This includes increasing data quality, compliance, and governance.

The successful candidate will have proven ability to analyze and troubleshoot issues that arise within Data platforms and analytics toolsets and the enterprise infrastructure supporting these solutions.

Education/Experience:

• Bachelor's degree in computer science/Engineering or related degree preferred.
• Experience with implementing BI/analytics solutions using the Microsoft BI/analytics toolset.
• Experience working in a fast-paced and innovative information technology organization.

Knowledge/Skills:

• Strong technical knowledge for designing, implementing and supporting data engineering and integration solutions (expertise of the tools listed below is highly preferred but not limited to)
• MS SQL Server Tools (Analysis Services, Integration Services, Reporting Services, PolyBase)
• Data Factory
• Data Lake
• Spark, Azure Synapse Pipelines
• Azure Databricks
• Microsoft Power Automate
• At least 5 years of experience with implementing BI/analytics solutions using the Microsoft BI/analytics toolset
• Cloud Computing (Microsoft Azure preferred)
• General knowledge of Hadoop and other big data technologies
• Familiar with the evolving data and related data systems and how this can influence the future of the organization.
• Effective communication (verbal/written) and leadership skills to foster enterprise adoption of data engineering and analytics solutions within business units and other IT teams.
• Ability to handle multiple assignments and conflicting priorities.
• Expertise in Integrating, Transforming, and Consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions.
• In-depth knowledge of the data serving layer such as;designing star schemas, slowly changing dimensions, dimensional hierarchies, solution for temporal data, incremental loading, designing analytical and Metastores.
• Implementation experience of physical and logical data storage structures such as compression, partitioning, sharding, different table geometries, data redundancy, distributions, data archiving, building logical folder structure, external tables, implementing file and folder structures for efficient querying and data pruning.
• Understand the deployment and data management implications of working across diverse environments that span both cloud and on-premises.
• Ability to build APIs for data access or landing data as output for further downstream consumption in the appropriate target data store.
• Experience in agile methodologies and application of DevOps and DataOps principles to data pipelines.
• SAS and Tableau knowledge a plus

General Job Responsibilities:

• Design, develop and support batch processing solutions by using Data Factory, Data Lake, Spark, Azure Synapse Pipelines, PolyBase, and Azure Databricks.
• Design, implement and support a complex event-processing engine for analyzing and processing high volumes of fast streaming data from multiple sources simultaneously. (e.g., Kafka, Spark, Flink, Kinesis).
• Develop, package and deliver new data engineering and integration solutions
• Serve as a data engineering and integration subject matter expert
• Collaborate with end users to identify needs and opportunities for improved data engineering and integration solutions and delivery
• Collaborate with peers; mentoring team members to enhance skills and abilities; providing leadership as required.

Core Behavioral Attributes:

• Thesuccessful candidate will demonstrate understanding and application of the Southern Style behaviors: Unquestionable Trust, Superior Performance, and Total Commitment .

Additional required behavioral attributes/competences:

• Results-oriented
• Innovative
• Strategic thinker with an enterprise view for sustainable solutions
• Committed to continuous learning and improvement
• Committed to the development of others
• Committed to building and maintaining constructive partnerships with business partners
• Works well both independently and with others
• Acts with speed and decisiveness
• Committed to ethical conduct
• Lives and works safely

Tech Stack

• Python
• SQL and NoSQL databases
• Scala
• Spark-SQL
• Experience with Azure: ADLS, Databricks, Stream Analytics, SQL DW, COSMOS DB, Analysis Services, Azure Functions, Serverless Architecture, ARM Templates

#LI

Alabama Power provides the valuable combination of competitive prices, reliable electricity supply and unparalleled service to 1.4 million homes, businesses and industries in the southern two-thirds of Alabama123.

SouthernLINC Wireless is the wireless communication service from Southern Company which combines multiple communication services into one handset or installed device, including Instant LINC two-way radio, phone service, numeric and text messaging, and wireless data and Internet access. SouthernLINC Wireless operates in the Southeast and targets businesses, government and Southern Company subsidiaries.

Southern Company Gas provides for the energy needs of millions of U.S. households and businesses. As the largest natural gas-only distribution company in the United States, with more than 150 years of history behind us, we're working to ensure that Americans have access to an abundant, safely delivered supply of natural gas for decades to come. We offer our customers a wide range of energy services under one umbrella: seven regulated utilities as well as non-regulated businesses that offer retail, wholesale and storage services.

Georgia Power is the largest electric subsidiary of Southern Company (NYSE: SO), America's premier energy company. Value, Reliability, Customer Service and Stewardship are the cornerstones of the Company's promise to 2.6 million customers in all but four of Georgia's 159 counties. Committed to delivering clean, safe, reliable and affordable energy at rates below the national average, Georgia Power maintains a diverse, innovative generation mix that includes nuclear, coal and natural gas, as well as renewables such as solar, hydroelectric and wind. Georgia Power focuses on delivering world-class service to its customers every day and the Company is consistently recognized by J.D. Power and Associates as an industry leader in customer satisfaction. For more information, visit www.GeogiaPower.com and connect with the Company on Facebook ( Facebook.com/GeorgiaPower ), Twitter ( Twitter.com/GeorgiaPower ) and Instagram ( Instagram.com/ga_power ).

Mississippi Power a subsidiary of Southern Company, serves southeast Mississippi. We have a history of customer and community service, economic development leadership, environmental stewardship and employee involvement.

Southern Nuclear's top priority is the safety and health of the public, our employees and the environment. We are committed to the safe operation of our nuclear generating facilities with equipment and systems that meet strict Nuclear Regulatory Commission safety and design regulations. Each Southern Nuclear employee is committed to instilling Institute for Nuclear Power Operations' "Principles for a Strong Nuclear Safety Culture" in every aspect of their responsibilities.

Southern Power , a subsidiary of Southern Company, is a leading U.S. wholesale energy provider meeting the electricity needs of municipalities, electric cooperatives, investor-owned utilities and other energy customers. Southern Power and its subsidiaries own 47 facilities operating or under construction in 11 states with more than 12,800 MW of generating capacity in Alabama, California, Florida, Georgia, Maine, Minnesota, Nevada, New Mexico, North Carolina, Oklahoma and Texas.

Southern Company (NYSE: SO) is a leading energy company serving 9 million customers through its subsidiaries as of Jan. 1, 2019. The company provides clean, safe, reliable and affordable energy through electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company serving wholesale customers across America, a leading distributed energy infrastructure company, a fiber optics network and telecommunications services . Southern Company brands are known for excellent customer service, high reliability and affordable prices below the national average. For more than a century, we have been building the future of energy and developing the full portfolio of energy resources, including carbon-free nuclear, advanced carbon capture technologies, natural gas, renewables, energy efficiency and storage technology. Through an industry-leading commitment to innovation and a low-carbon future, Southern Company and its subsidiaries develop the customized energy solutions our customers and communities require to drive growth and prosperity. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and govern our business to the benefit of our world. Our corporate culture and hiring practices have been recognized nationally by the U.S. Department of Defense, G.I. Jobs magazine, DiversityInc, Black Enterprise, Forbes and the Women's Choice Award. 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 Field: Information Technology

Job Type: Standard

Primary Location: Georgia-Metro Atlanta-Atlanta

Operating Company: The Southern Company

Other Locations: Alabama-Metro Birmingham/Eastern AL-Birmingham

Job Type: Standard

Travel (Up to...): Yes, 25 % of the Time

Work Location(s):

Georgia Power Headquarters - 241 Ralph McGill Blvd. NE (241ATLANTA)

241 Ralph McGill Blvd. NE

Atlanta, 30308

APC Corporate Headquarters - 600 North 18th Street (600BIRMINGHAM)

600 North 18th Street

Birmingham, 35203

Req ID: SCS2011262