Business Intelligence/Data Analytics Developer

Our client, an investment management firm, is searching for a Business Intelligence/Data Analytics Developer. This is a permanent role that requires employees to be onsite 5 days per week in Jersey City, NJ. The job description is as follows:

Location: Jersey City, NJ

Job type: Permanent  

About the role:

As a Senior Software Engineer specializing in Data Analytics with a focus on Cognos and data management, you will be a key player in designing, developing, and implementing robust data analytics solutions supporting HCM and Compliance business needs. The ideal candidate will have a strong background in software engineering, a deep understanding of data analytics principles, and hands-on experience with Cognos, Power BI and database/SQL development.

We’ll trust you to:

·         Cognos Development:  Design, develop, and maintain Cognos & Power BI reports and dashboards to provide actionable insights for business stakeholders.

·         Data Modeling: Work closely with data engineers and analysts to design and implement effective data models that support business reporting and analytics requirements.

·         Integration: Integrate solutions with other systems and data sources to create seamless and automated reporting processes.

·         Collaboration: Collaborate with cross-functional teams, including data scientists, business analysts, and software engineers, to gather requirements and ensure alignment with business goals.

·         Quality Assurance: Conduct thorough testing of Cognos/Power BI solutions to ensure accuracy, reliability, and adherence to business requirements.

·         Documentation: Create and maintain technical documentation, including data models, report specifications, and user guides.

·         Training and Support: Provide training and support to end-users, helping them understand and maximize the value of Cognos/Power BI analytics.

You'll need to have:

·         Bachelor's or Master's degree in Computer Science, Software Engineering, Data Science, or a related field.

Proven experience as a Senior Software Engineer with a focus on data analytics and UKG Cognos Reporting and various data integration across systems.

Familiarity with HCM and/or Compliance applications:

·         Good to have understanding of HCM and/or compliance applications and business domain.

Database and Data Integration:

·         Strong foundation in SQL for querying and managing databases.

·         Understanding of data warehousing concepts, including star and snowflake schemas.

Report Optimization:

·         Skills in optimizing Cognos reports for performance.

·         Proficiency in using Performance Analyzer and other tools to diagnose and address performance issues.

Data Governance and Security:

·         Experience in implementing row-level security to manage user access to data based on role or other criteria.

·         Understanding of the best practices for setting up RLS to ensure data security and compliance.

·         Solid programming skills in languages such as SQL, Python, or similar.

·         Experience with data integration and ETL processes.

·         Strong understanding of database systems, data warehousing, and data visualization best practices.

·         Excellent problem-solving and analytical skills.

·         Effective communication skills and the ability to work collaboratively in a team environment.

Preferred Skills:

·         Cognos certification.

·         Experience with other data visualization tools and platforms.

·         Familiarity with cloud platforms such as Azure or AWS.

·         Strong experience in the Financial Services domain.  Experience in the Client Services and Sales Enablement space (B2B) is preferred.​

Profile:  Applications support engineer:

• Providing software application support under the supervision of the Team lead/Tech lead.
• Performing analyses on software application functionality and suggesting improvements.
• Ensuring effective front-end and back-end functionality of applications.
• Consulting with the software development team, internal users, and clients to improve application performance.
• Managing code migration across environments to ensure continued and synchronized functionality.
• Establishing the root causes of application errors, and escalating serious concerns to the Senior Engineer.
• Documenting processes and monitoring application performance metrics.
• Providing SAAS platform support to clients and colleagues in other departments

Application Support Engineer Requirements:

• A bachelor's degree in software engineering, computer science, information technology, information systems, computer engineering, or similar.
• Demonstrable experience as an application support engineer in a related field.
• Hands on experience with the Cognos reporting tool and working knowledge of BI concepts.
•  Hands on experience with front-end and back-end programming languages, such as React, Java, DB Stored procedures, Javascript, Python, and Ruby.
• Hands on experience with DB's such as Oracle, SQL Server, Postgres etc using stored procedures, functions as well as SQL and writing efficient SQL queries.
• Working knowledge of data management (e.g. permissions, recovery, security and monitoring)
• Ability to manage code migration, document configuration changes, and monitor performance.
• Ability to provide front-end support to internal departments and web-based clients.
• Proficiency in determining the causes of application errors and repairing them.
• Ability to keep up with innovation in application design.
• Exceptional communication skills.

Optional skills:

• Domain knowledge in HR, Compliance or Finance
• Experience in SAAS platforms for HR including UKG
• Experience in SAAS platforms for Compliance including Global Relay, Castine and PTA
• Experience with reporting software such as Cognos. 
• Working knowledge of cloud toolsets such as AWS or Snowflake​