Developer - Cognos, Datastage, ETL, SQL

Cognos, Datastage, ETL, SQL
Full Time, Perm
Work from home not available Travel not required

Job Description

Job Description:

BI Developer (Cognos/DataStage)
We have an exciting opportunity for an articulate, creative and enthusiastic team player to join team. We are looking for a full time Business Intelligence Developer to support and further develop our Business Intelligence and Analytics platform. The right candidate will have a proven Cognos Analytics development background, a sound understanding of ETL and data architecture concepts, and SQL proficiency. The right candidate will exhibit strategic and critical thinking, excellent problem solving and trouble shooting skills, and the ability to foster outstanding teamwork. The Business Intelligence Developer will directly engage with line of business customers at all levels, therefore, having strong collaborative, interpersonal, communications, and relationship building skills is a key factor for success in this role.
Detailed Responsibilities:
  • Participate in the design of analytics solutions supporting business domains.
  • Work independently with internal customers to identify information needs, define functional requirements and specifications, make recommendations, and propose solutions.
  • Work with DBA, Technical Leads, and business champions to design effective database models and analytical solutions based on user requirements and strategic goals.
  • Participate in the definition of the overall data warehouse architecture: ETL process, ODS, EDW, Data Marts, and Governance.
  • Drive adoption of existing and new Cognos Analytics capabilities focusing on quality, performance, and sustainability.
  • Design, develop, and support Analytics solutions including but not limited to dashboards, scorecards, operational and scheduled reports, ad-hoc queries, and decision support.
  • Perform detailed data analysis, understand data structure and content, write complex SQL queries and stored procedures.
  • Support all areas of the organization including but not limited to Accounting, Supply Services, Marketing, and Operations.
  • Collaborate with business units to perform requirements analysis, project scoping, data analysis, and business logic transformation.
  • Collaborate with business units to analyze business processes and identify, develop and assist in the implementation of process improvement opportunities.
  • Collaborate with business units to define objectives relative to the development of reporting and analytics system specifications, and process automation.
  • Design, develop, monitor, and administer ETL processes and Integrations. Verify timely ETL process execution.
  • Design and implement mechanism to audit the accuracy and completeness of ETL processes and integrations.
  • Contribute and adhere to BI standards and best practices for modeling, ETL, reporting, and dashboards.
  • Collaborate and support system architecture, design, and platform decisions.
  • Ensure high levels BI Systems availability through systems administration/support and rigorous change management.
  • Participate in all phases of the SDLC: requirements, design, development, testing, and production/go live.
  • Communicate task status, roadblocks, and critical matters to management promptly.
  • Analyze software requirements and create reliable duration estimates for approved projects.
  • Collaborate with software development teams to solve problems within BI applications and integrated applications.
  • Provide level 2 support to Cognos Analytics users.
    Skills and Qualifications:
  • BSCS, BSMIS or related degree or equivalent combination of education and related experience.
  • Required 3+ years of experience with Cognos Business Intelligence (v10.2.x); configuration, administration, deployment, modeling, and development.
  • Required 1+ years of experience with Cognos Analytics (v11.x); configuration, administration, deployment, modeling, and development.
  • Experience developing analytics solution using both, relational and dimensional data sources.
  • Strong understanding of ETL, Data Warehouse, and Business Intelligence concepts and best practices.
  • Experience creating multi-layer Framework models.
  • Experience creating Dashboards in Cognos Analytics.
  • Experience creating Data Modules in Cognos Analytics.
  • Experience designing, developing, and managing ETL processes.
  • Required 3+ years of experience with Cognos Data Manager or DataStage.
  • Working knowledge of the following DBMS: Oracle 10/11g, SQL 2008 -2016.
  • Exposure to database performance techniques including aggregation, partitioning, and indexing.
  • Experience with Cognos Planning Analytics (TM1) is a plus.
  • Applied knowledge of the application development life cycle. Experience with both Agile and Waterfall methodologies is a plus.
  • Ability to define problems, analyze data, establish facts, and quickly draw valid conclusions.
  • Experience within key business domains such as sales, marketing, inventory, forecasting, and financial reports.
  • Demonstrated ability to build rapport with potential and existing customers.
  • Excellent communication and collaboration skills, both verbal and written.
  • Must be comfortable presenting ideas, solutions, and information to Management and Peers across the Organization.
  • Demonstrated ability to meet deadlines, follow development standards, and effectively raise critical issues and provide potential solutions.
  • Ability to work with technical and non-technical stakeholders to accomplish business objectives

    Don't hesitate! Submit your resume today.

    SMCI is an EEO employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, national origin, disability, age, genetic information, marital status, military, and veteran status. Members of minority groups, Vietnam Era Veterans and individuals with mental or physical disabilities are encouraged to contact us regarding employment opportunities. In addition, in order to support the provision of business to minority-owned and Women-owned businesses (MWBE), such MWBE are encouraged to contact us regarding subcontracting business opportunities with our firm.

    (No third parties, please)
    (H1 sponsorship currently unavailable)
    (Local candidates only, please)
  • Posted By

    SMCI Tampa

    Dice Id : 10518766
    Position Id : F190083
    Originally Posted : 3 months ago
    Have a Job? Post it