Senior Solutions & Business Intelligence Architect - Remote

Make a difference. Be happy. Grow your career.

The Senior Solutions & Business Intelligence (BI) Architect will manage a delivery team to analyze and implement enterprise business intelligence capabilities for Nordic. The individual will be responsible for defining the architectural platform(s), associated data models and ETL /ELT processes used to build out enterprise reporting and application functionality built off the enterprise data warehouse. In addition, the individual will help business draw key insights and findings based on intelligence findings. The individual will interact with internal stakeholders and communicate critical project requirements within Nordic. The individual will also manage ETL and BI Developers and direct their efforts to reach organizational goals in a timely manner.

The Senior Solutions & Business Intelligence (BI) Architect will have the following responsibilities, including but not limited to:

• Perform solution architecture capabilities, business architecture, data architecture and technical architecture skills and knowledge
• Create and support business intelligence platforms such as Azure and DBT Cloud, as well as the 3rd normal form data models and/or dimensional models to support analytic and reporting insights
• Lead and support the enterprise design, development, and analysis of the data architecture and warehousing approaches
• Implement, integrate, and extract data from applications across the organization
• Lead data Integration from source systems to target databases using SSIS, Microsoft Data Factory, Fivetran and DBT Cloud
• Lead technical guidance for design and implementation of data storage and governance systems
• Develop, maintain, support, and enhance the business intelligence data backend
• Design, code, test, and aggregate results using Power BI and/or Tableau
• Map configurations and complex data architectures, ensuring documentation meets current and forecasted reporting needs
• Design, code, and manage developers' projects to meet specifications for end user data, business systems, dashboards, and tools
• Operate in an agile environment, following best practices for CI/CD as part of the software development life cycle (SDLC)
• Collaborate and work with end users to ensure that data and reports meet their business needs
• Design and monitor end-user reports to ensuring reports are accurate and up to date
• Audit data and take steps to remedy data quality issues, including making source system recommendations to increase data quality for end user reporting
• Create technical documents to document database or other system contents, concepts, and mapping between databases
• Create and maintain physical and virtual data models and dimensions to support business
• Design, code, test, and aggregate results from SQL queries to provide information to users
• Collaborate with internal operations experts to understand their data needs, provide insights, and develop user-friendly reporting to support decision making and process improvement initiatives
• Collaborate with members of the BI, IT, and operational teams to drive data governance

Skills and Experience

• Post-secondary or equivalent experience in Business, IT, or related field required
• Must have at least 10 years of professional work experience in data warehouse, business intelligence, analytic, reporting, data governance and metadata skills
• 7+ years experience in Healthcare IT; with direct involvement in Payer and/or Hospital/Health System/Practitioner deployment of business operations, processes, procedures, solutions, applications, data models and business intelligence
• 5+ years experience with Operations and Financial analytics, metrics and KPIs
• 3+ years experience with Power BI
• Experience with NetSuite and WorkDay is preferred
• Experience with SalesForce Health Cloud and/or SalesForce Marketing Clous is a plus
• Advanced SQL skills and experience with reporting and visualization tools required
• Must be proficient with system databases and developing business intelligence solutions
• Experience with an object-oriented programming language like python is preferred
• Strong communication skills and ability to build relationships with a variety of internal customers
• Detail-oriented with ability to dig into the weeds while keeping the big picture reporting goals in mind
• Demonstrated success in establishing rapport quickly and collaborating within an organization
• Ability to work and communicate effectively and efficiently across all levels of an organization, both written and verbal
• Ability to work independently and within a team environment
• Excellent interaction skills, collaborative work style, and interpersonal skills
• Must demonstrate and embody Nordic's maxims

Additional Details

• Working in Madison, WI, is not required. Travel to the Nordic offices, or client offices, may be required at times