Senior Data Warehouse Engineer

Employer:                    Nextiva
Position Location:       Scottsdale, Arizona
Position:                      Senior Data Warehouse Engineer     

Job Duties:

1. Create a flexible data model design in compliance with Kimball methods that is scalable and reusable, while simultaneously emphasizing performance and the enterprise's business needs.
2. Design reporting ODS, staging area and data marts for different lines of Business to deliver Enterprise Data Warehouse (EDW).
3. Create extraction, transformation and loading (ETL) solutions for a high-profile reporting Data Warehouse to provide enhanced Business Intelligence and decision support reporting.
4. Application of various objects across Informatica Power Center (ETL), Informatica Power Exchange (CDC), and Informatica Master Data Management (MDM).
5. Responsible for Designing, Developing, Quality Assurance, User Acceptance Testing, and Production Release.
6. Collaborate with Business Analysts, ETL team and BI team to understand requirements, design the ETL, as well as fill in the gaps between Business Requirement Document (BRD) and technical documents.
7. Deliver key support to multiple IT teams, business users, combined with creating, maintaining technical and application support documentation.
8. Tune and solve problems in Oracle databases and many SQL statements for the data warehouse project.
9. Position is based out of Scottsdale, Arizona HQ, but telecommuting is permitted on a case-by-case basis.

Salary:                                     Available upon request

Work Schedule:                       40 hours/week

Job Requirements:     

• Education Requirements: Bachelors degree in Electronics Engineering, Computer Science, or closely related. Employer accepts foreign equivalent degree.
• Experience Requirements: 60 months in job offered, Technical Architect, Team Lead, IT Offshore Department, or closely related.

Special skills requirements:

1. Experience designing of ETL process(s) to load data from source to staging, foundation and presentation layers of the Data Warehouse.
2. Experience designing reporting ODS, staging area and data marts for different Lines of Business to deliver Enterprise Data Warehouse (EDW).
3. Experience tuning and solving problems in Oracle databases and many SQL statements for the data warehouse project.
4. Experience creating a flexible data model design in compliance with Kimball methods that is scalable and reusable, while simultaneously emphasizing performance and the enterprise's business needs.
5. Experience Engineer ETL solution for a high-profile reporting Data Warehouse to provide enhanced Business Intelligence and decision support reporting.
6. Experience using various objects across Informatica Power Center (ETL), Informatica Power Exchange (CDC), Informatica Master Data Management (MDM).
7. Experience being responsible for Design – Development – QA – UAT – Production Release
8. Experience interacting with Business Analysts, ETL team and BI team to understand requirements, design the ETL and filling in the gaps between and Business Requirement Document (BRD) and technical documents.
9. Must have or be able to obtain a Microsoft Certified: Azure Data Engineer Associate certification from Microsoft.

Qualified applicants send cover letter and resumes to: Nextiva, Lisa Fitch, Senior Manager, Benefits and People Operations, lisa.fitch@nextiva.com, ref job#SP01. EOE.

Compensation, Rewards & Benefits:

Nextiva provides a comprehensive employee benefits package that includes medical (including supplemental plans for accident, hospitalization and critical illness), telemedicine, dental, vision, disability, life insurance, legal assistance, an Employee Assistance Plan, paid parental bonding leave, PTO for hourly employees and Flexible Time Off (FTO) for salaried employees, an employee long-term savings plan (401k) through Fidelity with Nextiva matching, comprehensive employee wellness programs and loads of learning and development opportunities which are coupled with career paths to last a lifetime.

Interested in joining our amazing team at Nextiva HQ? Apply today as we launch the future of business conversations! 🚀

To check out what’s going on at Nextiva, check us out on Instagram, Instagram (MX), YouTube, LinkedIn, and the Nextiva blog. 

In 2022, Nextiva has been recognized by Comparably as the ‘Best Place to Work’ in the following categories: Best Company Leadership, Best CEO for Women, Best Global Culture, and Best Places to Work in Phoenix.

Additional workplace awards include 2021 LinkedIn Talent Employee Engagement Champion, Comparably’s Best CEO 2021, Best Company Culture 2021 and 2018, Best Company Compensation 2022, 2021 and 2019, and Glassdoor’s 2020 Best Places to Work.

Nextiva is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Nextiva participates in the E-Verify Program where and as required by law. For additional information about E-Verify visit USCIS.