Kronos Business Intelligence Data Warehouse Analyst in Lowell, Massachusetts
Business Intelligence Data Warehouse Analyst
Lowell - Massachusetts - USA
Business Intelligence Data Warehouse Analyst, Kronos, Incorporated, Lowell, MAResponsible for the detailed design, planning, construction, deployment and support of technical components required for Kronos data warehouse data integration needs specifically within the Finance business group. Specific responsibilities will include the following:• Working with project and business stakeholders to understand the business requirements in order to define a design that best meets business and technical needs.• Handling end-to-end process integrations, customization, maintenance and deployment of middleware components on iPaaS platforms including Informatica Cloud, Boomi or Mulesoft.• Defining the integration and dataflow architectures, and designing the APIs that can be a point of stability to develop against in the short term and will endure as the platform technologies around them change.• Collaborating with business analysts, data architects and solution architects during data modeling, data mapping and system specification activities.• Transforming business-oriented functional specifications into detailed technical specifications.• Diagram technical decompositions, describe technical processes and data components, and design exception handling and controls.• Ensuring technical standards and architectural best practices are consistently followed by all team members and 3rd party vendors.• Ensuring code base traceability to design and development and ensuring dependencies are met and proper packaging and deployment strategies are followed.• Evaluating and estimating integration efforts for projects and change orders.• Coordinating, controlling and reviewing work deliverables for on-site and off-shore developers.• Overseeing developers in unit and string testing and consistently delivering on time and high-quality products.• Conducting technical code reviews, providing project related status reporting, coordinating all release planning and guiding the development team through all project phases.• Collaborating with QA team to develop and execute test strategies and plans.• Participating in QA, UAT and production support related to the project.• Leading release and implementation activities, including providing input into implementation planning efforts.
Qualifications:This position requires either (i) a Bachelor’s degree (or equivalent foreign degree) in Computer Science, Information Systems or Technology and 4 years of experience as a Data Warehouse Analyst or (ii) 6 years of experience as a Data Warehouse Analyst. In either case, this experience must include 3 years in a Team Lead position.Must also have experience working with the following:• Using Informatica PowerCenter with multiple database systems (SQL Server and Oracle).• Developing complex SQL statements, PL/SQL packages and procedures.• Writing and executing UNIX shell scripts and managing job scheduling.• Working with SaaS based products and technologies including specifically SOAP, REST & XML and SaaS integration technologies including Informatica Cloud and Dell Boomi.• Oracle EBS.• Data Warehouse data modeling principles.Will accept any qualified combination of education, training and/or experience.
Youre empowered when youre a Kronite.
Want to be part of an elite group of highly skilled professionals?We think our employees are a special group of talented, energetic, and innovative people. And for that reason, we refer to ourselves as Kronites. Kronites care about more than just work. We recognize the need to maintain a healthy work-life balance to live inspired. In fact, its expected! Youll soon learn that we take work and fun seriously. No matter what position you hold at Kronos, youre a Kronite. And we want you to feel like you have the power to make a difference in your life and the lives of others, at work and beyond.
Kronos is a global provider of workforce management and human capital management cloud solutions. Kronos industry-specific workforce applications are purpose built for businesses, healthcare providers, educational institutions and government agencies of all sizes. Tens of thousands of organizations including half of the Fortune 1000® - and more than 40 million people in over 100 countries use Kronos every day.
Kronos is proud to be an equal opportunity employer and is committed to maintaining a diverse and inclusive work environment. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, physical or mental disability, age, or veteran status or any other basis protected by federal, state, or local law.