One Gas Sr Developer in Tulsa, Oklahoma
Job ID: 847
Functional Area: IT
Position Type: Full-Time Regular
Relocation Provided: No
Location: Tulsa, OK
Department: IT TECH SUPPORT
Internal / External: Internal and External
Experience Required: Not Indicated
Leads all aspects of the software development lifecycle for business intelligence solutions, including data modeling, sql development, unit testing, deployment, and maintenance activities in the Microsoft Business Intelligence stack.
Leads medium to large Business Intelligence (BI) development efforts, including creation of technical requirements and design specifications, sql development, unit testing, and deployment of business intelligence solution to achieve the desired business outcome.
Develop conformed dimensions, facts and summary/aggregate table structures for implementation in Enterprise Data Warehouse and in support of related tabular models.
Complete complex BI development assignments, including integration between multiple source system applications, from documented technical requirements and design specifications.
Develop BI solutions that adhere to company coding standards and best practices, are scalable to meet business need, reliable in the production environment, and maintainable by other developers.
Identify opportunities to deploy existing BI solutions in other business areas.
Interface with Business Analysts and development team to ensure the requirements are understood and met.
Create unit test and system integration test cases/plans, and execute unit testing and integration testing to ensure quality and that business requirements are met.
Follow defined change control and compliance procedures associated with BI development, including all required documentation and governance standards.
Troubleshoot and resolve high priority and/or complex production issues that may require collaboration with IT Infrastructure and/or other IT applications teams to identify root cause and appropriate resolution. Ensure issues are resolved in timely manner to minimize negative impact on the business.
Monitor production environment to ensure application stability. Proactively identify potential production risks and provide recommended changes to address the risk before it becomes an issue.
Provide technical leadership and mentoring to other team members in all aspects of the development cycle.
Bachelor’s degree in MIS, computer science, mathematics, other related field, or an equivalent combination of formal education and the following job related experience to include:
Demonstrated mastery of Microsoft Business Intelligence (BI) development framework (SQL Server Integration Services (SSIS), Analysis Services (SSAS Tabular and Multi-dimensional), Reporting Services (SSRS), T-SQL etc.)
Demonstrated mastery of business intelligence principles and design patterns, including Kimball star schema design and development and Extract, Transform and Load (ETL) best practices including experience with Change Data Capture (CDC). Evolutionary dimensional modeling design experience is preferred.
Advanced skill level in all aspects of business intelligence cube design and development, including scalable design, C# script task in SSIS, incremental updates, stored procedures, common table expressions, windowing functions and DAX (SSAS Tabular).
Advanced experience with database management systems.
Mastery of Agile software development lifecycle methodology and project management concepts.
Experience interacting, advising and communicating effectively
Experience developing information and making presentations.
We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.