Senior Data Warehouse Developer AirCell
Aircell is the world's leading provider of airborne communications.
Until recently, time spent in the cabin of a business jet meant that you were disconnected from the world circling below. That?s all changed. Airborne technology has finally caught up with the rest of the world. Simply put, voice, data and even the entire Internet can be at your disposal during flight?in the cockpit and in the cabin. Now you can use that time to return calls, answer email, download files or simply conduct a little firsthand Internet research.
The Senior Data Warehouse Developer will, along with their peers, be responsible for providing business partners and corporate leadership with information required to report on the health of the company and make strategic decisions.
You will be extracting data from multiple source systems, applying business rules to transform the data, and loading it into a data warehouse for consumption by business users. Additionally, the position entails some report, dashboard creation leveraging cutting edge Business Intelligence technology.
You will have the opportunity to consult directly with business users to jointly solution optimal deliverables. The position also provides you with the opportunity to leverage offshore resources to accomplish more.
Come onboard the Aircell IT and Operations team!
Support and improve existing Data warehouse solutions.
Perform extensive design, development, testing, and performance tuning of ETL processes within SSIS.
Take ownership of incident tickets and manage the whole process through resolution.
Need to work with technical and business units to resolve support issues
Explore new options for solving business problems and take calculated risks.
The role will also require the ability to gather, understand, organize and transform business requirements from functional teams/SMEs/Business Analysts into BI solutions.
Create conceptual models and data flow diagrams as part of the functional documentation.
Responsible for developing and implementing corrections and or improvements according to change requests.
Work with multiple Business Divisions and manage user expectations.
Provide mentoring and knowledge transfer to other developers newer to SSIS.
Meet ongoing and overlapping deadlines in a fast-paced environment.
Handle multiple assignments simultaneously and have the ability to coordinate deliverables and dependencies with other groups.
Required Qualifications and Experience
Bachelor degree in Computer Science or equivalent work experience.
Minimum experience of 7 years in data warehousing, business intelligence, or information management technology/platform.
3+ years of design, development, testing, and performance tuning experience with SQL Server Integration Services (SSIS) is required.
Desired Experience and Technical Skills
Experience with other ETL tools, such as, Data Stage, Informatica, or SAP Data Services a plus.
Familiarity with SAP Business Objects R4 features and Functions, Xcelsius implementation experience, and Live Office Implementations.
Experience in High Volume, global implementations (Over 5-10TB EDW).
Experience working in an Onshore/Offshore Model.
Industry Travel (Airline) with Customer Insight and Marketing Analytics (>=3 Years) and/or DW Technology Consulting.
Experience working with other RDBMS such as Oracle or Teradata.
Experience working with Hadoop, ?Big Data?.
Having experience working on Agile based project methodology and fast moving high demand BI projects is preferable.
Full life cycle experience (requirements gathering through production deployment) in all aspects of BI/DW (ETL, data modeling, analytics and reporting).
Experience with incident/ticket tracker tool like Remedy, JIRA or similar tools.
Good communication and convincing skills with various stakeholders.
Ability to articulate complex technical concepts to non-technical clients.
||Broomfield, CO |