The Business Intelligence Developer will focus on developing, maintaining, and supporting MicroStrategy dashboards, documents, and reports in each phase of the development lifecycle, with tasks varying according to project. As a member of our Business Intelligence team, this individual will help lead the efforts of understanding technical requirements, data analysis for reporting, documenting design approaches for reporting, and development/testing of reports and static/dynamic role-specific dashboards intended for desktop and mobile consumption. An ability to write moderate to complex SQL and an ability to understand the architecture and semantic structure within MicroStrategy will be necessary to perform these tasks. Other coordination responsibilities will include preparing documents for the migration of components between environments, governance of the organization of the environments, some automation of back-end processes and training of user groups. This role will work closely with internal team members, external augmented resources, and cross-functionally across the IT organization in delivering these solutions.
This position provides an opportunity to transition from other private, public, government or military environments to a 3M career.
Primary Responsibilities include but are not limited to the following:
Create document style (RSD) reporting, including the creation of Narrowcast services for automated report delivery.
Assist in Business Intelligence design efforts of new project initiatives, including meeting with subject matter experts on data, profiling data, and prototyping
Actively participate in requirements gathering sessions and ongoing best-practice definition discussions
Support project implementation through the management and migration of MicroStrategy components in partnership with the support team
Collaborate with the various stakeholders to ensure consistency within the environment, release management, and the effective use of standards and best practices
Partner with MicroStrategy Architects, Data Architects, and DBAs to resolve reporting inefficiencies.
Multitask and re-prioritize efforts on a regular basis
Collaborate with business partners and other technical staff to understand functional requirements and create system requirements, assess available technologies and recommend solution options.
Assist and mentor less experienced colleagues with standards and best practices)
Actively participates in relevant corporate programs/initiatives, complies with professional and quality standards, complies with corporate policies and procedures, and acts in a manner consistent with 3M’s values and ethical standards.
Bachelor’s Degree or higher from an accredited university OR High School Diploma/GED or higher from an accredited institution AND a minimum of four (4) combined years of experience with SQL and/or Report BI Development (coursework/Internship included) in lieu of the Bachelor’s degree education requirement
One (1) year of experience developing dashboards and reports using an enterprise Business Intelligence or Reporting platform
One (1) year of experience building solutions comprised of analytics derived from large data warehouses and/or equivalent large data sets
One (1) year of experience building simple to complex SQL queries
Preferred experience using MicroStrategy 9 or later (Desktop, Web, Intelligence Server, Architect) or any comparable Business Intelligence platform
Bachelor's degree in Computer Science, Mathematics, Statistics, Data Science or related field
Certification as MCD (MicroStrategy Certified Developer)
Solid understanding of relational structures, dimensional data modeling, Data Warehouse and BI techniques.
Experience on techniques using Filters, Prompts, Templates, Hierarchies, Metrics, and Attributes.
Ability to troubleshoot and research data and reporting issues
Demonstrated experience in dashboard and report development, testing, tuning, scheduling report delivery and alerts.
Work experience in the healthcare industry and/or with healthcare data
Demonstrated abilities in creative problem solving and critical thinking
Proficiency with Microsoft Office products
Excellent time management skills
Strong communicator, possessing interpersonal skills and judgment in order to interact effectively with a broad spectrum of people, both individually and in groups
Excellent analytical and documentation skills
Highly motivated and a self-starter
Agile development methodology experience
Location: Albany, NY; Overland Park, KS; Atlanta, GA
Travel Requirements: Occasional travel may be required
Relocation: Relocation is approved.
Must be legally authorized to work in country of employment without a sponsorship for employment visa status (e.e. H1B status).
Supporting Your Well-being
3M offers many programs to help you live your best life – both physically and financially. To ensure competitive pay and benefits, 3M regularly benchmarks with other companies that are comparable in size and scope.
Resources for You
For more details on what happens before, during and after the interview process, check out the Insights for Candidates page at 3M.com/careers.