Software Developer II

Company: ApTask
Location: Broomfield
Posted on: May 27, 2023

Job Description:

Job Description
Seeking two SW Developer II Candidates to join the Service Assurance Operations Business Analytics team. Each candidate will play a key role in developing management and BI reporting for our organization. At least one or both candidates will have expertise in SQL Server, SSIS development and complex SQL query language, as well as Microsoft Power BI and/or in-platform ServiceNow development.
As a member of the Service Assurance Business Analytics team, you will be responsible for end-to-end creation of reporting and data automation solutions. You will be responsible for scoping, developing, testing and supporting the solutions you create. You will combine deep technical knowledge with a capacity to understand the reporting and analytics needs of our front-line business teams.
What you need to apply:
Candidate 1: 5+ years' experience in ServiceNow development including design, development, troubleshooting and implementing baseline and custom applications to enhance the platform. Preferred experience with Performance Analytics, metric development, SLA definitions, business rules, case and ITSM modules, configurable workspace, reporting, dashboards, etc...
Candidate 2: 5+ years' experience with SQL Server DBA, including the design and development of complex SQL-based database objects and SSIS packages, including implementation, configuration, maintenance and system health and performance. 5+ years' experience in developing visual reports, KPI scorecards and dashboards using Power BI Desktop, supporting complex data extract, transformation and load (ETL) and the ability to identify BI application performance issues and performance-tuning.
Ideal candidate will be able to pass a U.S. Public Trust screening for potential U.S. Federal work.
Experience with database systems, reporting and analysis tools such as: MS SQL Server (SSRS, SSIS, SSAS), Power BI, MySQL, SalesForce, Oracle BI, SAP Business Objects, MS Excel, MS Access, Tableau, etc
Experience with Programming languages such as: JavaScript, MYSQL, XML, HTML, CSS, C#, VBA, Query Languages (SQL, T-SQL, PL/SQL, DMX, MDX), DAX, etc
Experienced in Business Intelligence and Data Warehousing concepts and methodologies.
Excellent written and verbal communication skills required to communicate with business leaders and end users.
Strong attention to detail, analytical skills, research and problem-solving skills.
Strong collaboration and communications skills.
Project management skills and process improvement skills.
Telecommunications industry experience preferred.
Genesys Cloud experience preferred.
Competencies
Strives for excellence: You possess a strong ability to work both independently and in a team environment, be self-motivated and willing to expand their knowledge continually. By continually upgrading your own work, you achieve results and outperform the competition. You are a continuous learner who encourages others to learn and are willing to share your knowledge to help others.
Implementation/Execution: You are good at organizing and managing multiple priorities and/or projects by using appropriate methodologies and tools.
Problem-Solving: You are a problem solver with the ability to encourage others in collaborative projects and initiatives. Acting both as a broker and consultant regarding resources, you engage others in problem-solving without taking over.
Accountability: You meet clearly stated expectations and take responsibility for achieving results.
What you will be doing:
Be involved in all aspects of the development life cycle including, requirements gathering, architecture, development, testing, training, implementation and support of reporting applications to be used internally by our employees.
Translating business needs into technical specifications in applications and tools such as Power BI and ServiceNow.
Using warehouse data and application data to generate reports to support business decision-making and business performance monitoring.
Create complex SQL queries and database objects (stored procs, views, etc) to pull and manage data.
Develop complex SSIS packages to extract, transform and load data to feed Microsoft Power BI dashboards and reports.
Develop front end reporting applications using applications such as Microsoft Power BI and/or ServiceNow for in-platform reporting and analytics.
Evaluate and improve existing BI systems and resolve data and reporting issues identified from business partners.
Provide data and programming expertise to meet internal ad hoc data requirements.
Generate and deliver quality reports to customers and perform quality assurance checks on reports.
Troubleshoot complex coding issues that require back-tracing logic through multiple packages, stored procedures and data sources.
Review business processes and translate them into BI reporting and analytics solutions, while following best practices and standards.

Keywords: ApTask, Broomfield , Software Developer II, IT / Software / Systems , Broomfield, Colorado