Senior Software Engineer - Data Analytics

$150,000 - $150,000/Yr

Open Systems Technologies - Jersey City, NJ

Full-time - Senior

Jersey City, NJ

Professional, Scientific, and Technical Services

About the position

The Senior Software Engineer - Data Analytics position at a financial services firm in Jersey City, NJ, is a critical role focused on designing, developing, and maintaining reporting solutions using Cognos and Power BI. This position requires a strong understanding of data analytics and the ability to create actionable insights for business stakeholders. The successful candidate will work closely with data engineers and analysts to implement effective data models that support business reporting and analytics requirements. In this role, you will be responsible for integrating solutions with various systems and data sources to create seamless and automated reporting processes. Collaboration with cross-functional teams, including data scientists, business analysts, and software engineers, is essential to gather requirements and ensure alignment with business goals. You will conduct thorough testing of Cognos and Power BI solutions to ensure accuracy, reliability, and adherence to business requirements. Additionally, you will create and maintain technical documentation, including data models, report specifications, and user guides, to support the development and use of these analytics tools. Providing training and support to end-users is also a key aspect of this role, helping them understand and maximize the value of Cognos and Power BI analytics. This position offers an exciting opportunity to leverage your technical skills in a dynamic environment while contributing to the overall success of the organization.

Responsibilities

• Design, develop, and maintain Cognos & Power BI reports and dashboards to provide actionable insights for business stakeholders.
• Work closely with data engineers and analysts to design and implement effective data models that support business reporting and analytics requirements.
• Integrate solutions with other systems and data sources to create seamless and automated reporting processes.
• Collaborate with cross-functional teams, including data scientists, business analysts, and software engineers, to gather requirements and ensure alignment with business goals.
• Conduct thorough testing of Cognos/Power BI solutions to ensure accuracy, reliability, and adherence to business requirements.
• Create and maintain technical documentation, including data models, report specifications, and user guides.
• Provide training and support to end-users, helping them understand and maximize the value of Cognos/Power BI analytics.

Requirements

• A Bachelor's or Master's degree in Computer Science, Software Engineering, Data Science, or a related field.
• Experience as a Senior Software Engineer with a focus on data analytics and UKG Cognos Reporting and various data integration across systems.
• Strong foundation in SQL for querying and managing databases.
• Understanding of data warehousing concepts, including star and snowflake schemas.
• Skills in optimizing Cognos reports for performance.
• Proficiency in using Performance Analyzer and other tools to diagnose and address performance issues.
• Experience in implementing row-level security to manage user access to data based on role or other criteria.
• 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.

Nice-to-haves

• 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.