Architect, Data Analytics

Company: United Technologies
Location: Winston Salem , North Carolina, United States
Type: Full-time
Posted: 09.OCT.2019


Date Posted: 2019-04-11-07:00 Country: United States of America Location: HNC34: US107-Winston-Salem (Fairchild 1455 Fairchild Road , W...


Date Posted:



United States of America


HNC34: US107-Winston-Salem (Fairchild 1455 Fairchild Road , Winston-Salem, NC, 27105 USA

At Collins Aerospace, we're dedicated to relentlessly tackle the toughest challenges in our industry - all to redefine aerospace.

Created in 2018 through the combination of two leading companies- Rockwell Collins and United Technologies Aerospace Systems - we're driving the industry forward through technologically advanced and intelligent solutions for global aerospace and defense. Every day we imagine ways to make the skies and the spaces we touch smarter, safer and more amazing than ever. Together we chart new journeys, reunite families, protect nations and save lives. And we do it all with some of the greatest talent this industry has to offer.

We are Collins Aerospace and we hope you join us as we REDEFINE AEROSPACE.

At Collins Aerospace, our Interiors team is focused on innovation, safety and cost efficiency. But we don't just get people from point A to point B. We're committed to making air travel more comfortable, connected and secure. As a leader in aviation interior products and services, we're helping airlines and original equipment manufacturers create a positive experience for their customers. With offices and manufacturing facilities in more than 12 states across the U.S. and more than 10 countries around the globe, we're changing the game of aircraft interiors. Are you ready to join our team?Do you want to be part of a new, exciting initiative to combine foundational IT with new digital technologies?Our Digital Technology team is driving business efficiencies and a better customer experience by connecting technologies, people, information and processes. From making aircraft more electric, intelligent and integrated to building new software platforms such as Internet of Things, big data, artificial intelligence, and blockchain, there's no better place to be right now than in digital. If you're an agile thinker who enjoys utilizing modern technology to make big improvements, then you're a perfect fit for this team. Join Collins Aerospace to help us revolutionize the aerospace industry today!


Reporting to the Director, Software Development, the Architect, Data Analytics will enter review and analyze data within the database; ensure user data integrity; make decisions affecting user access; document and record attributes; formulate database query and retrieval scripts; and review database design and integration of systems and provide backup recovery.


In this position, you will develop business solutions by creating new and modifying existing business intelligence solutions created on Microsoft BI platform. You will design, code, test, debug, document and support OBI/SSIS/SSRS/SQL Server SP based applications consistent with established specifications and business requirements to deliver business value. Your will have to multi-task, prioritize work, and work independently under aggressive timelines.

  • Develop end-to-end BI/Data Analytics solutions using tools such as Tableau, OBI, SSIS/SSRS for complex business requirements
  • Complete production support service requests, troubleshooting issues and batch support to ensure high levels of application availability and accuracy
  • Provide regular and periodic maintenance/upgrade of data warehouse SQL server, BI tools like Tableau, OBI, SSIS and SSRS
  • Serve as the primary POC for all technical issues related to the Data warehouse solutions/Platform. Learn and support new tools on the job.
  • Work with business leaders to develop detailed business requirements, creating functional design, gap analysis, technical design, and traceability matrices
  • Perform other related duties as required

  • Bachelor's degree from a 4 year university in Information Technology or similar and 5 years of relevant experience; or an equivalent combination of education and relevant experience
  • Expert development/debug skills with tools such as Tableau, Oracle Business Intelligence (OBI), Microsoft SQL Server Integration services (SSIS), SQL Server Reporting services (SSRS) tool or similar tool
  • Strong background on T-SQL
  • Experience performing administrative tasks on SQL Server
  • Ability to develop/troubleshoot/enhance complex Stored Procedures for data loadings/transformation
  • Ability to work independently to meet objectives with aggressive timelines
  • Ability to multi-task, prioritize workload and work well in a team environment
  • Strong working knowledge of other enterprise reporting tools like Tableau , Oracle Business Intelligence (OBIEE),BO etc.
  • Good understanding of key IT / business systems / ERP, General Ledger, Reporting and Analytics, Data Warehousing, CRM, etc.

  • Good knowledge on Business Intelligence design
  • Query Performance Tuning
  • Experience in error handling, job monitoring/reverse-engineering, notification rules, proactive communication

  • At Collins, the paths we pave together lead to limitless possibility. And the bonds we form - with our customers and with each other -- propel us all higher, again and again.
    Some of our competitive benefits package includes:
    • Medical, dental, and vision insurance
    • Three weeks of vacation for newly hired employees
    • Generous 401(k) plan that includes employer matching funds and separate employer retirement contribution
    • Tuition reimbursement
    • Life insurance and disability coverage
    • And more

    Apply now and be part of the team that's redefining aerospace, every day.

    United Technologies Corporation is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

    Privacy Policy and Terms:

    Click on this link to read the Policy and Terms

    Apply Now


    Free eBook

    Loader2 Processing ...