Business Intelligence Software Engineer
RCM Technologies is a leading provider of IT Business Solutions and Professional Engineering Services to over 1,000 clients in the commercial and government sectors. RCM partners with clients to define, implement, and manage a broad range of technologies across multiple platforms, systems, and networks.Our broad geographic presence ensures that a proven and reliable tactical and strategic capability is available and deployable virtually everywhere in North America.RCM Technologies has an immediate need for a Business Intelligence Software EngineerSummaryThis position is responsible for design, development of dashboards, and reporting sourced from the internal enterprise data store (EDS). This position will collaborate with Business Stakeholders, Business Leaders, and subject matter experts to design, develop and support Business Intelligence (BI) information (reports, dashboards, self-service apps). This position will gather requirements, perform analysis and translate business reporting requirements to BI Report technical specifications. The BI Software Engineer will design, build and deploy business intelligence reports and dashboards using a variety of front end visualization tools (Tableau, SSRS, and Excel). The successful candidate must be able to play multiple roles including architect, report developer, metadata modeler, SQL programmer, and end user trainer/mentor.OrganizationThis position reports directly to the Data Management Manager and has significant interaction with members of the IT organization, Third Party Administrators, group managers, and departmental analysts throughout the organization. In addition, interaction with the PMO for prioritization and reporting and Relationship Management who owns the business interface function will be critical and ongoing.Duties and Responsibilities* Develop automated reports and dashboards using Tableau, Essbase, SSRS, Excel and other reporting tools* Gather and understand business requirements to set functional specifications for reporting applications* Clearly convey the key insights or "story" the data reveals in a visual format that is grouped, summarized, or formatted to be easily understood and actionable* Gathers and prepares data from multiple sources to support information analytics* Define or assist with best practices during implementation and integration of the various reporting tools* Ability to work in a highly collaborative environment with minimal supervision.* Provide input to project planning, status and review meetings.* Perform unit and integration testing and participate in reporting validation and QA efforts as they pertain to reporting and data analytics* Responsible for the collection, analysis, interpretation and summarization of data in the generation of data marts and repositories* Designs and or develops database objects (databases, tables, stored procedures, DTS Packages) to support the collection, tracking and reporting of business data* Designs, develops and supports reporting tools that utilize advanced features in MS Excel and MS Access, ie VBA, macros* Work with Developers to automate reports and processes* Responsible for acting in a consultative position for answering questions about the available data and the data that it is possible to capture from the third party systems* Responsible for providing support for miscellaneous data projectExperience and Education RequirementsRequired* Bachelor's degree (preferred emphasis in computer science or MIS)* Minimum 5 years' experience in IT and business intelligence* 2+ years' experience creating advanced reports using Microsoft SSRS, Essbase and/or Excel* Knowledge of SQL with the ability to write complex SQL queries* Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures* Strong Tableau / Power BI application development, including visualization, parameters and report optimization* 4 + years of experience with SQL Server 7.0 or higher* Thorough understanding of the software development life cycle* Excellent/proven troubleshooting and problem resolution skills* Experience in creating Data Marts and other Data Warehousing practices* Strong time management and organizational skills to enable productivity in a fast-paced, dynamic development environment* Knowledge of proper database normalization, indexing, transaction protection and locking is essential* Customer and results oriented* Strong technical documentation ability* Strong verbal communication skills and a demonstrated ability to work effectively in team-based development projects* Excellent oral and written communication skills* Must have a teamwork focused attitude and be skilled at building relationships within IT organizations and across business functionsPreferred* experience with Life Insurance and Indexed Annuity systems* Experience with database design/modeling tools such as Erwin* Familiar with Big Data, Master Data Management strongly preferredPosted by StartWire.