Arizona Public Service - APS · 2 days ago
ETL Data Transformation and Modeling Analyst II / III
Wonder how qualified you are to the job?
Insider Connection @Arizona Public Service - APS
Responsibilities
Proficient in data architecture, data modeling, data transformation and consumption, and data integration
Collaborate with business and APS managers to identify and prioritize data needs.
Design, develop, and maintain advanced BI applications and architecture.
Extract data from various sources and manage data warehouses.
Solve technical challenges and optimize the performance of BI tools by defining data filters and indexes.
Work with cloud-based solutions and architecture.
Utilize tools like Informatica and Azure Synapse for data integration and management.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelors' degree in Information Technology or related field
Five (5) years of prior relevant experience or equivalent combination of education and directly related experience for ETL Data Transformation and Modeling Analyst II
(7) years of prior relevant experience or equivalent combination of education and directly related experience for ETL Data Transformation and Modeling Analyst III
Proficient in data architecture, data modeling, data transformation and consumption, and data integration
Collaborate with business and APS managers to identify and prioritize data needs
Design, develop, and maintain advanced BI applications and architecture
Extract data from various sources and manage data warehouses
Solve technical challenges and optimize the performance of BI tools by defining data filters and indexes
Work with cloud-based solutions and architecture
Utilize tools like Informatica and Azure Synapse for data integration and management
Four (4) years of SQL, Data Modeling and ETL, BI Dashboard and/or report development experience (Power BI, SAP Business Objects) preferred
Preferred
Knowledge of business intelligence database structures, algorithms, best practices and auditing mechanisms
Business intelligence products such as Azure Synapse, Power BI Dashboards, Power BI, Informatica, report builder; data warehouse objects, dimensions, hierarchies, fact tables, and aggregates; database and statistical programming languages (SQL, Python)
Familiarity with cloud architecture and tools like Azure Synapse, Azure Data factory (ADF), Azure Data Lake
Data warehousing and performance concepts; common and complex business intelligence tools; change control and business intelligence agility methodologies; performance tuning practices; the development of complex SQL inquiries
Company
Arizona Public Service - APS
APS is Arizona’s largest and longest serving electric utility, providing power for nearly 1.2 million customers in 11 of the state’s 15 counties.
H1B Sponsorship
Arizona Public Service - APS has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2022 (5)
2021 (1)
Funding
Current Stage
Late StageTotal Funding
$70.5MKey Investors
US Department of Energy
2009-09-16Grant· $70.5M
Leadership Team
Recent News
The Arizona Republic
2024-04-09
The Arizona Republic
2024-04-09
The Arizona Republic
2024-04-09
Company data provided by crunchbase