Role: Sr. BI Developer

Location: Chandler, Arizona

Job type: Fulltime

Summary:

The Sr. BI Developer is an experienced hands-on professional with extensive knowledge of information management, data warehousing and analytics technologies. The role will provide strategic and tactical direction in the areas of Business Intelligence Analytics, ETL Development, Data Modeling and assessment of Data Quality and Consistency across platforms, services and business units.

Essential Duties:

• Bring a “hands-on” perspective with analytics technologies and an understanding of the “right tool for the right job” promoting self Service BI/Data Discovery/Data Exploration/Hub-Spoke BI


• Ability to set the vision, gather requirements, gain business consensus, perform vendor and product evaluations, mentor business and develop resources, and deliver solutions


• Ability to drive strategy and implementation of enterprise data architectures, providing technical guidance to other resources, enforcing standards, identifying new data structures to support the programs of work, managing the enterprise data model, the maintenance of the data, and enterprise data integration approaches.


• Works with staff and customers to understand the business requirements and business processes, design data warehouse (“DW”) schema and define extract-translate-load (“ETL”) and/or extract-load-translate (“ELT”) processes for DW.


• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, normalized and de-normalized models, handling “slowly-changing” dimensions/attributes.


• Extensive expertise in MSSQL / Oracle database, as well as data modeling, conceptual, logical and physical models.

Minimum Requirements (Education, Experience, Certifications):

• BS or MS degree in an appropriate area of specialization (Computer Science, Mathematics, Statistics, Industrial Engineering)


• 5-7+ years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies.


• Experience modeling, designing and integrating enterprise databases and data warehouses.


• Experience with Information Lifecycle Management including all security aspects such as Data Security, High Availability, and Disaster Recovery.


• Experience with enterprise data management technologies, including database platforms, ETL tools, and SQL.

Knowledge, Skills & Abilities:

• Knowledge of BI, ERP, ETL, MDM and Data Warehousing techniques, terminology, use and purpose.


• Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC).


• Experience programming in Python, SQL, javascript, or equivalent programming languages


• Experience with business intelligence tools: Microsoft BI stack, SAP Business Objects, Tableau, Snowflake, Talend, or StreamSets.


• Familiarity with Data Governance and Data Stewardship practices.


• Familiar with Agile development methodologies