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

• Must have at least 10 years of professional work experience in data warehouse, business intelligence, analytic, reporting, data governance and metadata skills
• Must demonstrate and embody Nordic's maxims
• Post-secondary or equivalent experience in Business, IT, or related field required
• Advanced SQL skills and experience with reporting and visualization tools required
• Healthcare data experience is preferred
• 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 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

Additional details

• Ability to travel up to 25% of the time