Job Posting End Date01-19-2025Please note the job posting will close on the day before the posting end date.Solution Engineer PrincipalJob DescriptionSolution Engineer PrincipalLocation: 1 Riverside Plaza, Columbus, OH 43215Job Duties:Design and develop Business Intelligence reporting solutions and data warehouse process models. Analyze, diagnose, and resolve technical issues relating to development of reporting solutions. Develop visualizations and dashboards using Cognos, Power BI, and DOMO. Implement data blending to blend related data from different data sources. Perform data analysis of reports and debug reports with database teams. Design, develop, and install advanced software solutions while considering usage, architecture, functionality, and deployment. Build high-quality, innovative, and fully performing software in compliance with internal architecture, development, and design standards and best practices. Design, modify, develop, write, implement, and troubleshoot software programming applications. Support and install software applications and lead the testing process through test review and analysis, test witnessing, and certification of software. Remote (where AEP has presence) work from home policy applies.Salary range: $121,139 to $150,755 annuallyRequirements:Bachelor’s degree in Computer Science, Engineering, or a related technical field and 7 years of experience in designing and developing BI reporting solutions that includes at least 5 years of the following:
Designing and developing BI intelligence utilities financial reporting solutions using Cognos, Power BI, and at least 2 years with DOMO.
Cognos and Power BI frameworks, semantic layers, reports, dashboards, data modules, and data sets for business intelligence.
Developing data warehouse process models including sourcing loading transformation and extraction.
Optimizing performance of complex queries and business intelligence reporting.
Transforming self-service business intelligence reporting in Power BI, Cognos, Tableau and DOMO into enterprise scale solutions in Power BI or Cognos.
At least 2 years of leveraging Alteryx workflows for data preparation and translating them into enterprise ETL tool (Informatica) processes.
Candidates will be considered based on their qualifications and the candidate’s ability to work from an approved work location. Although the location is flexible, AEP does not have a presence in all states and localities. The following locations are NOT currently approved for this position: AK, CO, CT, DE, HI, IA, ID, KS, MA, ME, MS, MT, ND, NH, NJ, NM, NV, NY, OR, RI, SD, UT, VT, WY, US Territories or international work locations. AEP will consider qualified candidates who are willing to relocate to an approved work location, at the candidate’s expense, provided the relocation can be completed within a timeframe that meets AEP’s staffing needs. NOTE: All remote work locations require vetting and final approval prior to offer and/or start date. Any work locations listed as preferred or unapproved relate specifically to the requirements for this position and are not necessarily applicable to other posted positions.Hear about it first! Get job alerts by email. Log in to your Candidate Home Account today! If you don't have an account, you can create one.It is hereby reaffirmed that it is the policy of American Electric Power (AEP) to provide Equal Employment Opportunity in all aspects of the employer‐employee relationship including recruiting, hiring, upgrading and promotion, conditions and privileges of employment, company sponsored training programs, educational assistance, social and recreational programs, compensation, benefits, transfers, discipline, layoffs and termination of employment to all employees and applicants without discrimination because of race, color, religion, sex, age, national origin, ethnicity, ancestry, veteran or military status, disability, genetic information, sexual orientation, gender identity, or any other basis prohibited by applicable law. When required by law, we must record certain information to be made part of an Affirmative Action Plan. Applicants for employment may also be invited to participate in the Affirmative Action Program by self-identifying their Race or Ethnic Identity.