Cognos Report Writer
We are a company of innovators, game changers, and entrepreneurs. As a prime contractor, we provide a broad range of communication, electronic and sensor systems used on military and commercial platforms across the globe. We embrace innovative and progressive ideas to advance our products for military and commercial customers. The Electronic Systems Segment (ESS) provides a broad range of aerospace systems, security and detection systems, and pilot training.
L3 Aviation Products Division (L3 APD), is a leading provider of commercial and military avionics with unsurpassed performance, quality and customer support. L3 APD manufactures a diverse line of safety- and efficiency-enhancing products that set the standard for next-generation requirements, including configurable voice and data recorders, collision avoidance systems, navigation products, display systems and processors.
We are seeking a Cognos report writer and developer to be a part of the L3 Displays team. The Cognos report writer/developer is responsible for designing, developing and implementing complex reports, dashboards and BI visualizations for Cognos solutions.
This role requires an individual with excellent attention to detail, who can influence the direction of ERP reporting and analytic solutions while working cross-functionally with business teams. The role requires strong interpersonal and communication skills, ability to work in a fast-paced environment, independence, and entrepreneurial ability to work with minimal direction and rapid prototyping.
Provide reporting solutions for all functional areas based on business needs.
Develop, modify, and enhance Cognos reports and dashboards based on user requirements.
Create, enhance, and maintain Framework Manager Models.
Collaborate with business users and members of IT, including business analysts, database administrators, and managers, to design and develop Cognos reports.
Gather and document user requirements for report development.
Perform usability testing and report data validation against end user requirements.
Gain familiarity with data structure of Deltek CostPoint ERP and other company applications.
Exhibit a commitment to data quality by validating results against requirements.
Write and maintain MSSQL queries, stored procedures, and views.
Train and guide other Cognos developers to effectively perform the above responsibilities.
Provide production support for Cognos issues during business hours and after hours as needed.
Serve as an expert knowledge base for system and data impacts related to Cognos for the organization.
Serve as the point of contact for Cognos report development.
Provide occasional training of Cognos software, environment, and configuration to other report writers and end users.
Develop training materials.
Facilitate and lead Cognos training.
Determine work priorities in accordance with project plans, project schedules, changing work demands and L-3 Company policies, practices, and priorities.
Serve as a subject matter expert across the organization and assist users with reporting and analysis activities and tools, including ad hoc reporting.
Set and manage user expectations and communicate expected report development timelines.
Our Values are an integral part of who we are. We seek candidates who share our values:
Bachelor's degree in Computer Science, Accounting, Finance, Business Administration or equivalent.
Experience with Deltek CostPoint administration and management.
5 years related Business Analyst experience.
Must have accounting, finance, and business operations experience.
Knowledge of MS SQL Server 2014 with experience in creating PL/SQL scripts, query optimization, stored procedures, triggers and SQL Server Integration Services.
Strong analytical skills, including the ability to analyze financial and operational data and prepare financial reports, statements and projections.
Experience with Deltek Cobra and Cognos BI is a plus.
Experience with integration of ERP with Manufacturing Execution Systems is a plus.
Must be able to interact with end users to gather and document requirements.
Strong Microsoft Excel, Project, Visio and PowerPoint skills.
Excellent interpersonal skills with the ability to communicate throughout all levels of an organization.
2 years of dashboard and report development experience with Cognos 10 or 11.
Outstanding analytical skills with advanced knowledge of and experience with SQL.
Experience writing reports for DELTEK CostPoint ERP is preferable but not necessary.
A proven track record of strong communication & data presentation skills, including an ability to effectively communicate and influence both business and technical teams.
Willingness to learn new tools, ability to provide consultative business analysis, leverage technical skills to create effective reports, dashboards, visualizations, and analytics.
Ability to thrive in an environment that is tasked with providing data-driven decision support.
SAVING LIVES AND MAKING THE WORLD A SAFER PLACE TO LIVE
L3 Technologies, Inc. is proud to be an Affirmative Action/Equal Opportunity Employer. L3 provides equal employment opportunity for all persons, in all facets of employment. L3 maintains a drug-free workplace and performs pre-employment substance abuse testing and background checks. We encourage all qualified applicants to apply for any open position for which they feel they are qualified and all will receive consideration for employment without regard to race, color, religion, age, gender, sexual orientation, gender identity, national origin, citizenship status, marital status, genetic information, disability, protected veteran status or any other legally protected characteristic. citizenship status, marital status, genetic information, disability, protected veteran status or any other legally protected characteristic.